Shulou(Shulou.com)06/01 Report--

1. The replication principle and process of MySQL

(1) ask the fundamentals first, the flow of three threads and the relationship between them

(2) reask the consistency delay and data recovery

(3) ask again the solution of replicating bug encountered in all kinds of work.

2. The difference between myisam and innodb in MySQL, at least 5 points.

(1) the question is different at 5 points

(2) ask about the improvements of the two different versions of mysql

(3), the implementation of the index of the two.

3. Ask the difference between varchar and char in MySQL and the meaning of 30 in varchar (50).

(1) the difference between varchar and char

(2), the meaning of 50 in varchar (50)

(3) the meaning of 20 in int (20)

(4) Why is MySQL designed in this way.

4. Ask how to realize the transaction and log of innodb.

(1) how many kinds of logs are there

(2) the storage form of the log

(3), how the transaction is realized through the log, the more in-depth the better.

5. Asked about several log entry formats of MySQL binlog and their differences

(1) the meaning of various log formats

(2) applicable scenarios

(3) combined with the first question, the advantages and disadvantages of each log format in replication.

6. What will he do if the cpu of MySQL database soars to 500%?

(1) if you have no experience, you don't have to ask.

(2) if you have experience, ask them how to deal with it.

7. Sql optimization

(1) the significance of all kinds of item from explain

(2), the meaning and usage scenario of profile

(3) the index problem in explain.

8. Backup plan, mysqldump and the implementation principle of xtranbackup

(1) backup plan

(2) backup recovery time

(3) how to deal with backup and restore failure.

9,500 db, restart within the fastest time

10. What is the biggest MySQL DB problem you encounter in your current job?

11. Optimization of read and write parameters of innodb

(1), read parameters, global buffer pool and local buffer

(2), write parameters

(3) parameters related to IO

(4), cache parameters and applicable scenarios of cache.

12. Please briefly describe the names of the four transaction isolation levels supported by InnoDB in MySQL, and the differences between them.

13. There is a large field X (for example, text type) in the table, and field X will not be updated frequently, mainly for reading.

(1) do you choose to split the child table or continue to put it together

(2) write down the reasons for your choice.

14. What is the row lock of the InnoDB engine in MySQL accomplished (or implemented) by adding to it? Why is it like this?

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.