Sunday, January 8, 2012

Crash table.

I use MySQL for fulltext search.

About 3 days ago I have error in my appengine mapreduce code (library
out of memory limit) and I have very high rate of "REPLACE ..." query
for MyISAM table with fulltext index.

Now I find error in my appengine applicatin:

DatabaseError: 145: Table
'/sfs/gbsupportemails/gbsupport-mysql5-5/data/gb_gbsupport2/email' is
marked as crashed and should be repaired.


I try repair table from command line sql tool.
sql> repair table email;
Missing cached payload in retry response.
sql>
->
-> select count(*) from email;
Instance has too many concurrent requests: 100
sql> select count(*) from email;
Instance has too many concurrent requests: 100
sql> select count(*) from email;
Instance has too many concurrent requests: 100

I can't export sql dump and restart MySQL-instance now

Instance gbsupportemails:gbsupport-mysql5-5.

--
Blog: www.rekby.ru

No comments:

Post a Comment