May 25, 2012

Comment: Choosing innodb_buffer_pool_size

… db. Historically i’ve worked mainly with smaller clustered DB’s with NDB so an InnoDB db of this size is new… / 4M total) [!!] InnoDB data size / buffer pool: 123.1G/8.0G Variables to adjust: max_connections (> 100) wait_timeout (< 28800) interactive_timeout ( 64M) tmp_table_size (> 128M) max_heap_table_size (> 128M) innodb_buffer_pool_size…