best way to tune innodb_buffer_pool_size

soaringeagle
@soaringeagle
5 years ago
3,304 posts
innodb_buffer_pool_size just keeps asking for more and more ram, in mysqqltuner.pl
i know ts supposed to be safe to allow it up to 70% of ram but its been using 73% average and still asking for more, and cpu use was much higher then i liked so i reduced it by 40% instead of increased it
i have 32 gigs the tuners saying now 25.4g i had 18 reduced it to 10...for now

every time i run the tuner it suggests increasing it (if possible) but what would be optimal?


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities

updated by @soaringeagle: 08/02/19 11:00:29PM

Tags