MySQL dba face question

Topic from 51CTO Altar friends released finishing, http://bbs.51cto.com/thread-1470880-1.html?1

1. mysql replication principle and process

Basic principle flow, 3 threads and the association between;

2, the difference between MyISAM and InnoDB in MySQL, at least 5 points

(1), ask 5 different points;

(2), the InnoDB engine 4 major features

(3), 2 selectcount (*) which is faster, why

3. The difference between varchar and char in MySQL and the meaning of the 50 representation in varchar (50)

(1), the difference between varchar and char

(2), varchar (50) The meaning of 50

(3), int (20) The meaning of 20

(4), why is MySQL so designed

4, asked the InnoDB of the transaction and log implementation mode

(1), how many kinds of logs;

(2), 4 kinds of isolation levels of things

(3), how the transaction is achieved through the log, the more deeply the better.

5, asked the MySQL binlog several log entry format and the difference

(1) The type and distinction of the Binlog log format

(2), the applicable scene;

(3), combined with the first problem, each log format in the pros and cons of the copy.

6, asked the next MySQL database CPU soared to 500% how to deal with it?

(1), no experience, can not ask;

(2), have experience, ask them to deal with ideas.

7. SQL optimization

(1), explain out of the meaning of the various item;

(2), the significance of the profile and the use of the scene;

8, backup plan, mysqldump and xtranbackup implementation principle

(1), backup plan;

(2), backup recovery time;

(3), Xtrabackup realization principle

9, mysqldump Backup out of SQL, if I want to SQL file, a row only one insert....value (), How to do? What if the backup needs to take the copy point information of master?

10, 500 db, restart within the fastest time

11. Optimization of reading and writing parameters of InnoDB

(1), reading parameters

(2), write parameters;

(3), IO-related parameters;

(4), cache parameters, and the applicable scenarios for caching.

12. How do you monitor your database? How are your slow logs queried?

13, have you done the master-slave consistency check, if there is, how to do, if not, what are you going to do?

14, your database support emoji expression, if not supported, how to operate?

15. How do you maintain the data dictionary of the database?

16. Do you have development specifications, if any, how to execute the

17, the table has a large paragraph x (for example: Text type), and the field X will not be updated frequently, to read as the main, please

(1), you choose to split into a sub-table, or continue to put together;

(2), write your reasons for such a choice.

18, MySQL in the InnoDB engine is the row lock by adding on what to complete (or called implementation)? Why is that so?

19. How to recover only one library and one table from a full-database backup generated by mysqldump?

20, a 600 million table A, a 300 million table B, through the outside Tid Association, you how to find the fastest to meet the conditions of the No. 50000 to No. 50200 of the 200 data records.

MySQL dba face question