We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Постоянно падает MySQL
Постоянно падает MySQL
Здравствуйте подскажите в какую сторону можно покопать
на сервере раз в несколько дней регулярно падает 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