Database sub-database sub-table estimates that many partners have not practiced, because their own company's business is not a lot, there is not so much data....
MySQL is an open source, relational database management system. The word "SQL" in "MySQL" stands for "Structured Query Language," the most common standardized Language for...
What is read-write separation? The role of reading and writing separation will not be discussed, if there is no understanding of the students can search...
Locality Principle To understand the underlying principle of mysql indexing, you must know the locality principle. In order to read data from disk, you must...
The first step of big data analysis in the existing architecture is how to change data from relational database to non-relational database. There are many...
This article mainly summarizes some common operations in the work, as well as unreasonable operations, in the slow query optimization to collect some useful information...
Using Sharding-JDBC to achieve sub-database sub-table + read and write separation Based on user_id to divide the c_order table data pair master1 and Master2 set...
Mysql RC and RR MVCC implementation; What is MVCC? What are current and snapshot reads? How do implicit fields, undo logs, Read Views solve unrepeatable...
In standard SQL, CHECK constraints can be implemented through CREATE TABLE or ALTER TABLE statements, and are defined according to the user's actual integrity requirements....
MySQL series infrastructure, introduces the architecture design of MySQL, storage engine, file storage layer, etc., you can understand the operation mechanism of MySQL from the...