… custom compiled to remove performance_schema For the InnoDB tests, a 64GB buffer pool was used. O_DIRECT…keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local…innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive workloads especially for large … sort_buffer_size even if you have 64GB of memory to waste. Furthermore doing so…S Note MySQL distribution contains bunch of sample my.cnf files which may be great templates to use….
