Page 1 of 1

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

Posted: Thu Jul 11, 2019 12:44 pm
by webspilka
Здравствуйте подскажите в какую сторону можно покопать
на сервере раз в несколько дней регулярно падает 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
Раньше Swap был неподключен, сегодня добавил

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