Optimize your MySQL database
Lots of people have MySQL databases running. But far fewer is the people who have their database running well and fully optimized. It's no wonder since database optimization is something of a black art.
MySQLTuner brings the black art of optimizing MySQL databases into the light. It's a perl script you run on your server and it performs a bunch of checks. When it's all said and done, it gives you specific actions to take to get better performance from your database.
All of the instructions are available from their Wiki (link below). But here's how simple it is, just run these commands from your server:
That's all it takes to find out what you need to do to get your database running better.
MySQLTuner brings the black art of optimizing MySQL databases into the light. It's a perl script you run on your server and it performs a bunch of checks. When it's all said and done, it gives you specific actions to take to get better performance from your database.
All of the instructions are available from their Wiki (link below). But here's how simple it is, just run these commands from your server:
wget mysqltuner.pl chmod 0700 mysqltuner.pl ./mysqltuner.pl
That's all it takes to find out what you need to do to get your database running better.
| Link: | wiki.mysqltuner.com...Search for more tips related to this link |
| Rating: | 100% positive, 1 Vote |
| Categories: | MySQL databases optimization performance |
| Added: | on Dec 07, 2008 at 5:04 pm |
| Added By: | an anonymous user |
| Searches: | database mysql performance optimization running |
