To fine tuning mysql server, run Mysql tuning primer script on server.
But I got error which said bc is not found. So just enter following yum install bc to install it.
[root@vps test]# ./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! [root@vps test]# yum install bc