Issue with tables getting crashed
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.
Subject
Views
Written By
Posted
Issue with tables getting crashed
3296
June 23, 2013 01:28PM
1700
June 23, 2013 09:50PM
1598
June 24, 2013 07:38PM
1647
June 24, 2013 07:51PM
1635
June 25, 2013 09:37AM
1612
June 25, 2013 09:58PM
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.