Search code examples
mysqlinnodb

MySQL: InnoDB Buffer usage continue growing

I have developed a web application using Laravel and MySQL as my Database with only 14 tables. I have about 3000 user login into the system and do some small transactions. Now I experienced that the InnoDB Buffer usage start at 2% and continnue to grow until about 99,95% and then the application stop to work.

max-Connections = 4000 innodb_buffer_pool_size = 402653184

What else do I need to set/increase to avoid this from happening

Thanks

Solution

  • There is no query running against the INFORMATION_SCHEMA. Problem was solved by DBA, the inno_buffer_pool_size was set to 2Gb and the inno_pool_instances to 2. This stabilizes and the db is running without any problems