HostOnNet Blog

Basic MySql Optimization

Looking for Linux Server Admin or WordPress Expert? We can help.


MySQL Server can be optimized at a basic level, using the MySQL tuner script.

Download the script using the command:


Now, run the commands:

unzip master

cd major-MySQLTuner*

chmod +x


The script will check the status of MySQL and update you with the variables that you need to tweak to optimize MySQL.

Variables to adjust:
query_cache_size (> 64M)
join_buffer_size (> 2.0M, or always use indexes with joins)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
table_open_cache (> 8192)
innodb_buffer_pool_size (>= 520M)

These you can change by editing /etc/my.cnf file, that make mysql perform better.

About Annie

I've been working in Technical Section for over 10 years in a wide range of tech jobs from Tech Support to Software Testing. I started writing blog for my future reference and useful for all.
Posted in MySQL

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.