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.
myqlfragfinder
-
- Long Time Forum Regular
- Posts: 2813
- Joined: Sat Aug 20, 2005 9:30 am
- Location: The Netherlands
Re: myqlfragfinder
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?
By the way, I guess it's not really doing more than mysqlcheck --optimize --auto-repair --all-databases, but with a shorter command?
Lemonbit Internet Dedicated Server Management
- mikeshinn
- Atomicorp Staff - Site Admin
- Posts: 4149
- Joined: Thu Feb 07, 2008 7:49 pm
- Location: Chantilly, VA
Re: myqlfragfinder
Its faster because it finds the fragmented tables, and then fixes them. mysqlcheck will walk all of the tables, which is a lot slower.
Michael Shinn
Atomicorp - Security For Everyone
Atomicorp - Security For Everyone
- mikeshinn
- Atomicorp Staff - Site Admin
- Posts: 4149
- Joined: Thu Feb 07, 2008 7:49 pm
- Location: Chantilly, VA
Re: myqlfragfinder
But basically, it does the same thing. It was requested, so we added it.
Michael Shinn
Atomicorp - Security For Everyone
Atomicorp - Security For Everyone
Re: myqlfragfinder
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.
We have previously installed mysqltuner from the Atomic yum channel.
Lemonbit Internet Dedicated Server Management