Question
Mysql problem
- Posted April 25, 2014
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!
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese 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.
Try DigitalOcean for free
Click below to sign up and get $100 of credit to try our products over 60 days!
I think it’s a configuration problem rather than memory, because the site has no traffic. Just create a post in wordpress and I returned to fall. <br> <br>Apache Error log: <br> <br>[Sat April 26 14:51:58 2014] [error] (12) Can not allocate memory: fork: Unable to fork new process
Your server may lack sufficient RAM to allocate enough memory for MySQL to operate properly. You may want to try increasing RAM to 2GB.
op - 16:23:12 up 37 min, 1 user, load average: 1.50, 3.05, 1.55 <br>Tasks: 97 total, 5 running, 92 sleeping, 0 stopped, 0 zombie <br>Cpu(s): 60.5%us, 7.0%sy, 0.0%ni, 31.9%id, 0.0%wa, 0.0%hi, 0.3%si, 0.3%st <br>Mem: 1018820k total, 739396k used, 279424k free, 10032k buffers <br>Swap: 0k total, 0k used, 0k free, 49216k cached <br> <br>PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND <br>4403 www-data 20 0 354m 52m 4816 S 21.6 5.3 0:01.51 apache2 <br>4428 www-data 20 0 393m 94m 4804 S 19.3 9.5 0:01.39 apache2 <br>4414 www-data 20 0 365m 66m 3920 R 13.0 6.7 0:00.51 apache2 <br>4405 www-data 20 0 349m 85m 4388 R 6.3 8.6 0:01.59 apache2 <br>4417 www-data 20 0 323m 24m 3512 R 2.3 2.5 0:00.19 apache2 <br>4408 www-data 20 0 383m 83m 4700 S 2.0 8.4 0:00.89 apache2 <br>4419 www-data 20 0 315m 17m 3464 S 2.0 1.7 0:00.17 apache2 <br>3120 mysql 20 0 799m 63m 2756 S 0.7 6.3 0:06.06 mysqld <br>10 root 20 0 0 0 0 R 0.3 0.0 0:01.30 rcu_sched <br>4442 root 20 0 17344 1240 916 R 0.3 0.1 0:00.08 top <br>1 root 20 0 24348 924 0 S 0.0 0.1 0:00.98 init <br>2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd <br>3 root 20 0 0 0 0 S 0.0 0.0 0:00.14 ksoftirqd/0 <br>5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H <br>6 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/u:0 <br>7 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/u:0H <br>8 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0 <br>9 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh <br>11 root RT 0 0 0 0 S 0.0 0.0 0:00.09 watchdog/0 <br>12 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 cpuset <br>13 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 khelper <br>14 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs <br>15 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns <br>16 root 20 0 0 0 0 S 0.0 0.0 0:00.00 bdi-default <br>17 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrityd <br>18 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kblockd <br>19 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ata_sff <br>20 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khubd <br>21 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 md <br>22 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 devfreq_wq <br>24 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khungtaskd <br>25 root 20 0 0 0 0 S 0.0 0.0 1:03.29 kswapd0 <br>26 root 25 5 0 0 0 S 0.0 0.0 0:00.00 ksmd <br>27 root 39 19 0 0 0 S 0.0 0.0 0:00.00 khugepaged <br>28 root 20 0 0 0 0 S 0.0 0.0 0:00.00 fsnotify_mark <br>29 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ecryptfs-kthrea <br>30 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 crypto <br>41 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kthrotld <br>42 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/u:1 <br>43 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0 <br>44 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1 <br>46 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 binder <br>66 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 deferwq <br>67 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 charger_manager <br>190 root 20 0 0 0 0 S 0.0 0.0 0:00.08 jbd2/vda-8 <br> <br>i think that apache is using all the ram, i changed the keepalive to off <br> <br>StartServers 5 <br>MinSpareServers 5 <br>MaxSpareServers 10 <br>MaxClients 100 <br>MaxRequestsPerChild 600
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!
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
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