….commanual innodb_log_group_home_dirblogpercona.commanual Innodb_log_waitsblogpercona.commanual Innodb_log_write_requestsblogpercona.commanual Innodb_log_writesblogpercona.commanual innodb_max_dirty_pages_pctblogpercona.commanual innodb_max_purge_lagblogpercona.commanual innodb_mirrored_log…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… 8388608 innodb_log_file_size 134217728 innodb_log_files_in_group 2 innodb_log_group_home_dir /rdsdbdata/log/innodb innodb_max_dirty_pages_pct 75 innodb_max_purge_lag 0 innodb_mirrored_log_groups 1 innodb_old_blocks_pct 37 innodb…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io… bigger difference on writes. Another interesting setting might be a [mirrored] RAID0 with many more stripes as not having proper file…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…db and replicate-ignore-db options which closely mirror behavior of their binlog-do-* counterparts and which… binary logs from the master, filter out only what you need replicated and pass it to the group…. If you have Innodb tables you’re normally OK because you can use –skip-innodb on the filtering…
