[HN Gopher] MySQL-Manage Memory Usage Efficiently
       ___________________________________________________________________
        
       MySQL-Manage Memory Usage Efficiently
        
       Author : sjtly16
       Score  : 9 points
       Date   : 2024-04-10 07:42 UTC (1 days ago)
        
 (HTM) web link (shurutech.com)
 (TXT) w3m dump (shurutech.com)
        
       | spratap0309 wrote:
       | loved the insights on mySql memory management, your practical
       | tips are super helpful and easy to understand. Trying these out.
       | Thanks for sharing!
        
       | sgarland wrote:
       | 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...
        
       | gmuslera wrote:
       | 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 wrote:
       | Does anyone know if MySQL is now in maintenance mode?
        
       ___________________________________________________________________
       (page generated 2024-04-11 23:00 UTC)