This is my mysql log
2016-12-09T22:10:35.858091Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2016-12-09T22:10:35.862330Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2016-12-09T22:10:36.037707Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-12-09T22:10:36.039697Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-0ubuntu0.16.04.1) starting as process 15446 … 2016-12-09T22:10:36.045338Z 0 [Note] InnoDB: PUNCH HOLE support available 2016-12-09T22:10:36.045383Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-12-09T22:10:36.045391Z 0 [Note] InnoDB: Uses event mutexes 2016-12-09T22:10:36.045398Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2016-12-09T22:10:36.045408Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-12-09T22:10:36.045415Z 0 [Note] InnoDB: Using Linux native AIO 2016-12-09T22:10:36.045702Z 0 [Note] InnoDB: Number of pools: 1 2016-12-09T22:10:36.045843Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-12-09T22:10:36.048002Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-12-09T22:10:36.048123Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12 2016-12-09T22:10:36.048155Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2016-12-09T22:10:36.048174Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2016-12-09T22:10:36.048192Z 0 [ERROR] Plugin ‘InnoDB’ init function returned error. 2016-12-09T22:10:36.048205Z 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 2016-12-09T22:10:36.048218Z 0 [ERROR] Failed to initialize plugins. 2016-12-09T22:10:36.048227Z 0 [ERROR] Aborting
2016-12-09T22:10:36.048240Z 0 [Note] Binlog end 2016-12-09T22:10:36.048331Z 0 [Note] Shutting down plugin ‘CSV’ 2016-12-09T22:10:36.048351Z 0 [Note] Shutting down plugin ‘MyISAM’ 2016-12-09T22:10:36.048838Z 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.
Based on this line:
It looks like your droplet is running out of memory causing the MySQL service to crash. You should look into a larger droplet or making other configuration tweaks to optimize.