HN Explorer

11 comments

[ 2.7 ms ] story [ 33.6 ms ] thread
spratap0309
loved the insights on mySql memory management, your practical tips are super helpful and easy to understand. Trying these out. Thanks for sharing!
sgarland
Re: 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...

sjtly16
Re: Calculates various parameters for the InnoDB buffer pool based on a simple input

Thanks for mentioning it, I will go through it.

gmuslera
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.
bpbp-mango
Does anyone know if MySQL is now in maintenance mode?
makmanalp
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.