第33章　硬件和系统调优 - xiaoboluo768/qianjinliangfang GitHub Wiki

33.1.1　I/O：MySQL 80%的性能瓶颈所在

• 2．内存

[root@localhost~]# cat /etc/grub.conf
……
kernel /vmlinuz-2.6.32-220.el6.x86_64 ro root=/dev/mapper/VolGroup-root rd_NO_LUKS LANG=en_US.UTF-8 rd_LVM_LV=VolGroup/root rd_NO_MD quiet SYSFONT=latarcyrheb-sun16 rhgb crashkernel=auto rd_LVM_LV=VolGroup/ swap  rhgb crashkernel=auto quiet  KEYBOARDTYPE=pc KEYTABLE=us rd_NO_DM numa=off

[root@localhost~]# numactl --interleave=all mysqld &

[root@localhost~]# vmstat -an 1
......

[root@localhost~]# cat /proc/meminfo  | grep -i inact
Inactive:        326972 kB
Inactive(anon):      248 kB
Inactive(file):  326724 kB

[root@localhost~]# echo "vm.swappiness = 10" >>/etc/sysctl.conf

• 3．文件系统

[root@localhost~]# stat libnids-1.16.tar.gz
 ......

[root@localhost~]# echo deadline >/sys/block/sda/queue/scheduler

---

上一篇：第32章　MySQL挂起诊断思路 | 下一篇：第34章 并发删除数据造成死锁