Small ant learns MySQL performance optimization (end)-Hardware optimization--cpu and disk optimization

Optimization of database hardware

How do I select a CPU?

Would you prefer a faster single-core CPU or a higher number of cores?

1. MySQL has some work that only uses single-core CPUs

2. MySQL does not support CPU cores more and more faster

Recommendation: mysql5.5 Use a server that does not exceed 32 cores. It is also recommended that the single core frequency be faster CPU.

Disk IO optimization

Introduction to Common RAID levels

RAID0: Also become a stripe, that is, to link multiple disks into a hard disk use, this level of IO is the best.

RAID1: Also becomes mirrored, requiring at least two disks, each set of disks to store the same data.

Raid0+1: It is the combination of RAID1 and RAID0. With two levels of pros and cons. It is generally recommended that the database use this level.

Chabudu spent 10 days, finally the performance optimization of MySQL finished learning, feeling still benefited. Recently saw a MySQL development skills to explain, the strike, the MySQL knowledge to learn more learning, refueling.

Small ant learns MySQL performance optimization (end)-Hardware optimization--cpu and disk optimization