Hi All
I keep getting a problem with our MySQL database, I know what error 127 is
('Record-file is crashed / Network is down'), it keeps occuring on several
tables that are frequently accessed by our website.
I can fix the problem by running OPTIMIZE TABLE on the offending tables but
it seems to be becoming a regular occurence (every 48 hours or so). We
recently lost a load of data because many tables were down, and when these
one of the tables (the session ID table) crashes, our whole site can't be
accessed.
Nothing in the logs about it, disk space is OK and the disk passed a fsck
test ok. Only clue is from the output of isamchk:
---
Checking ISAM file: Failed.ISM
Data records: 3089 Deleted blocks: 0
- check file-size
- check delete-chain
- check index reference
- check record links
isamchk: error: Wrong bytesec: 0-0-0 at linkstart: 399911
---
What can I do to stop this happening?
It is MySQL 3.22.32 running on Solaris. I plan on upgrading this soon but
want to get to the bottom of this problem first..
Thanks for any pointers,
Regards
John
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
