I wrote a BASH script that will run “optimize table” on any table fragmented. it’s pretty tidy, and you can supply usernames and passwords, and even run it against remote MySQL databases.
Here’s an example of it’s output:
root@lit [~]# mysqlFragFinder
MySQL fragmentation finder (and fixer) v0.7.2, written by Phil Dufault ( http://www.dufault.info/ )
Found 59 databases
Checking someforum_forum … [...]
Posted on August 7th, 2008 by Phil Dufault
Filed under: Linux, MySQL | 1 Comment »
I’ve been using this for the past two weeks:
MySQL Tuner
I’ve used on servers running on MySQL 4.0, or 5.1 lately to tweak their preformances. Itt’s an awesome script, and I recommend using it on any MySQL server you can find.
Posted on August 7th, 2008 by Phil Dufault
Filed under: Linux | No Comments »
This post is probably only helpful to a system administrator of large shared servers that happen to have a lot of MySQL databases.
These scripts are meant to administrate all of the databases and tables on a single server currently, I might refine them to also work only database or table name’s supplied.
One of the scripts, [...]
Posted on July 17th, 2008 by Phil Dufault
Filed under: MySQL | No Comments »