repairing tables on 129.47.9.130 (marketing intel)

From: Ty Heath <ty.heath_at_gmail.com>
Date: Sun, 22 Apr 2007 11:48:59 -0700

Okay, repairing large tables crashes mysql for whatever reason. It
uses too much ram and dies. So they have to be repaired externally.
I have created a script on that server for this purpose that uses
myisamchk. To use it just execute something like:

repairdb /var/lib/mysql/ares_supply/ares_dht_audio_meta_data

You would change the database and table name as appropriate, this
will keep the server from crashing and a nasty circular pattern of 1
repair causing other tables to need repair.

This will spawn a seperate process independent of the mysql server
process and allows us to pass options to limit memory usage etc.

Ty
Received on Fri Sep 14 2007 - 10:55:59 BST

This archive was generated by hypermail 2.2.0 : Sun Sep 16 2007 - 22:19:47 BST