Wordpress – Mysql Performance tuner, a free Good Optimizer
Even after upgrade of my server to poweredge with quad core and 8GB memory, I did not see any improvement on my blog performance. In my new server, I have also installed a trial oracle applications and noticed a substantial performance in oracle applications response while it was developed over high memory hog java! As an expert in oracle applications and its architecture, it took no minute to understand that I need to look at the performance tuning of my blog on the LAMP components such as mysql, apache and php. I did some Google search and got it tuned Mysql using MySQLTuner, a great free perl script that quickly tells a layman, like me, what to do. To my surprise, I did see an excellent improvement on my blog response time, you too see the difference now!! Great Tool.
MySQLTuner is a high-performance MySQL tuning script written in perl that will provide you with a snapshot of a MySQL server’s health. Based on the statistics gathered, specific recommendations will be provided that will increase a MySQL server’s efficiency and performance. The script gives you automated MySQL tuning that is on the level of what you would receive from a MySQL DBA.
How to get, Install and use it? Just follow the steps:
# chmod +x mysqltuner.pl
# ./mysqltuner.pl
| MYSQL Tuner Results |
|---|
|
>> MySQLTuner 1.0.0 – Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with ‘–help’ for additional options and output filtering Please enter your MySQL administrative login: secret Please enter your MySQL administrative password: more secret ——– General Statistics ————————————————– [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.0.45 [OK] Operating on 64-bit architecture ——– Storage Engine Statistics ——————————————- ——– Performance Metrics ————————————————- ——– Recommendations —————————————————– |
Following Google Searches Lead To This Post:
mysql response time 1000 visitors
wordpress slow performance
Comments
No comments yet.