Saturday, January 1, 2011

myisam_sort_buffer_size

Database error: Invalid SQL: select * from members where email='
ajeeshbkannan@gmail.com' and password='ajeeshbkanan'
*MySQL Error*:144 Table './table name' is marked as crashed
and last (automatic?) repair failed

This is may due to myisam_sort_buffer_size is too small. I have increased mysql buffer size from 64Mb to 256Mb, and fixed my issue.

You can verify table by using the command,
mysql> check table tablename;

All your comments are welcomed ...

No comments:

Post a Comment