sem88
Junior Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Сегодня вырубился MySQL и не рестанулся. Вот из лога: May 27 03:06:19 vm-1 kernel: [1335889.846615] Out of memory: Kill process 2763 (mysqld) score 164 or sacrifice child May 27 03:06:19 vm-1 kernel: [1335889.847640] Killed process 2763 (mysqld) total-vm:480260kB, anon-rss:83308kB, file-rss:0kB May 27 03:06:20 vm-1 mysqld_safe: Number of processes running now: 0 May 27 03:06:20 vm-1 mysqld_safe: mysqld restarted May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 [Note] /usr/sbin/mysqld (mysqld 5.5.59-0+deb7u1) starting as process 10831 ... May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 [Note] Plugin 'FEDERATED' is disabled. May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 [Warning] /usr/sbin/mysqld: ignoring option '--innodb-file-per-table' due to invalid value 'ON' May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 InnoDB: The InnoDB memory heap is disabled May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 InnoDB: Compressed tables use zlib 1.2.7 May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 InnoDB: Using Linux native AIO May 27 03:06:20 vm-1 mysqld: 180527 3:06:20 InnoDB: Initializing buffer pool, size = 128.0M May 27 03:06:21 vm-1 mysqld: InnoDB: mmap(137363456 bytes) failed; errno 12 May 27 03:06:21 vm-1 mysqld: 180527 3:06:20 InnoDB: Completed initialization of buffer pool May 27 03:06:21 vm-1 mysqld: 180527 3:06:20 InnoDB: Fatal error: cannot allocate memory for the buffer pool May 27 03:06:21 vm-1 mysqld: 180527 3:06:20 [ERROR] Plugin 'InnoDB' init function returned error. May 27 03:06:21 vm-1 mysqld: 180527 3:06:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. May 27 03:06:21 vm-1 mysqld: 180527 3:06:20 [ERROR] Unknown/unsupported storage engine: InnoDB May 27 03:06:21 vm-1 mysqld: 180527 3:06:20 [ERROR] Aborting May 27 03:06:21 vm-1 mysqld: May 27 03:06:21 vm-1 mysqld: 180527 3:06:21 [Note] /usr/sbin/mysqld: Shutdown complete Памяти на vps 512мб. Я понимаю, что в логах идет речь о нехватке памяти. Непонятно почему ее стало не хватать в 3 часа ночи, когда нет никакой нагрузки. Отсюда несколько вопросов: 1 - Как понять, какой из процессов ее сожрал? 2 - Почему mysql не рестанулся? 3 - Что делать? |