111 reputation
3
bio website
location
age
visits member for 2 years, 4 months
seen Apr 4 at 2:26

Jan
13
awarded  Popular Question
Mar
21
comment Very small MySQL table keeps crashing
I'm using CentOS 5 and MySQL 5.0.22. Probably should upgrade MySQL, huh! I am the only one who accesses the server, so no one else is moving files around. There is nothing related to mysql in /var/log/messages. Workarounds would be cool if the table data was under my command, but it's a client's table, so I don't know when they'll be updating it in order to compress it. I need to use MyISAM so I can use a fulltext index.
Mar
20
comment Very small MySQL table keeps crashing
Thanks for the advice, but the MySQL server is rarely restarted, so I know that crashes are not happening from restarts. I've also had no trouble just doing the REPAIR TABLE manually when I discover it's crashed. Repairing on restart doesn't really help solve my problem as it's not preventing the table from crashing.
Mar
20
comment Very small MySQL table keeps crashing
Thanks, I am good on backups, and I'm not having any trouble repairing the table, I just want it to stop crashing. :)
Mar
19
awarded  Editor
Mar
19
comment Very small MySQL table keeps crashing
I've updated my question
Mar
19
revised Very small MySQL table keeps crashing
Added some lines from the error log
Mar
18
awarded  Student
Mar
18
asked Very small MySQL table keeps crashing