Question

Mysql server keeps stopping unexpectedly

Posted January 24, 2014 164.4k views
Currently running an apache server with wordpress. Keeps bringing up database error connection after a few minutes of doing anything. Attempted to get into mysql through command line. Keep getting error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) Error log dump: 140124 17:29:01 [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 name instead. 140124 17:29:01 [Note] Plugin 'FEDERATED' is disabled. 140124 17:29:01 InnoDB: The InnoDB memory heap is disabled 140124 17:29:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:29:01 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:29:01 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:29:01 InnoDB: Completed initialization of buffer pool 140124 17:29:01 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:29:01 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:29:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:29:01 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:29:01 [ERROR] Aborting 140124 17:29:01 [Note] /usr/sbin/mysqld: Shutdown complete 140124 17:29:02 [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 name instead. 140124 17:29:02 [Note] Plugin 'FEDERATED' is disabled. 140124 17:29:02 InnoDB: The InnoDB memory heap is disabled 140124 17:29:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:29:02 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:29:02 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:29:02 InnoDB: Completed initialization of buffer pool 140124 17:29:02 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:29:02 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:29:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:29:02 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:29:02 [ERROR] Aborting 140124 17:29:02 [Note] /usr/sbin/mysqld: Shutdown complete 140124 17:29:50 [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 name instead. 140124 17:29:50 [Note] Plugin 'FEDERATED' is disabled. 140124 17:29:50 InnoDB: The InnoDB memory heap is disabled 140124 17:29:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:29:50 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:29:50 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:29:50 InnoDB: Completed initialization of buffer pool 140124 17:29:50 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:29:50 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:29:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:29:50 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:29:50 [ERROR] Aborting 140124 17:29:50 [Note] /usr/sbin/mysqld: Shutdown complete 140124 17:29:51 [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 name instead. 140124 17:29:51 [Note] Plugin 'FEDERATED' is disabled. 140124 17:29:51 InnoDB: The InnoDB memory heap is disabled 140124 17:29:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:29:51 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:29:51 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:29:51 InnoDB: Completed initialization of buffer pool 140124 17:29:51 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:29:51 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:29:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:29:51 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:29:51 [ERROR] Aborting 140124 17:29:51 [Note] /usr/sbin/mysqld: Shutdown complete 140124 17:29:52 [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 name instead. 140124 17:29:52 [Note] Plugin 'FEDERATED' is disabled. 140124 17:29:52 InnoDB: The InnoDB memory heap is disabled 140124 17:29:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:29:52 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:29:52 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:29:52 InnoDB: Completed initialization of buffer pool 140124 17:29:52 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:29:52 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:29:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:29:52 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:29:52 [ERROR] Aborting 140124 17:29:52 [Note] /usr/sbin/mysqld: Shutdown complete 140124 17:30:16 [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 name instead. 140124 17:30:16 [Note] Plugin 'FEDERATED' is disabled. 140124 17:30:16 InnoDB: The InnoDB memory heap is disabled 140124 17:30:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:30:16 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:30:16 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:30:16 InnoDB: Completed initialization of buffer pool 140124 17:30:16 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:30:16 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:30:16 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:30:16 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:30:16 [ERROR] Aborting 140124 17:30:16 [Note] /usr/sbin/mysqld: Shutdown complete 140124 17:30:17 [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 name instead. 140124 17:30:17 [Note] Plugin 'FEDERATED' is disabled. 140124 17:30:17 InnoDB: The InnoDB memory heap is disabled 140124 17:30:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:30:17 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:30:17 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:30:17 InnoDB: Completed initialization of buffer pool 140124 17:30:17 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:30:17 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:30:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:30:17 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:30:17 [ERROR] Aborting 140124 17:30:17 [Note] /usr/sbin/mysqld: Shutdown complete 140124 17:30:18 [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 name instead. 140124 17:30:18 [Note] Plugin 'FEDERATED' is disabled. 140124 17:30:18 InnoDB: The InnoDB memory heap is disabled 140124 17:30:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:30:18 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:30:18 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:30:18 InnoDB: Completed initialization of buffer pool 140124 17:30:18 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:30:18 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:30:18 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:30:18 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:30:18 [ERROR] Aborting 140124 17:30:18 [Note] /usr/sbin/mysqld: Shutdown complete 140124 17:30:58 [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 name instead. 140124 17:30:58 [Note] Plugin 'FEDERATED' is disabled. 140124 17:30:58 InnoDB: The InnoDB memory heap is disabled 140124 17:30:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:30:58 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:30:58 InnoDB: Initializing buffer pool, size = 128.0M 140124 17:30:58 InnoDB: Completed initialization of buffer pool 140124 17:30:58 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140124 17:30:58 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140124 17:30:59 InnoDB: Waiting for the background threads to start 140124 17:31:00 InnoDB: 5.5.34 started; log sequence number 20123319 140124 17:31:00 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 140124 17:31:00 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 140124 17:31:00 [Note] Server socket created on IP: '127.0.0.1'. 140124 17:31:00 [Note] Event Scheduler: Loaded 0 events 140124 17:31:00 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.34-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 140124 17:35:14 [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 name instead. 140124 17:35:14 [Note] Plugin 'FEDERATED' is disabled. 140124 17:35:14 InnoDB: The InnoDB memory heap is disabled 140124 17:35:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:35:14 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:35:14 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:35:14 InnoDB: Completed initialization of buffer pool 140124 17:35:14 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:35:14 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:35:14 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:35:14 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:35:14 [ERROR] Aborting 140124 17:35:14 [Note] /usr/sbin/mysqld: Shutdown complete 140124 17:35:15 [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 name instead. 140124 17:35:15 [Note] Plugin 'FEDERATED' is disabled. 140124 17:35:15 InnoDB: The InnoDB memory heap is disabled 140124 17:35:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140124 17:35:15 InnoDB: Compressed tables use zlib 1.2.3.4 140124 17:35:15 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:35:15 InnoDB: Completed initialization of buffer pool 140124 17:35:15 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:35:15 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:35:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:35:15 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:35:15 [ERROR] Aborting 140124 17:35:15 [Note] /usr/sbin/mysqld: Shutdown complete root@Nostalgia:/var/log/mysql# tail /var/log/mysql/error.log InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:35:15 InnoDB: Completed initialization of buffer pool 140124 17:35:15 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:35:15 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:35:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:35:15 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:35:15 [ERROR] Aborting 140124 17:35:15 [Note] /usr/sbin/mysqld: Shutdown complete root@Nostalgia:/var/log/mysql# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) root@Nostalgia:/var/log/mysql# tail /var/log/mysql/error.log InnoDB: mmap(137363456 bytes) failed; errno 12 140124 17:35:15 InnoDB: Completed initialization of buffer pool 140124 17:35:15 InnoDB: Fatal error: cannot allocate memory for the buffer pool 140124 17:35:15 [ERROR] Plugin 'InnoDB' init function returned error. 140124 17:35:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140124 17:35:15 [ERROR] Unknown/unsupported storage engine: InnoDB 140124 17:35:15 [ERROR] Aborting 140124 17:35:15 [Note] /usr/sbin/mysqld: Shutdown complete Help would be nice :)
Add a comment
danbarrow257
By:
danbarrow257
Add a comment
4 comments
  • socialpostdemo May 18, 2015
    Reply Report

    Hi, i am facing this error
    “Can’t connect to local MySQL server through socket ’/var/run/mysqld/mysqld.sock’ (111)”
    every week(Now every day until i restart server).Now only tester are using my webapp even it shows above error.When i run this commond root@Sharebulk:/var/log/mysql# tail -n 50 error.log

    it was showing:

                150515 11:54:24 [ERROR] /usr/sbin/mysqld: Table './photo_editor/fbpage_status_like' is marked as crashed and should be repaired
            150515 11:54:24 [Warning] Checking table:   './photo_editor/fbpage_status_like'
            150515 11:54:24 [ERROR] /usr/sbin/mysqld: Table './photo_editor/fbpages' is marked as crashed and should be repaired
            150515 11:54:24 [Warning] Checking table:   './photo_editor/fbpages'
            150515 11:54:24 [ERROR] /usr/sbin/mysqld: Table './photo_editor/social_fbstatus_foto' is marked as crashed and should be repaired
            150515 11:54:24 [Warning] Checking table:   './photo_editor/social_fbstatus_foto'
            150515 11:54:24 [ERROR] /usr/sbin/mysqld: Table './photo_editor/social_fbuser_info' is marked as crashed and should be repaired
            150515 11:54:24 [Warning] Checking table:   './photo_editor/social_fbuser_info'
            150515 11:54:24 [ERROR] /usr/sbin/mysqld: Table './photo_editor/social_page_status' is marked as crashed and should be repaired
            150515 11:54:24 [Warning] Checking table:   './photo_editor/social_page_status'
            150515 11:54:24 [ERROR] /usr/sbin/mysqld: Table './photo_editor/social_twitter_status' is marked as crashed and should be repaired
            150515 11:54:24 [Warning] Checking table:   './photo_editor/social_twitter_status'
            150515 11:54:24 [ERROR] /usr/sbin/mysqld: Table './photo_editor/social_twtstatus_foto' is marked as crashed and should be repaired
            150515 11:54:24 [Warning] Checking table:   './photo_editor/social_twtstatus_foto'
            150515 11:54:24 [ERROR] /usr/sbin/mysqld: Table './photo_editor/twitter_users_info' is marked as crashed and should be repaired
            150515 11:54:24 [Warning] Checking table:   './photo_editor/twitter_users_info'
            150515 12:10:44 [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 name instead.
            150515 12:10:44 [Note] Plugin 'FEDERATED' is disabled.
            150515 12:10:44 InnoDB: The InnoDB memory heap is disabled
            150515 12:10:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
            150515 12:10:44 InnoDB: Compressed tables use zlib 1.2.8
            150515 12:10:44 InnoDB: Using Linux native AIO
            150515 12:10:44 InnoDB: Initializing buffer pool, size = 128.0M
            InnoDB: mmap(137363456 bytes) failed; errno 12
            150515 12:10:44 InnoDB: Completed initialization of buffer pool
            150515 12:10:44 InnoDB: Fatal error: cannot allocate memory for the buffer pool
            150515 12:10:44 [ERROR] Plugin 'InnoDB' init function returned error.
            150515 12:10:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
            150515 12:10:44 [ERROR] Unknown/unsupported storage engine: InnoDB
            150515 12:10:44 [ERROR] Aborting

            150515 12:10:44 [Note] /usr/sbin/mysqld: Shutdown complete

            150515 12:10:45 [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 name instead.
            150515 12:10:45 [Note] Plugin 'FEDERATED' is disabled.
            150515 12:10:45 InnoDB: The InnoDB memory heap is disabled
            150515 12:10:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
            150515 12:10:45 InnoDB: Compressed tables use zlib 1.2.8
            150515 12:10:45 InnoDB: Using Linux native AIO
            150515 12:10:45 InnoDB: Initializing buffer pool, size = 128.0M
            InnoDB: mmap(137363456 bytes) failed; errno 12
            150515 12:10:45 InnoDB: Completed initialization of buffer pool
            150515 12:10:45 InnoDB: Fatal error: cannot allocate memory for the buffer pool
            150515 12:10:45 [ERROR] Plugin 'InnoDB' init function returned error.
            150515 12:10:45 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
            150515 12:10:45 [ERROR] Unknown/unsupported storage engine: InnoDB
            150515 12:10:45 [ERROR] Aborting

            150515 12:10:45 [Note] /usr/sbin/mysqld: Shutdown complete

            root@Sharebulk:/var/log/mysql#

    How can i fix.Please Give solution.

  • thiago199266 October 15, 2015
    Reply Report
    How To Add Swap on Ubuntu 14.04
    by Justin Ellingwood
    Swap space can be used as an "overflow" area for your system when you run out of RAM. The operating system can store data that would normally be kept in RAM on the hard drive in a specially formatted file. In this guide, we'll demonstrate how to create and use one of these files in Ubuntu 14.04.
  • maxkoryukov February 16, 2016
    Reply Report

    Looks, like there is not enough memory for InnoDB stuff.

    Shortly: add (or replace existing line) to the /etc/mysql/my.cnf :

    innodb_buffer_pool_size = 20M

    This will decrease mysql requirements.

    And here is the original answer (with explanations):

    http://stackoverflow.com/a/12683951/1115187

    Another approaches to solve the problem:

    http://askubuntu.com/a/457932/400409

  • emmaakin November 22, 2017
    Reply Report

    You would need to add group [mysqld] if not you get the Found option without preceding group in config file /etc/mysql/my.cnf at line 22!

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.

×
Submit an Answer
21 answers
rreboto January 21, 2016

This is happening to me on a WordPress droplet. I’ve done two things, one suggested by another answer here. In the [mysqld] section I’ve added innodb_buffer_pool_size = 16M. Note, this is really small, but this is on a small droplet, so it is what it is. Additionally, when mysql eventually crashed I noticed apache having a LOT of processes. It’s likely hogging up all the system memory. Again, this is for a small site, so I tuned down apache by editing /etc/apache2/mods-enabled/mpm_prefork.conf to this:

<IfModule mpm_prefork_module>
    StartServers        3
    MinSpareServers     3
    MaxSpareServers     5
    MaxRequestWorkers   25
    MaxConnectionsPerChild  0
</IfModule>

Updating innodb_buffer_pool_size stabilized the system for a lot longer than before, but apache eventually hogged all the memory. I’m hoping my problem goes away limiting the number of Apache processes that can exist.

Reply Report
me122977 January 25, 2014
Can you backup your existing /etc/mysql/my.cnf and replace it with the this one

http://pastie.org/8665237

This is what I'm currently using on 512 droplet to test.
Reply Report
ipv315 September 15, 2014

I’ve encountered similar issue, and adding 1GB swap solved my problem. See this:
http://www.webtrafficexchange.com/solved-mysql-crash-fatal-error-cannot-allocate-memory-buffer-pool

Reply Report
rreboto January 21, 2016

After applying the mysql and apache tweaks in my previous post I stressed the system using ab. Below are my results. Long story short, the system was able to successfully process 5000 requests across 20 concurrent connections. The system remained stable and no mysql issues.

I’m running this on a 1G droplet, might be tight, but this config seems like it would work on a 512MB as well.

Hope this helps! 

root@KavanaKava:~# time ab -l -n 5000 -c 20 http://example.com/
This is ApacheBench, Version 2.3 <$Revision: 1528965 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 45.55.159.118 (be patient)
Completed 500 requests
Completed 1000 requests
Completed 1500 requests
Completed 2000 requests
Completed 2500 requests
Completed 3000 requests
Completed 3500 requests
Completed 4000 requests
Completed 4500 requests
Completed 5000 requests
Finished 5000 requests


Server Software:        Apache/2.4.7
Server Hostname:        example.com
Server Port:            80

Document Path:          /
Document Length:        Variable

Concurrency Level:      20
Time taken for tests:   508.491 seconds
Complete requests:      5000
Failed requests:        0
Total transferred:      115833214 bytes
HTML transferred:       113373214 bytes
Requests per second:    9.83 [#/sec] (mean)
Time per request:       2033.964 [ms] (mean)
Time per request:       101.698 [ms] (mean, across all concurrent requests)
Transfer rate:          222.46 [Kbytes/sec] received

Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        0    0   0.3      0       6
Processing:   957 2033 184.2   1966    3450
Waiting:      544  897 142.7    858    2746
Total:        957 2033 184.2   1966    3450

Percentage of the requests served within a certain time (ms)
  50%   1966
  66%   2012
  75%   2082
  80%   2163
  90%   2270
  95%   2421
  98%   2566
  99%   2675
 100%   3450 (longest request)

real    8m28.506s
user    0m0.319s
sys 0m1.003s
root@KavanaKava:~#
Reply Report
gparent January 24, 2014
140124 17:35:15 InnoDB: Fatal error: cannot allocate memory for the buffer pool
Reply Report
hawk January 24, 2014
Also, try a pastebin, bro

http://pastie.org
Reply Report
danbarrow257 January 24, 2014
So what can I do to actually fix this problem Im having?
Reply Report
me122977 January 24, 2014
I'm assuming this is MySQL 5.5 or 5.6?
You can try on turning of the performance schema in the my.cnf

More info here: http://dev.mysql.com/doc/refman/5.6/en/performance-schema-startup-configuration.html
If this works you'll then need to decide if you need the performance schema and tweak your my.cnf so everything fits in the memory you have

Create or add the following to your /etc/mysql/my.cnf

[mysqld]
performance_schema=off
Reply Report
danbarrow257 January 25, 2014
The full version title is '5.5.34-0ubuntu0.12.04.1;, I have turned the performance_schema off and it has repeated the fault. My next line of inquiry is that does there have to be a minimum amount of memory to run a mysql server. I am currently at 512MB, will I have to increase this?
Reply Report
me122977 January 25, 2014
Can you run the command: free -m

I had mysql + php-fpm + nginx + memcache running on a 512mb droplet as a test and got everything working.
Reply Report
Previous 1 2 3 Next
Load More Answers

Looking for something else?

Ask a new question Search for more help