MySQL Management: Performance tuning, high availability and monitoring mini-book

MySQL Management: Performance tuning, high availability and monitoring mini-book

mysql5.5.x Main Improvements

1. Use InnoDB storage engine by default
2. Make full use of CPU multi-core processing capability
3, improve the number of brush write dirty pages and merge the number of inserts, improve I/O
4, let Innodb_buffer_pool buffer pool of heat data to survive longer, pollution problems
5, InnoDB Data recovery time accelerated
6. InnoDB supports multiple buffer pool instances simultaneously
7, can turn off the adaptive Hash Index, semaphores signal volume
8, in InnoDB can choose to use the memory allocation program: TCMALLOC Google Development
9. Increase the default InnoDB thread concurrency number
10. Change of pre-reading algorithm
11. Implementing asynchronous I/O on Linux
12. The recovery group commits group commit
13. InnoDB uses multiple rollback segments to improve performance
14, improve the clearance process progress
15. Add delete buffer and clear buffer
16 Control spin lock spin lock polling interval: Dead Loop polling service status
17. Quick Create, delete, change index
18, INNODB support Create compressed data page
19, can dynamically turn off the InnoDB update metadata statistics function: Pollution buffer pool, annlyze table and Show table status will also read the table metadata pollution buffer pool
20. Enhanced copy function
21. Relay Log Self-repair
22, open InnoDB Strict check mode
23, dynamically change the system configuration parameters, new parameters can be changed dynamically is a separate table space, InnoDB lock timeout time
24. Changes in SQL statement wording
25. Stored procedure supports limit variable
26, upgrade from 5.1 to 5.5, method one using Mysql_upgrade upgrade authorization Table upgrade, method two direct installation 5.5 use Import to export data
27, semi-synchronous replication

MySQL Management: Performance tuning, high availability and monitoring mini-book