• inaam's avatar
    branches/zip rb://147 · b7a0c6ac
    inaam authored
    Done away with following two status variables:
    
    innodb_buffer_pool_read_ahead_rnd
    innodb_buffer_pool_read_ahead_seq
    
    Introduced two new status variables:
    innodb_buffer_pool_read_ahead = number of pages read as part of
    readahead since server startup
    innodb_buffer_pool_read_ahead_evicted = number of pages that are read
    in as readahead but were evicted before ever being accessed since
    server startup i.e.: a measure of how badly our readahead is
    performing
    
    SHOW INNODB STATUS will show two extra numbers in buffer pool section:
    pages read ahead/sec and pages evicted without access/sec
    
    Approved by: Marko
    b7a0c6ac
btr0sea.c 47.7 KB