ares searcher dead

From: Dylan Douglas <dylan_at_mediadefender.com>
Date: Sun, 22 Apr 2007 14:22:06 -0700
repairing tables on 129.47.9.130 (marketing intel)
Ty-
 
Think your Ares searcher has died.  Please check.
 
-D
 
----------
Dylan Douglas
MediaDefender


From: Ty Heath
Sent: Sun 4/22/2007 11:48 AM
To: Dylan Douglas; Ivan Kwok; Danny Song; Jay Mairs; Nainesh Solanki; Stefan Kaczmarek
Subject: repairing tables on 129.47.9.130 (marketing intel)

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:56 BST

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