One of MySQL optimizations: server hardware and operating system

1 Server hardware optimization

When selecting a database server, you can consider the following aspects:

1) CPU: Recommended for high-performance servers such as Dell R7, R8, or R9 series servers.

2) Disk: The biggest constraint on the database server is disk I/O, if the condition can be used SSD, if the cost is limited can use the SAS hard disk, in terms of performance ssd>sas>sata. As for raid, you can use raid1+0, or RAID5 (consider the cost).

3) Memory: Dedicated database server memory recommended above 32G.

2 Operating system optimization

1) Install the system with minimal or basic installation, install only MySQL-related applications and minimize the consumption of system resources.

2) The database server is usually placed in the intranet, so you can turn off the firewall (iptables) and SELinux

3) Optimization of system kernel parameters, modification of/etc/sysctl.conf configuration file, no increase:

Net.ipv4.tcp_tw_reuse = 1

Net.ipv4.tcp_tw_recycle=1

net.ipv4.tcp_fin_timeout=10

net.ipv4.tcp_max_syn_backlog=8192

This article from "10,000 years too long, seize" blog, please be sure to keep this source http://zengwj1949.blog.51cto.com/10747365/1920743

One of MySQL optimizations: server hardware and operating system