• Mikael Ronstrom's avatar
    Updated InnoDB defaults · 0967b540
    Mikael Ronstrom authored
    1) Buffer Pool size now defaults to 1GB and a minimum of 64MB
    2) Log files are 3 by default and each 128MB in size
    3) Removed innodb-file-io-threads config variable since no longer used
    4) Set read io and write io threads to 8 by default for better default performance
    5) Set log buffer size to 16 MB by default and minimum to 2MB
    6) Set additional memory buffer pool to 8 MB and minimum to 2MB
    7) Set max dirty percent to 75% and decreased to 99% to never allow a completely dirty buffer pool
    8) Increased io capacity to 200 for a good default
    
    0967b540
ha_innodb.cc 238 KB