Hi,
I have a very strange problem whereby one particular table in our
database is repeatedly (on average, every couple of days) generating
errors stating that the table is crashed and needs to be repaired.
Running a repair fixes it.
What makes it strange (and something that I've never
No idea on the cause, but sitting with the exact same issue on 1 specific
MyISAM table on mysql-5.1.50
Since the table was created it never had any change in data structure, the
table is almost exclusively INSERTs and it is quite big in my instance
however. Table crashes on average every 2 to 3
Tables frequently crashing on my site. Here is the message I'm seeing
*
Warning*: Table './mydb/sessions' is marked as crashed and should be
repaired query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid=
s.uid WHERE s.sid = '854c6474111de174abbddf77f74b9d99' in *
Tables frequently crashing on my site. Here is the message I'm seeing
*
Warning*: Table './mydb/sessions' is marked as crashed and should be
repaired query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid=
s.uid WHERE s.sid = '854c6474111de174abbddf77f74b9d99' in *
Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem. I
will post the structure of the table here, as well as the
3:35 AM
Subject: Request for help - Table Crashing
Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem.
I
Hi,
I've got a table with a 5 milion records and with 10 records adding
every day.
My problem is that when I try to delete old records from this tables at
some point I receive the following error
ERROR 1034: Incorrect key file for table: 'logs'. Try to repair it.
and the query execution