bhmoura
(usa Fedora)
Enviado em 18/11/2011 - 22:48h
Boa noite, pessoal, quero ver se consegue me ajudar, tenho o mysql innoBD no linux fedora 12, a versão do meu mysql é 5.1.56, esta acontecendo algo no meu banco de dados, de um certo tempo, ele dar uma parada e depois volta automaticamente, estou colocando aqui abaixo o meu log do mysql.log e no momento do erro.
END OF INNODB MONITOR OUTPUT
============================
InnoDB: ###### Diagnostic info printed to the standard error stream
111117 20:00:24 [Note] /usr/libexec/mysqld: Normal shutdown
111117 20:00:24 [Note] Event Scheduler: Purging the queue. 0 events
111117 20:00:26 [Warning] /usr/libexec/mysqld: Forcing close of thread 130257 user: 'system'
111117 20:00:26 [Warning] /usr/libexec/mysqld: Forcing close of thread 130235 user: 'system'
111117 20:00:26 [Warning] /usr/libexec/mysqld: Forcing close of thread 130216 user: 'system'
111117 20:00:26 [Warning] /usr/libexec/mysqld: Forcing close of thread 130215 user: 'system'
111117 20:00:26 [Warning] /usr/libexec/mysqld: Forcing close of thread 130214 user: 'system'
111117 20:00:27 InnoDB: Starting shutdown...
111117 20:00:34 InnoDB: Shutdown completed; log sequence number 0 98346814
111117 20:00:34 [Note] /usr/libexec/mysqld: Shutdown complete
111117 20:00:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
111117 20:00:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111117 20:00:37 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
111117 20:00:37 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
111117 20:00:37 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
111117 20:00:37 InnoDB: Initializing buffer pool, size = 8.0M
111117 20:00:37 InnoDB: Completed initialization of buffer pool
111117 20:00:41 InnoDB: Started; log sequence number 0 98346814
111117 20:00:41 [Warning] 'user' entry 'root@srv.spacetrack.com.br' ignored in --skip-name-resolve mode.
111117 20:00:41 [Warning] 'user' entry '@srv.spacetrack.com.br' ignored in --skip-name-resolve mode.
111117 20:00:41 [Warning] 'user' entry 'root@189-015-92-168.xd-dynamic.ctbcnetsuper.com.br' ignored in --skip-name-resolve mode.
111117 20:00:41 [Note] Event Scheduler: Loaded 0 events
111117 20:00:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.56' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
o meu my.cnf esta assim.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
skip-name-resolve
query_cache_size = 52428800
query_cache_type = 1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
set-variable = max_connections=300
set-variable = max_connect_errors=300
set-variable = wait_timeout=120
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Grato.