How large should be the innodb_buffer_pool_size?
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