After some frustrating renewal issues with the registrar of mysqltuner.pl, it’s now back under my control and valid for another year. I’ll be looking to move it to another registrar within the next year so these issues won’t crop up again.
Also, I still get e-mails from users who are concerned about the security of their system when they see the instructions on downloading the script:
wget mysqltuner.pl
The script makes no adjustments to your system whatsoever. The mysqltuner.pl domain is a Polish domain name with the .pl tld. When you query mysqltuner.pl in a browser, you’re automatically redirected to the script using a simple mod_rewrite rule in apache.
I just downloaded it on my Debian Lenny slice. :D This is my first time to use the mysqltuner. It seems to be a really nice tool. It has a lot of positive reviews from the internet so, why not give it a try? :D
Jesse –
Glad to see you’re getting some use out of it. I hope to get back into development with it soon, so please let me know if you have any suggestions for improvements!
[!!] Key buffer hit rate: 50.0%
[!!] Query cache efficiency: 0.0%
See, I’m a unix admin and a programmer, not a DBA… this doesn’t tell me much… Maybe with the messages, a brief explanation, maybe a pointer to the right place in the documentation and hints about how to resolve it may be a good idea?
Have a nice day and thank you for this excellent tool.
Pierre,
I’ve kept the output intentionally brief so that the output can be quickly scanned for important details. I’m interested in doing the legwork of calculating the efficiency of MySQL servers, but I leave the bulk of the real thought to the users of my script.
You may want to review this section of the MySQL documentation for further details:
http://dev.mysql.com/doc/administrator/en/mysql-administrator-health-memory-health.html
Thank you,
I agree with your idea of keeping the stdout clean.
What about like rkhunter of having a more detailed output in a log file?
Thanks for the link
Same as Jesse. I just downloaded this script and running it on our Solaris server. It really helps.
One thing I notice is that function get_replication_status in version 1.1.1 is not enabled, I added function call , but it didn’t work until I added chop to make $io_running and $sql_running equal to ‘Yes’:
my $io_running = `mysql -Bse “show slave status\\G”|grep -i slave_io_running|awk ‘{ print \$2}’`;
my $sql_running =`mysql -Bse “show slave status\\G”|grep -i slave_sql_running|awk ‘{ print \$2}’`;
chop($io_running);
chop($sql_running);
Not sure if it is OS related or not.
Thank You
Welcome back !
Hello Major,
Can you please update http://mysqltuner.pl/mysqltuner.pl to ver. 1.1.1 or/and upload tarball to the github downloads area (because autogenerated archive names are not usable f.e. for freebsd ports system)?
Thanks!