Page 1 of 1

Постоянно падает mysql

Posted: Tue Feb 23, 2016 5:54 pm
by karlson1980
День добрый!


Постоянно падает база и уходит в глухой даун. Помогает только переустановка всего)
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

Re: Постоянно падает mysql

Posted: Thu Apr 14, 2016 12:00 pm
by skurudo
http://dev.mysql.com/doc/refman/5.6/en/ ... pying.html

If you don't have 5.6.6 or later, then consider these
* ALTER TABLE
* RENAME TABLE
* dump and reload a table.