MySQL Tutorials

This article mainly describes the MySQL master-slave replication and read and write separation of the implementation, the following MySQL master-slave replication source. How to install MySQL database, do not say here, just say its master-slave copy,

MySQL database Chinese characters garbled how to do ? How to solve the problem of Chinese garbled after MySQL data import? How to solve? The first two days of the project used to contain Chinese text field data CSV file, using Workbench import file

the data structure and algorithm principle behind MySQL index First, the definition Index definition: Index is the data structure that helps MySQL to get data efficiently.Essence: An index is a data structure. Second, B-tree M-order B-tree meet the

This article will focus on four types of masql database indexes, how do database indexes be built? The columns that appear in the where and join need to be indexed, but not entirely, because MySQL uses the index only for ,>=,between,in, and

Traps in the 4.2MySQL schema design Because the MySQL implementation mechanism causes some specific errors, how to avoid them, and slowly: 1. Too many columns The MySQL storage Engine API works by copying data in a row-buffered format at the server

let me sigh: The DBA is really not a cover 3.3.3 Usage Profiling: Limited 3.4 Diagnosing the problem of simple break If the system occasionally pauses, slow query, call shadow problem, try not to use the wrong way to solve the problem: the risk is

In the MySQL write statement, the table column assignment and table type does not match, the MySQL bottom of the optimizer to play a role, will do a forced type conversion, this time can be normal operation, but will cause row lock escalation to