MySQL-Manage Memory Usage Efficiently
shurutech.comRe: online buffer pool resizing, it’s important to note that you can only resize in multiples of innodb_buffer_pool_chunk_size, and the resulting size must be a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances.
Because of this and other complications / desired optimizations, I wrote a script [0] to calculate the necessary parameters, given either a desired percentage of system RAM, or an absolute size.
[0]: https://gist.github.com/stephanGarland/cd6a5c667e8406cf9cfb6...
Re: Calculates various parameters for the InnoDB buffer pool based on a simple input
Thanks for mentioning it, I will go through it.
I am not a dba but I have successfully tuned a couple of mysql/mariadb servers in the past with the help of Mysqltuner
Having a running record on how those buffers and connections are used is always helpful. Percona’s PMM looks great in that sense. But in general tracking those metrics (and more) in your time series based monitoring, whatever solution it is has been pretty useful to me.
SUM_TIMER_WAIT from performance_schema.events_stages_summary_global_by_event_name does not track memory allocations - it's a counter for time spent on that query stage.
Does anyone know if MySQL is now in maintenance mode?
No? It’s still under active development; 8.3.0 came out in January of this year.
Not much in terms of new features.
What features are you waiting for?
If someone wants to check notes for Oracle:s implementation: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-36....
Not many new features are needed
loved the insights on mySql memory management, your practical tips are super helpful and easy to understand. Trying these out. Thanks for sharing!