mysql parando serviço

removido
(usa Nenhuma)

Enviado em 24/09/2013 - 13:48h

Faz 2 dias, meu site abre normalmente porém depois de um certo tempo (Algumas horas) o serviço mysql cai..

segue os logs:

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/modlivehelp_activity' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/modlivehelp_activity'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/modlivehelp_chats' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/modlivehelp_chats'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/modlivehelp_messages' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/modlivehelp_messages'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/modlivehelp_users' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/modlivehelp_users'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/modulos_whmcs' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/modulos_whmcs'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/tblaccounts' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/tblaccounts'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/tblactivitylog' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/tblactivitylog'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/tbladminlog' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/tbladminlog'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/tblclients' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/tblclients'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/tblemails' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/tblemails'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/tblgatewaylog' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/tblgatewaylog'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/tblhosting' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/tblhosting'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/tblinvoiceitems' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/tblinvoiceitems'

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [ERROR] /usr/sbin/mysqld: Table './whmcs/tblinvoices' is marked as crashed and should be repaired

Sep 24 13:41:19 localhost mysqld: 130924 13:41:19 [Warning] Checking table:   './whmcs/tblinvoices'

 

danniel-lara
(usa Fedora)

Enviado em 24/09/2013 - 14:17h

de uma lida
http://gmedeiros.net/site/index.php/tutoriais/95-mysql-checar-e-corrigir-problemas-nas-tabelas.html

quem sabe ajuda

gugusants
(usa CentOS)

Enviado em 02/10/2013 - 00:39h

Os logs em questão são após o serviço parar, visto que informa que as tabelas foram corrompidas. Oriento a verificar o consumo de ram e de load do processamento com o mysql ativo, pois pode ser que o alto consumo esteja matando o serviço.