Binary logs, which record SQL statements that have changed or potentially changed data and are stored in binary format on disk. Main functions: replication, recovery,...
There are many reasons for garbled characters in MySQL, usually related to the character_set parameter. The most important parameters are character_set_client and Character_set_results. What is...
First, we analyzed two groups of basic knowledge: shared and exclusive locks, snapshot read and current read. Secondly, we fuse the two groups of basic...
From the figure, you can see that the top layer of MySQL is the connection component. The following servers are composed of connection pools, administrative...
Requirement 1) Query the proportion of consumption sum of all products in all time, sort the proportion in descending order, screen the products with the...
Buffers are prone to interference in the understanding of the core context. But buffers are important, so let's look at the relationship between logs and...
On October 24, 2017, Zhizhidang MySQL technical expert Wu Bingxi delivered a speech on "MySQL High Expansion Architecture Design" in "2017 MySQL Technology Exchange Conference...
Preparations for download sakila database https://dev.mysql.com/doc/index-other.html first to the above address. This is the prepared test data where the query is slow? Look at this...
The overall technical architecture is deployed using docker container, which, together with Docker Compose, uniformly mounts the container data to a separate folder. In this...
MySQL 5.5 Eclipse MySQL connection driver mysql-connector-java-5.1.18-bin.jar To add the JAR package to the project, right-click the project, and choose
MySQL is a small open source relational database management system (RDBMS) that uses SQL (Structured Query Language) for database management. MySQL is an open source...
Background Recently, the frequent occurrence of slow SQL caused system performance problems, so it was decided to perform some optimization for indexes. Some table structures...
JDBC database connection, JavaBean is what, function. Location and function of the configuration file. Custom utility classes (extract duplicate code, reduce code redundancy, high cohesion...
Mysql > alter table auto_increment mysql > alter table auto_increment mysql > alter table auto_increment mysql > alter table auto_increment mysql > alter table auto_increment...
This article is a detailed analysis of the common ways of MySQL performance optimization. We quarrymen should have the heart of the Cathedral, let us...
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...
First, performance tuning is an ongoing process, and installing MySQL is usually the first step in adjusting the operating system and database configuration. A database...
MySQL is a cross-platform open source relational database management system. At present, MySQL is widely used in small and medium-sized websites on the Internet. Due...