Re: How to optimize MySQL settings?

[Zach Ellis]

Hello Jason Long

I'm new to mysql so if someone more experienced comes go with them.

info from 8.12.3 Optimizing Memory Use

Typically, a
recommended innodb_buffer_pool_size value is 50 to 75 percent of system memory.

A buffer pool that is too small may cause excessive churning as pages are flushed from the buffer
pool only to be required again a short time later.

The manual says you can change it dynamically so you don't have to reset the server.

I would increase the buffer pool size to what is says in the manual so like 2 to 3 gigs that is if this server is a dedicated server for mysql.

Do you have other apps running on the server thats competing for memory with mysql server?

ill be reading into the other variables that you have listed but the innodb_buffer_pool_size is the one that sticks out to me.

Regards
Zach Ellis