Question
MySQL server gone down.
I am using a 2GB droplet with 2 Core CPU. My application is CS Cart.
Last day my mysql server gone down. I don’t see any spike in traffic its all normal we don’t have many visitors in site may be a 10 visitors /day.
This is the log file when mysql is down.
2018-07-20T09:26:00.722785Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-20T09:26:00.724979Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.22-0ubuntu18.04.1) starting as process 30120 ...
2018-07-20T09:26:00.758021Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-20T09:26:00.758060Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-20T09:26:00.758067Z 0 [Note] InnoDB: Uses event mutexes
2018-07-20T09:26:00.758072Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-20T09:26:00.758078Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-07-20T09:26:00.758084Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-20T09:26:00.758434Z 0 [Note] InnoDB: Number of pools: 1
2018-07-20T09:26:00.758566Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-07-20T09:26:00.760514Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-20T09:26:00.760560Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-07-20T09:26:00.760571Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2018-07-20T09:26:00.760578Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-07-20T09:26:00.760585Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-07-20T09:26:00.760592Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-07-20T09:26:00.760598Z 0 [ERROR] Failed to initialize builtin plugins.
2018-07-20T09:26:00.760603Z 0 [ERROR] Aborting
2018-07-20T09:26:00.774515Z 0 [Note] Binlog end
2018-07-20T09:26:00.774604Z 0 [Note] Shutting down plugin 'CSV'
2018-07-20T09:26:00.780733Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×