We've looked at MySQL index selection, InnoDB data structure selection, index, overwrite index, query optimization in detail. Today we introduce database global lock, table lock,...
Binary files are used for backup, restoration, and primary/secondary environments. MySQL provides a sync_binlog parameter to control the binlog flush of the database. The default...
This article will learn the transaction isolation level of MySQL through practice. 1. READ UNCOMMITTED Level We can see that a transaction in terminal B...
MyCat is an open source database middleware developed by the open source community on the basis of Ali Cobar using Java. Mycat1.6 official website Mycat1...
For small - and medium-sized projects, joint table queries are a common operation, especially when making reports. However, when you proofread the data, did you...
SQL: Structured Query Language DBMS: a database management system, such as MySQL schema: used to describe specific tables in a database and the entire database,...
In the middle of this year, our company reached an in-depth cooperation with Tencent, involving a large amount of data. Sure enough, after talking about...
Build mysql master-slave synchronization based on Docker container. Practice using them and correct them if they are not correct. We will continue to update
The following describes the structure of the employee information table. Field Name Field Description Field Type Field Length Constraint EMPNO Employee ID 8 PK ENAME...
There are now two tables, a Shool table and a student table. Inserting 1000 data each (using STRAIGHT_JOIN) prevented the Mysql optimizer from automatically optimizing....
Now in the website and APP development, check-in is a very common function, such as microblog check-in points, check-in leaderboards, microblog check-in such as mobile...
Cobar is an open source MySQL distributed processing middleware developed by Alibaba, which can provide massive data services in a distributed environment just like traditional...
MySQL provides a wealth of data types and functions for storage and analysis of spatial data. Learning such functions can help us better process geographic...
Relational database is easy to become a system bottleneck, single storage capacity, connection number, processing capacity are limited, when the amount of data and concurrency...
Connectors establish connections to clients, obtain permissions, and maintain and manage connections. Typically we access the database in the following form. This mode is TCP/IP....
As you can see, MySQL's wildcards are useful. But this functionality comes at a cost: Wildcard searches generally take longer to process than the other...
Common load balancing schemes include F5, HAProxy, and LOADBalance in JDBC. F5 is not something that developers can play on their own. HAProxy needs to...