myqlfragfinder

Atomic repository announcements, new release notifications and other news regarding the atomic yum repository.
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

myqlfragfinder

Unread post 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.
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

Re: myqlfragfinder

Unread post 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? :)
Lemonbit Internet Dedicated Server Management
User avatar
mikeshinn
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 4149
Joined: Thu Feb 07, 2008 7:49 pm
Location: Chantilly, VA

Re: myqlfragfinder

Unread post 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.
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

Re: myqlfragfinder

Unread post by breun »

Ah ok, cool.
Lemonbit Internet Dedicated Server Management
User avatar
mikeshinn
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 4149
Joined: Thu Feb 07, 2008 7:49 pm
Location: Chantilly, VA

Re: myqlfragfinder

Unread post by mikeshinn »

But basically, it does the same thing. It was requested, so we added it.
prupert
Forum Regular
Forum Regular
Posts: 573
Joined: Tue Aug 01, 2006 2:45 pm
Location: Netherlands

Re: myqlfragfinder

Unread post 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.
Lemonbit Internet Dedicated Server Management
Post Reply