Re: Mysql queries peaking to 1M+ occasionally
Posted: Wed Jan 07, 2015 5:10 am
Mystery!GreenUnicorn wrote:
What woud be the best way to find the reason for that?
May be it's ddos or shell?
Community Forum
https://forum.vestacp.com/
Mystery!GreenUnicorn wrote:
What woud be the best way to find the reason for that?
Code: Select all
#RHEL
sudo tail /var/log/mysqld.log
#Debian
sudo tail /var/log/mysql.log
sudo tail /var/log/mysql/error.log
The problem is InnoDB is unable to allocate memory as specified in innodb_buffer_pool_size variable...Please see http://codesplanet.blogspot.com/2014/04 ... tom-0.htmlGreenUnicorn wrote:here we go
Code: Select all
150126 22:31:29 [Note] Plugin 'FEDERATED' is disabled. 150126 22:31:29 InnoDB: The InnoDB memory heap is disabled 150126 22:31:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins 150126 22:31:29 InnoDB: Compressed tables use zlib 1.2.3.4 150126 22:31:29 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 150126 22:31:29 InnoDB: Completed initialization of buffer pool 150126 22:31:29 InnoDB: Fatal error: cannot allocate memory for the buffer pool 150126 22:31:29 [ERROR] Plugin 'InnoDB' init function returned error. 150126 22:31:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 150126 22:31:29 [ERROR] Unknown/unsupported storage engine: InnoDB 150126 22:31:29 [ERROR] Aborting 150126 22:31:29 [Note] /usr/sbin/mysqld: Shutdown complete 150126 22:31:31 [Note] Plugin 'FEDERATED' is disabled. 150126 22:31:31 InnoDB: The InnoDB memory heap is disabled 150126 22:31:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins 150126 22:31:31 InnoDB: Compressed tables use zlib 1.2.3.4 150126 22:31:31 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 150126 22:31:31 InnoDB: Completed initialization of buffer pool 150126 22:31:31 InnoDB: Fatal error: cannot allocate memory for the buffer pool 150126 22:31:31 [ERROR] Plugin 'InnoDB' init function returned error. 150126 22:31:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 150126 22:31:31 [ERROR] Unknown/unsupported storage engine: InnoDB 150126 22:31:31 [ERROR] Aborting 150126 22:31:31 [Note] /usr/sbin/mysqld: Shutdown complete