Moment For Technology

6 MySQL deadlock cases, understand the cause of deadlock!

Mysql has three lock levels: page-level, table-level, and row-level. Table lock: low overhead, fast lock; No deadlocks occur; The lock granularity is large, and the probability of lock conflict is high and the concurrency is low. Row-level lock: expensive, slow lock; Deadlocks occur; The lock

Navicat MySQL easy tutorial

In the daily use of MySQL, we may often use visual tools to connect to MySQL, among which Navicat is the most commonly used. At ordinary times, some students will ask Navicat how to install, how to use and other problems. In this article, I will share a simple tutorial on Navicat operating MySQL based on my personal experience. Nav...

MySQL advanced features (4) : View principle analysis

A view is actually a virtual table that does not store data itself. The actual data for this virtual table is the result of an SQL query that accesses the view. This article introduces the implementation mechanism and characteristics of views.

MySQL - Index details

Indexes depend on the implementation of storage engines, so each storage engine may not have the same index, and each storage engine may not support all index types. All storage engines support at least 16 indexes per table, and the total index length is at least 256 bytes. Most storage engines have higher limits. MyISAM and InnoDB storage engine only support BTREE index, MEMORY/...

High-performance index optimization Strategy (1) : Isolate data columns and prefix indexes

Proper index creation and use is critical to query performance. There are many ways to select and use indexes effectively because of the variety of optimizations and behaviors for specific scenarios. Therefore, deciding how to use indexes is a skill that takes experience and time to develop. Here are some ways to use indexes effectively. In general, we find that query statements prevent MySQL from using indexes. Unless you're looking into...

MySQL- COLLATION cannot be ignored

The string types of the MySQL database are CHAR, VARCHAR, BINARY, BLOB, TEXT, ENUM, and SET. Different types have completely different implications for business design and database performance, of which CHAR and VARC are the most commonly used

What is the index of MySQL? How do you optimize?

Index is similar to the bibliographic index of university library, which can improve the efficiency of data retrieval and reduce the IO cost of database. MySQL performance starts to decline around 3 million records, although official documentation says 500~800w records, so indexing is necessary for large data volumes. MySQL provides Explain, which displays detailed information about SQL execution and allows for index optimization. ...

Fully understand SQL in 10 simple steps

Many programmers see SQL as a threat. SQL is one of the few declarative languages that operates in a completely different way from command-line languages, object-oriented programming languages, and even functional languages (although some consider SQL to be a functional language as well). Every day we

MySQL index design analysis

1. The simplest index assumes that the query id is 4. If there is no index, only the full table can be scanned. Now you need to design an index for the primary key, which is essentially the primary key directory. The primary key directory is to put the page number of the data page, as well as the smallest primary key value in the data page

About (Moment For Technology) is a global community with thousands techies from across the global hang out!Passionate technologists, be it gadget freaks, tech enthusiasts, coders, technopreneurs, or CIOs, you would find them all here.