Hello to all ,
I am using gateway-1.4.3 tar and sqlbox, and today my
mysql's all table crash and this error message show in mysqld log
file, after that i check and repair the table, but after send the 3
lacs message it was in same condition, and i am again. repaired.
mysqld error log:
111115 14:05:15 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms'
is marked as crashed and should be repaired
111115 14:05:15 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms'
is marked as crashed and should be repaired
111115 14:05:48 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms'
is marked as crashed and should be repaired
111115 14:05:48 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms'
is marked as crashed and should be repaired
111115 14:15:42 [ERROR] /usr/libexec/mysqld: Table
'./sms_dlr/kannel_dlr' is marked as crashed and should be repaired
111115 14:15:42 [ERROR] /usr/libexec/mysqld: Table
'./sms_dlr/kannel_dlr' is marked as crashed and should be repaired
111115 14:52:28 [ERROR] /usr/libexec/mysqld: Incorrect key file for
table './SQLBOX/send_sms.MYI'; try to repair it
111115 14:52:28 [ERROR] /usr/libexec/mysqld: Incorrect key file for
table './SQLBOX/send_sms.MYI'; try to repair it
111115 14:52:28 [ERROR] /usr/libexec/mysqld: Incorrect key file for
table './SQLBOX/send_sms.MYI'; try to repair it
111115 14:52:28 [ERROR] /usr/libexec/mysqld: Incorrect key file for
table './SQLBOX/send_sms.MYI'; try to repair it
111115 15:11:24 mysqld started
111115 15:11:25 InnoDB: Started; log sequence number 0 43655
111115 15:11:25 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306
Source distribution
111115 15:12:13 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms'
is marked as crashed and last (automatic?) repair failed
111115 15:12:13 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms'
is marked as crashed and last (automatic?) repair failed
111115 15:12:23 [Note] Found 845 of 0 rows when repairing './SQLBOX/send_sms'
my mysql version is
[root@localhost sbin]# mysql --version
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using
readline 5.1
so please guide me what i will do for best performance.
--
Thanks & Regards,
-Vijay Kumar Dadhich
Plot No.40 , F.I.E., 1st Floor Patparganj
Industrial Area, Delhi - 110092 ( INDIA)
Cell No.:- 09891993899
