Erro no servidor My SQL (InnoDB)

[Joel Suke]

Galera, sou novo aqui no fórum. Seguinte, tenho um site www.azilator.com.br (Wordpress).  Antes estava hospedado no HostGator e agora resolvi hospedá-lo no Digital Ocean com a seguinte configuração: 1GB RAM, 1 Core, 30GB  HD, 2TB Transferência. E nele instalei o Ubuntu 12.04.3 x64, migrei o site inteiro tranquilo.

Aparentemente está tudo normal, sendo que várias vezes o servidor de banco de dados acaba caindo e eu sempre tenho que ir no Putty e startar o servidor MySql novamente. Um amigo meu fez o Swap, mas ainda continua caindo o servidor de banco de dados de vez em quando. Por favor me ajudem, vou postar o LOG do MySql da última vez que o server caiu.

Código Selecionar Expandir


root@azilator:/var/log/mysql# cat error.log
140224  6:36:22 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140224  6:36:22 [Note] Plugin 'FEDERATED' is disabled.
140224  6:36:22 InnoDB: The InnoDB memory heap is disabled
140224  6:36:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140224  6:36:22 InnoDB: Compressed tables use zlib 1.2.3.4
140224  6:36:22 InnoDB: Initializing buffer pool, size = 128.0M
140224  6:36:22 InnoDB: Completed initialization of buffer pool
140224  6:36:22 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140224  6:36:22  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140224  6:36:22  InnoDB: Waiting for the background threads to start
140224  6:36:23 InnoDB: 5.5.35 started; log sequence number 13655380
140224  6:36:23 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
140224  6:36:23 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
140224  6:36:23 [Note] Server socket created on IP: '127.0.0.1'.
140224  6:36:23 [Note] Event Scheduler: Loaded 0 events
140224  6:36:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.35-0ubuntu0.12.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
140224  6:36:24 [ERROR] /usr/sbin/mysqld: Table './joelsuke_dbazilator/wp_commentmeta' is marked as crashed and should be repaired
140224  6:36:24 [Warning] Checking table:   './joelsuke_dbazilator/wp_commentmeta'
140224  6:36:24 [ERROR] /usr/sbin/mysqld: Table './joelsuke_dbazilator/wp_comments' is marked as crashed and should be repaired
140224  6:36:24 [Warning] Checking table:   './joelsuke_dbazilator/wp_comments'
140224  6:36:24 [ERROR] /usr/sbin/mysqld: Table './joelsuke_dbazilator/wp_options' is marked as crashed and should be repaired
140224  6:36:24 [Warning] Checking table:   './joelsuke_dbazilator/wp_options'
140224  6:36:24 [ERROR] /usr/sbin/mysqld: Table './joelsuke_dbazilator/wp_podpress_statcounts' is marked as crashed and should be repaired
140224  6:36:24 [Warning] Checking table:   './joelsuke_dbazilator/wp_podpress_statcounts'
140224  6:36:24 [ERROR] /usr/sbin/mysqld: Table './joelsuke_dbazilator/wp_postmeta' is marked as crashed and should be repaired
140224  6:36:24 [Warning] Checking table:   './joelsuke_dbazilator/wp_postmeta'
140224  6:36:24 [ERROR] /usr/sbin/mysqld: Table './joelsuke_dbazilator/wp_posts' is marked as crashed and should be repaired
140224  6:36:24 [Warning] Checking table:   './joelsuke_dbazilator/wp_posts'
140224  6:36:24 [ERROR] /usr/sbin/mysqld: Table './joelsuke_dbazilator/wp_usermeta' is marked as crashed and should be repaired
140224  6:36:24 [Warning] Checking table:   './joelsuke_dbazilator/wp_usermeta'
140224  6:36:24 [ERROR] /usr/sbin/mysqld: Table './zpanel_core/x_bandwidth' is marked as crashed and should be repaired
140224  6:36:24 [Warning] Checking table:   './zpanel_core/x_bandwidth'
140224  6:36:24 [ERROR] /usr/sbin/mysqld: Table './zpanel_core/x_mysql_databases' is marked as crashed and should be repaired
140224  6:36:24 [Warning] Checking table:   './zpanel_core/x_mysql_databases'
root@azilator:/var/log/mysql#


[Rockwave]

Dá uma olhada aqui: http://wiki.locaweb.com.br/pt-br/MySQL:_Principais_mensagens_de_erro,_suas_causas_e_como_resolver
http://dev.mysql.com/doc/refman/5.1/en/myisam-repair.html

Não se esqueça de manter uma rotina de backups.

[zekkerj]

como está o teu consumo de memória?

[Joel Suke]

Tá assim:

Código Selecionar Expandir


System information as of Mon Feb 24 14:08:46 EST 2014

System load:  0.01               Processes:           94
Usage of /:   40.6% of 29.40GB   Users logged in:     0
Memory usage: 69%                IP address for eth0: 107.170.7.235
Swap usage:   7%

Graph this data and manage this system at:
https://landscape.canonical.com/

7 packages can be updated.
7 updates are security updates.

Last login: Mon Feb 24 07:32:49 2014 from 177.19.90.175
joel@azilator:~$ free -m
             total       used       free     shared    buffers     cached
Mem:           994        881        113          0          8        182
-/+ buffers/cache:        691        303
Swap:         2047        145       1902