As you could imagine, this is a pretty difficult post to write. I’m a big fan of MySQL and I’ve really enjoying working on the MySQLTuner script. While it’s nowhere near perfect, it has helped quite a few people increase their database performance and avoid downtime in their applications. The emails have rolled in from people around the world and I’m grateful for each one I’ve received (even the negative ones!).
However, my current role at Rackspace occupies much of my time. Since January 2008, I’ve worked with the Slicehost operations team as a Linux Engineer, and we’re constantly riding the latest wave of virtualization technology. It probably goes without saying, but staying on the forefront of the industry takes a lot of effort!
With a heavy heart, I’m announcing a search for a new maintainer for MySQLTuner. It’s written in Perl, but it’s fairly basic. I’d prefer to hand it off to a Certified MySQL DBA, but anyone who enjoys working with MySQL would be a good maintainer.
It’s also important to note that Sheeri Cabral from Pythian has forked MySQLTuner to include some changes that she finds relevant, and that project is taking off on Launchpad.
If you’re interested in taking over, feel free to comment on this post or communicate via the Google Group. Thanks again for your continued support and interest.
Wish you the best, have found mytuner to be very very useful.
J
Jeremy – Thanks. I’m glad the script has helped you.
Why is Sheeri Cabral doing a fork? Maybe Sheeri can take over as maintainer and add the changes to the main trunk.
Adam – I’d certainly be open to that.
I would be happy to take over as maintainer as well. I could then make sure the information reported by both mysqltuner.pl and tuning-primer.sh is consistent between both.
A bit offtopic but how i can fix this?
[!!] Joins performed without indexes: 31
I was add join_buffer_size = 8 but i am still getting this …
Thank you
Dimitris –
Ensure that the columns that you are using to join tables together are properly indexed. For example, if you’re joining columnA from one table with columnB from another table like this:
LEFT JOIN tableA ON tableA.columnA = tableB.columnB
You need to make sure both of those referenced columns are indexed. Also, make sure they’re the same type – don’t try to join a VARCHAR up with an INT.
Has this been taken over yet? Still looking for a new maintainer? I’ll toss my name in the hat. As someone who’s benefitted from this script, I’ll definitely be willing to “pay it forward”.
Sorry to see you have to put this up for adoption, Major. Good to see that there’s no shortage of candidates to maintain this script, it is loved.
I’ve been working on a GPL’d automated MySQL tuner / DBA replacement tool that uses mysqltuner, log parsing, etc and could definitely maintain and improve mysqltuner as well.
I’ve noted that printenv isn’t available everywhere, and think changing line 299 in the github version from:
my $userpath = `printenv HOME`
to
my $userpath = $ENV{HOME}
or
my $userpath = `echo ~`
are good, or at least functional, fixes.
Using the File::HomeDir module works as well, but that module isn’t installed everywhere so I consider it to be a lower quality fix. I see the forked Pythian version has addressed this with:
my $userpath = `ls -d ~ 2>/dev/null`
I’m not a Pythian fan (but have nothing at all against Sheeri, I think Sheeri does good work for the community) and don’t want to contribute to the forked version for fear of having GPL’d work included by Pythian in a proprietary product or expensive service, or see a crippled but free ‘community’ version of mysqltuner coexist with a full featured but expensive ‘enterprise’ version. mysqltuner should always be 100% free, never crippled.
I’ve had enough interaction with Pythian at my present position to fuel my fears. Trying to download software from their site drives home the fact that they are for-profit and looking for revenue in all they do (not Sheeri but the business people at Pythian).
Anyway, have a good one & keep doing the needful. Give me a shout if you head up to ATX and want to chillax or whatever.
Hi
I was searching the web for tools related to MySQL performance tuning and just stumbled upon your article.
I’m fairly new to the MySQL tuning business (I have less than 5 years of experience), but I’m a seasoned Perl developer with some contributions to CPAN.
I would like to join the take-over effort for this script.
Please let me know the current situation and where / how can I have access to the script.
Good luck with your new career. :)
Cheers
–
LMC