I have MySQL 5.5.27-29.0-log instance running specifically for Jenkins. Since tests data is always recreated during setup, ACID is unnecessary and I'm hoping to sacrifice it to gain more performance.
The box has 32GB of RAM, but most of those are used for running tests. I can probably spend another 64M for
The box has 8 cores with 24% utilization as well as SSD drive for MySQL.
Here's what I have so far for my.cnf:
[mysqld] innodb_buffer_pool_size = 256M innodb_log_file_size = 256M innodb_log_buffer_size = 4M innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_write_io_threads = 64 innodb_read_io_threads = 64 innodb_io_capacity = 4000 innodb_doublewrite = 'OFF' innodb_adaptive_flushing_method = keep_average
Anyone have other ideas what else can I turn off to gain performance?