MySql:优化工具

脚本优化tuning-primer.sh

#cd /etc/   (my.conf所在目录)

#wget http://www.day32.com/MySQL/tuning-primer.sh

#chmod +x tuning-primer.sh

#./tuning-primer.sh

 

运行报错

which: no bc in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)

 Error: Command line calculator 'bc' not found!

#yum install bc

 

优化工具Mysqltuner

安装：#yum install -y mysqltuner

运行：#mysqltuner