FW: something wrong with the marketing intel DB server

From: Dylan Douglas <dylan_at_mediadefender.com>
Date: Mon, 23 Apr 2007 10:08:26 -0700

 

________________________________

From: Nainesh Solanki
Sent: Monday, April 23, 2007 10:03 AM
To: Dylan Douglas
Subject: something wrong with the marketing intel DB server

Hi every1,
I am getting this error message when i am trying to access my tables on
the marketing intell db server.
 
Can't find file: 'c' (errno: 2)
 
Its giving me error when I try to access any table under the
'ares_data_analysis' schema. All other schema's seem to be ok. Wondering
if anyone has seen something like this before.
 
Nainesh.

________________________________

From: Dylan Douglas
Sent: Sunday, April 22, 2007 2:22 PM
To: Ty Heath; Ivan Kwok; Danny Song; Jay Mairs; Nainesh Solanki; Stefan
Kaczmarek
Subject: ares searcher dead

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

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