@karlson1980
Lamer

Постоянно падает mysql Centos 6.7, куда копать?

День добрый!

Постоянно падает база и уходит в глухой даун. Помогает только переустановка всего)
Centos 6.7

[root@ns398679 ~]# rpm -qa | grep mysql
mysql-5.5.48-1.el6.remi.x86_64
compat-mysql51-5.1.54-1.el6.remi.x86_64
mysql-libs-5.5.48-1.el6.remi.x86_64
php-mysql-5.4.45-4.el6.remi.x86_64
mysql-server-5.5.48-1.el6.remi.x86_64

14:58:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:04:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:04:20 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:04:20 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 14267 ...
160223 15:04:20 [Note] Plugin 'FEDERATED' is disabled.
160223 15:04:20 InnoDB: The InnoDB memory heap is disabled
160223 15:04:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:04:20 InnoDB: Compressed tables use zlib 1.2.3
160223 15:04:20 InnoDB: Using Linux native AIO
160223 15:04:20 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:04:20 InnoDB: Completed initialization of buffer pool
160223 15:04:20 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:04:20 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:04:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:04:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:04:26 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:04:26 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 14964 ...
160223 15:04:26 [Note] Plugin 'FEDERATED' is disabled.
160223 15:04:26 InnoDB: The InnoDB memory heap is disabled
160223 15:04:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:04:26 InnoDB: Compressed tables use zlib 1.2.3
160223 15:04:26 InnoDB: Using Linux native AIO
160223 15:04:26 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:04:26 InnoDB: Completed initialization of buffer pool
160223 15:04:26 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:04:26 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
noDB: memory cache!
160223 15:04:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:05:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:05:52 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:05:52 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 1684 ...
160223 15:05:52 [Note] Plugin 'FEDERATED' is disabled.
160223 15:05:52 InnoDB: The InnoDB memory heap is disabled
160223 15:05:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:05:52 InnoDB: Compressed tables use zlib 1.2.3
160223 15:05:52 InnoDB: Using Linux native AIO
160223 15:05:52 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:05:52 InnoDB: Completed initialization of buffer pool
160223 15:05:52 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:05:52 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:05:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:14:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:14:31 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:14:31 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 1683 ...
160223 15:14:31 [Note] Plugin 'FEDERATED' is disabled.
160223 15:14:31 InnoDB: The InnoDB memory heap is disabled
160223 15:14:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:14:31 InnoDB: Compressed tables use zlib 1.2.3
160223 15:14:31 InnoDB: Using Linux native AIO
160223 15:4:31 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:14:31 InnoDB: Completed initialization of buffer pool
160223 15:14:31 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:14:31 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:14:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160223 15:25:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 15:25:26 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
160223 15:25:26 [Note] /usr/libexec/mysqld (mysqld 5.5.48) starting as process 1683 ...
160223 15:25:26 [Note] Plugin 'FEDERATED' is disabled.
160223 15:25:26 InnoDB: The InnoDB memory heap is disabled
160223 15:25:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160223 15:25:26 InnoDB: Compressed tables use zlib 1.2.3
160223 15:25:26 InnoDB: Using Linux native AIO
160223 15:25:26 InnoDB: Initializing buffer pool, size = 128.0M
160223 15:25:26 InnoDB: Completed initialization of buffer pool
160223 15:25:26 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 19182772868
160223 15:25:26 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 1325 of name './admin_immigrat/wp_termmeta.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 1325 of name './immigration/wp_termmeta.ibd' already exists in the tablespace
InnoDB: memory cache!
160223 15:25:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  • Вопрос задан
  • 1205 просмотров
Пригласить эксперта
Ответы на вопрос 4
unitby
@unitby
Места ему везде хватает?
Оперативной памяти на всякие буферы?
юзается ли swap?
Ответ написан
CityCat4
@CityCat4
Если я чешу в затылке - не беда!
/etc/mysql.cnf (или какой там у Вас конфиг) покажите, если он есть
Ответ написан
Посмотрите, например, не увеличился ли ibdata file до максимальных значений.
Ответ написан
@karlson1980 Автор вопроса
Lamer
641de9aae20542f99fd519c9c5b2b66b.jpg

вот какая то хрень появляется и как Вы говорили Дмитрий файл увеличивается как то уж быстро - и все error
Ответ написан
Ваш ответ на вопрос

Войдите, чтобы написать ответ

Войти через центр авторизации
Похожие вопросы