How large should be the innodb_buffer_pool_size?

282 Asked by DavidEDWARDS in SQL Server , Asked on Mar 14, 2023

I have a busy database with solely InnoDB tables which is about 5GB in size. The database runs on a Debian server using SSD disks and I've set max connections = 800 which sometimes saturate and grind the server to halt. The average query per second is about 2.5K. So I need to optimise memory usage to make room for maximum possible connections.

I've seen suggestions that innodb_buffer_pool_size should be up to

Answered by Dipika Agarwal

How large should be the innodb_buffer_pool_size?

Your Answer