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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.