Report this

What is the reason for this report?

Mysql problem

Posted on April 25, 2014
juan

By juan

I have a vps , 1 core, 1gb ram. ZPanel and two domains, one with hairspire marketing and the other with wordpress, everything has very little traffic

The problem is that mysql is dropped, especially when creating a new item in wp, but can be at any time, it can be? Thank you!



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!

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.

my.cnf <br> <br># * Fine Tuning <br># <br>key_buffer = 16M <br>max_allowed_packet = 1M <br>thread_stack = 64K <br>thread_cache_size = 4 <br># This replaces the startup script and checks MyISAM tables if needed <br># the first time they are touched <br>myisam-recover = BACKUP <br>#max_connections = 500 <br>#table_cache = 64 <br>#thread_concurrency = 40 <br># <br># * Query Cache Configuration <br># <br>query_cache_limit = 1M <br>query_cache_size = 16M

log mysql: <br> <br> <br>140425 15:06:32 [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$ <br>140425 15:06:32 [Note] Plugin ‘FEDERATED’ is disabled. <br>140425 15:06:32 InnoDB: The InnoDB memory heap is disabled <br>140425 15:06:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins <br>140425 15:06:32 InnoDB: Compressed tables use zlib 1.2.3.4 <br>140425 15:06:33 InnoDB: Initializing buffer pool, size = 128.0M <br>InnoDB: mmap(137363456 bytes) failed; errno 12 <br>140425 15:06:33 InnoDB: Completed initialization of buffer pool <br>140425 15:06:33 InnoDB: Fatal error: cannot allocate memory for the buffer pool <br>140425 15:06:33 [ERROR] Plugin ‘InnoDB’ init function returned error. <br>140425 15:06:33 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. <br>140425 15:06:33 [ERROR] Unknown/unsupported storage engine: InnoDB <br>140425 15:06:33 [ERROR] Aborting <br> <br>140425 15:06:33 [Note] /usr/sbin/mysqld: Shutdown complete <br> <br>140425 15:06:33 [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$ <br>140425 15:06:33 [Note] Plugin ‘FEDERATED’ is disabled. <br>140425 15:06:33 InnoDB: The InnoDB memory heap is disabled <br>140425 15:06:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins <br>140425 15:06:33 InnoDB: Compressed tables use zlib 1.2.3.4 <br>140425 15:06:33 InnoDB: Initializing buffer pool, size = 128.0M <br>InnoDB: mmap(137363456 bytes) failed; errno 12 <br>140425 15:06:33 InnoDB: Completed initialization of buffer pool <br>140425 15:06:33 InnoDB: Fatal error: cannot allocate memory for the buffer pool <br>140425 15:06:33 [ERROR] Plugin ‘InnoDB’ init function returned error. <br>140425 15:06:33 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. <br>140425 15:06:33 [ERROR] Unknown/unsupported storage engine: InnoDB <br>140425 15:06:33 [ERROR] Aborting

The key error seems to be: <br> <br><pre> <br>140425 15:06:33 InnoDB: Initializing buffer pool, size = 128.0M <br>InnoDB: mmap(137363456 bytes) failed; errno 12 <br>140425 15:06:33 InnoDB: Completed initialization of buffer pool <br>140425 15:06:33 InnoDB: Fatal error: cannot allocate memory for the buffer pool <br></pre> <br> <br>It looks like you are running out of memory. There are a number of things you could do. You might want to try adding swap: https://www.digitalocean.com/community/articles/how-to-add-swap-on-ubuntu-12-04 <br> <br>Let us know how it goes!

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.