Постоянно падает MySQL
Posted: Thu Jul 11, 2019 12:44 pm
Здравствуйте подскажите в какую сторону можно покопать
на сервере раз в несколько дней регулярно падает MySQL, после перезапуска сервера еще день два работает и опять падение
Сервер: 4 GB 2 vCPUs 80 GB
Пример лога
Раньше Swap был неподключен, сегодня добавил
на сервере раз в несколько дней регулярно падает MySQL, после перезапуска сервера еще день два работает и опять падение
Сервер: 4 GB 2 vCPUs 80 GB
Пример лога
Code: Select all
tail -f -n 2000 /var/log/mysql/error.log
190711 10:13:30 [Warning] IP address 'xx.xxx.xx.xx' could not be resolved: Name or service not known
190711 11:29:31 [Note] Plugin 'FEDERATED' is disabled.
190711 11:29:31 InnoDB: The InnoDB memory heap is disabled
190711 11:29:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190711 11:29:31 InnoDB: Compressed tables use zlib 1.2.8
190711 11:29:31 InnoDB: Using Linux native AIO
190711 11:29:31 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
190711 11:29:31 InnoDB: Completed initialization of buffer pool
190711 11:29:31 InnoDB: Fatal error: cannot allocate memory for the buffer pool
190711 11:29:31 [ERROR] Plugin 'InnoDB' init function returned error.
190711 11:29:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
190711 11:29:31 [ERROR] Unknown/unsupported storage engine: InnoDB
190711 11:29:31 [ERROR] Aborting
190711 11:29:31 [Note] /usr/sbin/mysqld: Shutdown complete
190711 11:38:50 [Note] Plugin 'FEDERATED' is disabled.
190711 11:38:50 InnoDB: The InnoDB memory heap is disabled
190711 11:38:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190711 11:38:50 InnoDB: Compressed tables use zlib 1.2.8
190711 11:38:50 InnoDB: Using Linux native AIO
190711 11:38:50 InnoDB: Initializing buffer pool, size = 128.0M
190711 11:38:50 InnoDB: Completed initialization of buffer pool
190711 11:38:50 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 8053555115
190711 11:38:50 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...
InnoDB: Doing recovery: scanned up to log sequence number 8053569970
190711 11:38:51 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
190711 11:38:51 InnoDB: Waiting for the background threads to start
190711 11:38:52 InnoDB: 5.5.62 started; log sequence number 8053569970
190711 11:38:52 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
190711 11:38:52 [Note] - '0.0.0.0' resolves to '0.0.0.0';
190711 11:38:52 [Note] Server socket created on IP: '0.0.0.0'.
190711 11:38:52 [Note] Event Scheduler: Loaded 0 events
190711 11:38:52 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.62-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
190711 11:39:23 [Note] /usr/sbin/mysqld: Normal shutdown
Code: Select all
free -h
total used free shared buffers cached
Mem: 3.9G 2.7G 1.2G 44M 287M 478M
-/+ buffers/cache: 2.0G 1.9G
Swap: 3.0G 24M 3.0G
top - 15:42:57 up 3:57, 1 user, load average: 0.79, 0.68, 0.73
Tasks: 97 total, 2 running, 95 sleeping, 0 stopped, 0 zombie
%Cpu(s): 31.3 us, 3.0 sy, 0.0 ni, 65.3 id, 0.0 wa, 0.0 hi, 0.3 si, 0.0 st
KiB Mem: 4058840 total, 2840140 used, 1218700 free, 294736 buffers
KiB Swap: 3145724 total, 24984 used, 3120740 free. 492000 cached Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21625 www-data 20 0 640268 223560 53460 S 24.9 5.5 1:23.33 apache2
1186 mysql 20 0 1600156 240888 6564 S 23.6 5.9 27:07.46 mysqld
21619 admin 20 0 651128 236596 58468 R 16.9 5.8 1:24.43 apache2
22899 www-data 20 0 639484 223732 54432 S 3.7 5.5 1:01.90 apache2
3 root 20 0 0 0 0 S 2.7 0.0 2:33.39 ksoftirqd/0
13 root 20 0 0 0 0 S 0.3 0.0 2:30.78 ksoftirqd/1
630 nobody 20 0 126872 10236 5000 S 0.3 0.3 0:02.67 do-agent
24236 root 20 0 23540 2832 2364 R 0.3 0.1 0:00.04 top
1 root 20 0 28760 2932 2336 S 0.0 0.1 0:00.62 systemd
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd
5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
6 root 20 0 0 0 0 S 0.0 0.0 0:01.40 kworker/u4:0
7 root 20 0 0 0 0 S 0.0 0.0 0:43.10 rcu_sched
8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
9 root rt 0 0 0 0 S 0.0 0.0 0:00.03 migration/0
10 root rt 0 0 0 0 S 0.0 0.0 0:00.41 watchdog/0
11 root rt 0 0 0 0 S 0.0 0.0 0:01.18 watchdog/1
12 root rt 0 0 0 0 S 0.0 0.0 0:00.02 migration/1
15 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1:0H
16 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 khelper
17 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs
18 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns