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, 2014 at 22:49

2 Answers 2


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, 2019 at 19:11

It is the default setting. You can modify it not higher than your memory can handle. Depends on the usage, set it to 70% of your memory might be good for a start.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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