|
mariadb странное поведение
|
|||
---|---|---|---|
#18+
MySQL Version 10.1.45-MariaDB x86_64 база стартует, перегружается но периодически в логах вижу такое автор 2020-06-04 4:05:08 139680611518720 [Note] InnoDB: 128 rollback segment(s) are active. 2020-06-04 4:05:08 139680611518720 [Note] InnoDB: Waiting for purge to start 2020-06-04 4:05:08 139680611518720 [Note] InnoDB: Percona XtraDB ( http://www.percona.com) 5.6.47-87.0 started; log sequence number 21868136140 2020-06-04 4:05:08 139672709728000 [Note] InnoDB: Dumping buffer pool(s) not yet started 2020-06-04 4:05:08 139680611518720 [Note] Plugin 'FEEDBACK' is disabled. 2020-06-04 4:05:08 139680611518720 [Note] Recovering after a crash using tc.log 2020-06-04 4:05:08 139680611518720 [Note] Starting crash recovery... 2020-06-04 4:05:08 139680611518720 [Note] Crash recovery finished. 2020-06-04 4:10:52 139680049784576 [ERROR] mysqld: Table './root_cwp/user' is marked as crashed and should be repaired 2020-06-04 4:10:52 139680049784576 [Warning] Checking table: './root_cwp/user' 2020-06-04 4:16:33 139677790361344 [Note] /usr/sbin/mysqld: Normal shutdown 2020-06-04 5:49:19 139704695858944 [ERROR] mysqld: Table './mlb12_parel/ps_oav_order_ip_log' is marked as crashed and should be repaired 2020-06-04 5:49:19 139704695858944 [Warning] Checking table: './mlb12_parel/ps_oav_order_ip_log' 2020-06-04 5:49:19 139704696166144 [ERROR] mysqld: Table './mlb12_shop/ps_oav_order_ip_log' is marked as crashed and should be repaired 2020-06-04 5:49:19 139704696166144 [Warning] Checking table: './mlb12_shop/ps_oav_order_ip_log' 2020-06-04 5:58:17 139704395568896 [Note] /usr/sbin/mysqld: Normal shutdown затем иногда вылазит простыня из ошибок в MySqlTuner SHOW TABLE STATUS Failed: return code 256 и так для каждой базы, я так понимаю что сервак упал, а скрипт продолжает выполняться может ли быть причина изза нехватки памяти? Physical Memory : 7.63 G Current InnoDB index space = 4.38 G Current InnoDB data space = 6.13 G Current InnoDB buffer pool free = 66 % Current innodb_buffer_pool_size = 6.00 G ... |
|||
:
Нравится:
Не нравится:
|
|||
04.06.2020, 10:08 |
|
mariadb странное поведение
|
|||
---|---|---|---|
#18+
диск надо менять, по крайней мере, пробовать на новом ... |
|||
:
Нравится:
Не нравится:
|
|||
04.06.2020, 14:47 |
|
|
start [/forum/topic.php?fid=47&fpage=20&tid=1828530]: |
0ms |
get settings: |
8ms |
get forum list: |
12ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
39ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
39ms |
get tp. blocked users: |
1ms |
others: | 11ms |
total: | 128ms |
0 / 0 |