Hi all, I need someone can help me optimize mySQL. My site use Datalife Engine CMS. And database now only 430 Mb. My site only have 15k visitor/day and 65k pageview/day My server I am using: Intel Xeon L5630 (4-Core HT) RAM: 16Gb I think this is a strong server for my site. This is screenshot capture from ssh top: Please pm me, I need your review or something can prove optimize it Thanks so much!!! Or you can send me though email: willsonjacky25@gmail.com
Have you tried optimizing your tables from within phpMyAdmin? You can do this by logging in to your phpMyAdmin and selecting the database with tables you wish to optimize. A list with all the database's tables will appear. Tick the tables you wish to optimize, or simply click [Check All] at the bottom to select all tables. From the [With selected:] drop-down menu choose Optimize table. This will then execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized. You can also set up a Crontab/Cron to do this for you aswell. Mine is set to run a 1am every morning on all databases using the root user account. The syntax I use is: 0 1 * * * mysqlcheck -Aao –auto-repair -u root -p[password] > /dev/null Code (markup):