Page 1 of 1

myqlfragfinder

Posted: Wed Nov 14, 2012 7:35 pm
by scott
By popular demand, this has been added to the repo. Rather than stick this in its own package it was merged with mysqltuner (if you dont use it, start!). This was another great user-submitted find, so if you run across other great tools like this, let us know here or email support.

Oh and if you're not familiar with the tool, it defrags & repairs mysiam and innodb databases.

Re: myqlfragfinder

Posted: Mon Nov 19, 2012 4:51 am
by breun
The update seems to have landed in the ASL repository, but not in Atomic yet.

By the way, I guess it's not really doing more than mysqlcheck --optimize --auto-repair --all-databases, but with a shorter command? :)

Re: myqlfragfinder

Posted: Mon Nov 19, 2012 11:16 am
by mikeshinn
Its faster because it finds the fragmented tables, and then fixes them. mysqlcheck will walk all of the tables, which is a lot slower.

Re: myqlfragfinder

Posted: Mon Nov 19, 2012 11:18 am
by breun
Ah ok, cool.

Re: myqlfragfinder

Posted: Mon Nov 19, 2012 11:35 am
by mikeshinn
But basically, it does the same thing. It was requested, so we added it.

Re: myqlfragfinder

Posted: Wed Dec 05, 2012 7:25 am
by prupert
I found out that the mysqltuner package was not available in the Atomic yum channel. Am I missing something? I can't find it on http://www7.atomicorp.com/channels/atom ... 6_64/RPMS/ as well.

We have previously installed mysqltuner from the Atomic yum channel.