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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Based on this line:
2016-12-09T22:10:36.048155Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.