Крашится myisam в Percona

Koc

Новичок
Код:
Killed
130614 12:01:59 mysqld_safe Number of processes running now: 0
130614 12:01:59 mysqld_safe mysqld restarted
130614 12:01:59 [Note] Plugin 'FEDERATED' is disabled.
130614 12:01:59 InnoDB: The InnoDB memory heap is disabled
130614 12:01:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130614 12:01:59 InnoDB: Compressed tables use zlib 1.2.3
130614 12:01:59 InnoDB: Using Linux native AIO
130614 12:01:59 InnoDB: Initializing buffer pool, size = 128.0M
130614 12:01:59 InnoDB: Completed initialization of buffer pool
130614 12:01:59 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!
130614 12:01:59  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...
130614 12:01:59  InnoDB: Waiting for the background threads to start
130614 12:02:00 Percona XtraDB (http://www.percona.com) 5.5.30-rel30.2 started; log sequence number 39519544908
130614 12:02:00 [Note] Event Scheduler: Loaded 0 events
130614 12:02:00 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.30-30.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release 30.2
130614 12:02:34 [ERROR] /usr/sbin/mysqld: Table './satin_main/catalogsearch_fulltext' is marked as crashed and should be repaired
130614 12:02:58 [ERROR] /usr/sbin/mysqld: Table './satin_main/catalogsearch_fulltext' is marked as crashed and should be repaired
130614 12:03:26 [ERROR] /usr/sbin/mysqld: Table './satin_main/catalogsearch_fulltext' is marked as crashed and should be repaired
Killed
130614 12:03:58 mysqld_safe Number of processes running now: 0
130614 12:03:58 mysqld_safe mysqld restarted
130614 12:03:58 [Note] Plugin 'FEDERATED' is disabled.
130614 12:03:58 InnoDB: The InnoDB memory heap is disabled
130614 12:03:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130614 12:03:58 InnoDB: Compressed tables use zlib 1.2.3
130614 12:03:58 InnoDB: Using Linux native AIO
130614 12:03:58 InnoDB: Initializing buffer pool, size = 128.0M
130614 12:03:58 InnoDB: Completed initialization of buffer pool
130614 12:03:58 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!
130614 12:03:58  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...
130614 12:03:58  InnoDB: Waiting for the background threads to start
130614 12:03:59 Percona XtraDB (http://www.percona.com) 5.5.30-rel30.2 started; log sequence number 39519868519
130614 12:03:59 [Note] Event Scheduler: Loaded 0 events
130614 12:03:59 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.30-30.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release 30.2
130614 12:05:35 [ERROR] /usr/sbin/mysqld: Table './satin_main/catalogsearch_fulltext' is marked as crashed and should be repaired
130614 12:06:12 [ERROR] /usr/sbin/mysqld: Table './satin_main/catalogsearch_fulltext' is marked as crashed and should be repaired
130614 12:06:12 [Warning] Checking table:   './satin_main/catalogsearch_fulltext'
при этом
Код:
satin_main.catalogsearch_fulltext	analyze	status	OK
repair table естественно делал, 4 gb свободно, база около 1gb
 

Koc

Новичок
я не убивал мускл. Сервер не ребутился.

Код:
root@satin:/home/satin# uptime
 12:38:17 up 23 days, 13:00,  1 user,  load average: 0.78, 0.64, 0.57
 

Gas

может по одной?
ясно, тогда не знаю, если это тот же сервер, на котором у тебя проблемы с innodb, то может действительно дело в железе/системе, я бы попробовал его сменить на другой.
 
Сверху