Have you tried 5.4 with new option innodb_extra_dirty_writes? Also I wonder if innodb changes added in 5.4 will be available to innodb team to integrate into next Innodb plugin?
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…innodb_io_capacity = 4000 innodb_support_xa = false innodb_file_per_table = true innodb_buffer_pool_size = 16G innodb_read_io_threads = 8 innodb_write…innodb_extra_rsegments = 64 (affects to initialization of InnoDB…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…_formatblogpercona.commanual defaults_extra_fileblogpercona.commanual defaults_…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…
Comment: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… from 8Gig to 16Gig help the write performance of Innodb on Solaris? >HT: Yes, if your ‘write working set’ fits in 16… that an extra 8G of RAM for the buffer pool might not make that much difference with a 100G write working set… regarding the innodb_log_file_size in relationship to how many ‘dirty‘ writes are allowed. Certainly we can’t have more dirty pages than…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute… = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file…
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… example, if you are using InnoDB tables and the MySQL server processes a COMMIT statement, it writes the whole transaction to the binary log and then commits this transaction into InnoDB. If the server…’re using, is it safe to DISABLE innodb_xa_support? i.e. will the potential extra “dirty” statement remain in the replication log…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… Extra Large…innodb innodb_max_dirty_pages_pct 75 innodb_max_purge_lag 0 innodb_mirrored_log_groups 1 innodb_old_blocks_pct 37 innodb_old_blocks_time 0 innodb…innodb_table_locks ON innodb_thread_concurrency 0 innodb_thread_sleep_delay 10000 innodb_use_sys_malloc ON innodb_version 1.0.11 innodb_write…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…keys | key | key_len | ref | rows | Extra | +—-+————-+——-+——+—————+——+———+——+———+—————–+ | 1 | SIMPLE | gt | ALL | NULL | NULL |… if running only Innodb tables so you…dirty blocks flushing going on with pretty random IO. Clearly OS write…
Comment: Jeremy Cole on MySQL Replication
June 17, 2006 By 12 Comments
…the buffer pool pages, which becomes “dirty” if there are some unflushed … called “double write buffer” to handle problem of partial page writes. The log …log possibly out of sync with innodb transactional log. However it will not…xa/ – disabling XA saves you from extra fsync which allows to double …
