• Jan Lindström's avatar
    MDEV-6930: Make innodb_max_dirty_pages_pct my.cnf variable a double · 60e995cf
    Jan Lindström authored
    Merged Facebook commit ecff018632c6db49bad73d9233c3cdc9f41430e9
    authored by Steaphan Greene from https://github.com/facebook/mysql-5.6
    
    This change is to fix: http://bugs.mysql.com/62534
    
    This makes innodb_max_dirty_pages_pct a double with min,default,max values
    0.001, 75, 99.999.
    
    This also makes innodb_max_dirty_pages_pct_lwm and adaptive_flushing_lwm
    doubles, as these sysvars are inter-dependent.
    
    Added more to the BUFFER POOL AND MEMORY section of SHOW INNODB STATUS:
    Percent pages dirty: X.X
    This is all n_dirty_pages / used_pages
    Percent all pages dirty: X.X
    This is all n_dirty_pages / all-pages
    Max dirty pages percent: X.X
    This is innodb_max_dirty_pages_pct
    
    Also changed all of buf from 2 to 3 digits of precision (%.2f -> %.3f).
    60e995cf
ha_innodb.cc 504 KB