4 ms·
MySQL-Manage Memory Usage Efficiently
- spratap0309 2y agoloved the insights on mySql memory management, your practical tips are super helpful and easy to understand. Trying these out. Thanks for sharing!
- sgarland 2y agoRe: 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/cd6a5c667e8406cf9cfb661a12399ddd https://gist.github.com/stephanGarland/cd6a5c667e8406cf9cfb6...
- sjtly16 2y agoRe: Calculates various parameters for the InnoDB buffer pool based on a simple input Thanks for mentioning it, I will go through it.
- gmuslera 2y agoHaving 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.
- bpbp-mango 2y agoDoes anyone know if MySQL is now in maintenance mode?
- sgarland 2y agoNo? It’s still under active development; 8.3.0 came out in January of this year.
- anticodon 2y agoNot much in terms of new features.
- throwaway38375 2y agoNot many new features are needed
- cess11 2y agoWhat 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.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-36....
- makmanalp 2y agoSUM_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.
- nightshift1 2y agoI am not a dba but I have successfully tuned a couple of mysql/mariadb servers in the past with the help of Mysqltuner https://github.com/major/MySQLTuner-perl https://github.com/major/MySQLTuner-perl