MySQL Database interview

1. mysql's storage engine is different

2. Single index, federated index, primary key index

3. How MySQL is divided into tables, and what to do if you want to query by conditional paging (if you do not query by table field, almost inefficient, no solution)

4. After the table wants to make an ID multiple table is self-increment, the efficiency realization

5. mysql master-slave real-time backup synchronization configuration, as well as the principle (from the library read the main library binlog), read and write separation

6. Write SQL statements ...

7. Indexed data structure, B + Tree

8. The four characteristics of the transaction, as well as their respective characteristics (atomic, isolated) and so on, how the project solves these problems

9. Database lock: Row lock, table lock, optimistic lock, pessimistic lock

10. Several granularity of database transaction;

11. Relationship-type and non-relational database differences

MySQL Database interview