… 6Gb of physical memory available but since we run on 32 bit we cannot turn up the innodb_buffer_pool higher than… 1800 + 2*600 = 3G right? To much to handle for 32 bit? Some stats at writing time (18:37 friday) System copes…_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
… in InnoDB with MySQL 5 and RHEL 5. Its a 32 bit machine with 12 Gb RAM. The imp param for InnoDB…/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log…
