MySQL Forums
Forum List  »  MyISAM

Issue with tables getting crashed
Posted by: Srikanth Ravipati
Date: June 23, 2013 01:28PM

Hi all,

I'm facing issues with some of my tables getting crashed .i could see the following messages frequently in sql log.After this message,entire database becomes unresponsive after some time (including other databases apart from database where this error is happening) .Can you please help me in resolving this issue?

[ERROR] /usr/libexec/mysqld: Incorrect key file for table './ost_helpdesk/ost_session.MYI'; try to repair it.
[ERROR] Got an error from thread_id=252, /builddir/build/BUILD/mysql-5.5.31/storage/myisam/mi_write.c:226

df -h shows following result :

Filesystem Size Used Avail Use% Mounted on
/dev/vzfs 20G 2.5G 18G 13% /
none 256M 4.0K 256M 1% /dev


Os version is Cent OS 6.4 and MySQL version is 5.5.31 ,RAM : 512 MB .Apache as well as PHP was installed in this machine.

Please note that data in these table is very less (in KBs) .

Following is the content of my.cnf file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
default-storage-engine=MyISAM
user=mysql
skip-external-locking
open_files_limit=20000
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#enable query cache
query_cache_size=16M
query_cache_wlock_invalidate=1
#set thread cache size
thread_cache_size=4
#set table_cache
table_cache=128
#set max connections
max_connections=50
key_buffer_size=32M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Thanks ,
Sri.

Options: ReplyQuote


Subject
Views
Written By
Posted
Issue with tables getting crashed
3283
June 23, 2013 01:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.