MySQL's InnoDB engine has four isolation levels for transactions, mainly to ensure data consistency. InnoDB engine provides row level locking, table locking. MyISAM provides a...
All database object names must be lowercase and underlined. Disallow MySQL reserved keywords for all database object names (if a table name contains a keyword...
Identify the problem and take the corresponding optimization measures, basically can confirm the cause of the problem. At this time, appropriate measures can be taken...
Unit testing is a very effective means to ensure the software quality, either from the perspective of the concept of early intervention test test theory...
Cloud computing has brought great advantages in business flexibility, Ali cloud database senior product experts slow from the application of the change of architecture, customer...
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...
In our daily development, optimizing SQL is always one of our daily development tasks. Routine SQL optimization can not only improve program performance, but also...
This tutorial explains how to configure an advanced LNMP environment with excellent performance, flexibility, freedom, and easy upgrade. It consists of Ubuntu + OpenResty +...
Database deadlocks are caused by inconsistent lock sequence during batch update. However, last week I encountered a very difficult to understand deadlock. I took the...
If you want to know more about Java architecture technology, you can follow me. I will also sort out more knowledge points about architecture technology...
Web Security hardening authentication in Linux helps trainees master common security hardening methods for Web applications in Linux, such as operating systems, databases, and middleware...
I recently encountered a deadlock problem, but it was the theoretical knowledge of "interview building rockets" (mainly mysql transaction locks) that helped me locate the...
According to the way of business separation, vertical sharding, also known as vertical split, its core idea is dedicated library. Before the split, a database...
Familiar with Spring, iBatis and other open source frameworks and common middleware such as message and storage. Have read through the open source framework source...
Distributed system or microservice architecture basically adopts the design of sub-database and sub-table, so the need of generating globally unique ID becomes urgent. Traditional single...
Log files record various types of activities that affect the MySQL database. Common log files in the MySQL database include error logs, binary logs, slow...
MySQL optimization ≠SQL statement optimization, which is important to understand, although most of the time we are tuning SQL statements. However, MySQL optimizations start with...
Welcome to visit netease Cloud Community to learn more about Netease's technical product operation experience. In marketing activities, lottery system brush prize, brush ticket, brush...
In the actual development of the application is not much. Because one-to-one can create a table. In this case, "category table" is called: primary table,...