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!
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!
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.