MySQL-Manage Memory Usage Efficiently
shurutech.com
MySQL-Manage Memory Usage Efficiently
1–10 of 12 posts
Re: MySQL-Manage Memory Usage Efficiently
#2loved the insights on mySql memory management, your practical tips are super helpful and easy to understand. Trying these out. Thanks for sharing!
Re: MySQL-Manage Memory Usage Efficiently
#3Re: 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: MySQL-Manage Memory Usage Efficiently
#4Having 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.
Re: MySQL-Manage Memory Usage Efficiently
#5Does anyone know if MySQL is now in maintenance mode?
Re: MySQL-Manage Memory Usage Efficiently
#6Does 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.
Re: MySQL-Manage Memory Usage Efficiently
#7SUM_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.
Re: MySQL-Manage Memory Usage Efficiently
#8Re: MySQL-Manage Memory Usage Efficiently
#9Re: MySQL-Manage Memory Usage Efficiently
#10Earlier quoted context omitted.
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....