I found out that my MySQL server is configured with only 128MB for innodb_buffer_pool_size. That is not enough considering that I have a 8GB RAM server. It hosts MySQL server and an Apache/Catalina server. What should I change this seeting to?

  • how much data are in InnoDB ? select SUM(INDEX_LENGTH + DATA_LENGTH) from information_schema.tables WHERE Engine = 'Innodb';
    – akuzminsky
    Oct 25 '14 at 22:49

I have four(4) old posts to demonstrate how to measure and size up the InnoDB Buffer Pool based on the amount of RAM on the DB Server and how much space is currently being taken up by data/index pages:

Please look over these posts, run the queries, and use good judgment. Why did I say to use good judgment ? If the ideal Buffer Pool Size is greater than 6GB (75% of your DB Server's RAM), the highest innodb_buffer_pool_size permissible would be 6G.

Give it a Try !!!

  • Since it is hosting other stuff, 6GB is dangerously high. Start with 5GB. Swapping is terrible for MySQL performance.
    – Rick James
    Dec 21 '19 at 19:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.