This article covers 52 SQL statement performance optimization strategies. 1, to optimize the query, try to avoid full table scan, first should consider WHERE and...
After the application is released to the production environment, the front-end page requests the background API to return data, which takes at least 6 seconds....
User_auto_key user_uuid user_random_key user_auto_key user_uuid user_random_key user_auto_key Using the control variable method, we only generate the primary key of each table using a different strategy,...
Partitioning introduces new ways to optimize queries (with some pitfalls, of course). The biggest feature is that the optimizer can use partitioning functions to filter...
Both queries and updates are performed using Buffer pools. Therefore, the importance of Buffer Pool is self-evident. This paper will have an in-depth understanding of...
Usually want to install a software, as long as the real resources found, the installation is really minute things. Of course, installing database software is...
MySql 5.7 deployment (test Centos7.5 stable operation for more than a year) 1. Prepare the RPM package to https://dev.mysql.com/downloads/mysql/5.7.html to download the address
From the work of SQL statement problems, learning MySQL implicit type conversion rules, a brief introduction to the whole process, recorded, to avoid stepping on...
This section describes in detail the process of operating MySQL data, including data CRUD, various query methods, and different experiences. Include common problems in the...
This article first introduces all kinds of lock types and lock mechanism of MySQL, and then takes you to understand how to analyze deadlock problems...