Problems with memory buffer pool doMysql

Asked

Viewed 131 times

1

Hello, I have a machine EC2 in AWS radando Ubuntu server. It turns out that the MySql stopped working and does not come back anymore. The log error shows the following:

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

I have tried to set the value of:

innodb_buffer_pool_size = 64

but nothing helped. Someone can give me a help?

mysql ubuntu memory ec2

  • The error says that Mysql tried to allocate memory and the operating system did not. Maybe you are trying to use more memory than you have available. Already talked to own Amazon support?

  • See also: http://stackoverflow.com/a/13999800

  • Error 12 is "out of memory"! From the log’s understanding he is trying to allocate a 128Mb buffer and is not getting it. The value is half low to give this type of error. What is the result of the "free" command on that same machine?

No answers

Browser other questions tagged mysql ubuntu memory ec2

You are not signed in. Login or sign up in order to post.