Comments on Tuning MySQL Performance with MySQLTuner
Tuning MySQL Performance with MySQLTuner MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers, gives recommendations which variables you should adjust in order to increase performance. That way, you can tune your my.cnf file to tease out the last bit of performance from your MySQL server and make it work more efficiently.
13 Comment(s)
Comments
Thanks for this. This is a really useful tool for helping to optimize MySQL performance.
Understanding the various my.cnf variables and how they affect performance can seem really complicated but this tool takes some of the pain away and makes it easier to understand the effects of each variable.
It is especially useful to be able to see the global memory usage, memory usage per thread and the maximum possible memory usage - that is really valuable information that is otherwise complex to calculate!
HI,
Nice tutorial and good script for tuning mysql performance.
Good work Done.
I updated code like this:
# cd /opt
# wget https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl
# chmod +x mysqltuner.pl
The script developer owns the domain "mysqltuner.pl" and wget assumes http by default so the wget line can be simplified to:
wget mysqltuner.pl
Anyone should be able to remember that.
Thanks for the walkthrough! mysqltuner is really great at giving a quick feedback on configuration issues.
Next, I'd recommend that you check your running server for bad sql. You can use Jet Profiler for MySQL
Hello,
Just a silly question.
I never found the output of mysqltuner very clear.
When it output :
query_cache_limit (> 16M, or use smaller result sets)
query_cache_size (> 128M)
join_buffer_size (> 16.0M, or always use indexes with joins)
table_cache (> 3000)
innodb_buffer_pool_size (>= 13M)
does it mean that query_cache_limit must be set over 16M or does it mean that 16M is to high for query_cache_limit ???
Thank in advance for clarification.
Regards
if u get this error:
./mysqltuner.pl: line 4: syntax error near unexpected token `newline'
./mysqltuner.pl: line 4: `<!DOCTYPE html>'try to download https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl instead.
should work after. hope this helps out.
I built some additions so the script is directly optimizing my servers and restarts them once per x hours. Currently I am using this feature. It went weird. Most providers stopped providing Facebook (closed) Group to Social Rss Feeds so my sites were loaded with many people and even more requests.Started to worry .. MySQL maybe MariaDB. I knew this script and did something extra and now all 64 MySQL servers are running smoothly. No complaints.
I running the MYSQL Tuner, and the recomendation never seem to change.
I updating the MY.CNF and restarting but it display i the recomendation itkeeps comming back telling to turn on SLow Query Logging.
Here is My.CNF file....
[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=1
log-slow-queries=/var/lib/mysql/slow.log
long_query_time=10
query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576
#long_query_time=1
#log-slow-queries=/var/log/mysql/log-slow-queries.log
#log-queries-not-using-indexes
Thanks for this recomendation, Really I need this post. Good job
Perfect sollution