…Innodb_pages_writtenblogpercona.commanual innodb_purge_batch_sizeblogpercona.commanual innodb_purge_threadsblogpercona.commanual innodb_read_ahead_thresholdblogpercona.commanual innodb_read_io_threadsblogpercona.commanual innodb_replication_delayblogpercona.commanual innodb…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…Schedulers…innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… this project from MySQL AB side) – to improve how Innodb read-ahead works by having more overlap between requests so thread would rarely need to stall unable to perform any quick IO and unable to progress until scheduled read ahead can…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…I thought Innodb will make sure to schedule synchronous wait in front if read-ahead IO has …expect you can gain significantly with multiple IO threads on systems with large amount of hard…throughput? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…MySQL patches so we can call patched version GoogleSQL. Among them there are number of patches to make Innodb IO scheduling…threads or parallel log recovery features, which he however needs to test properly before really enabling it. Innodb IO…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…thread id 4078512 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 320 MySQL thread…threads, on Windows it however can be adjusted by innodb_file_io_threads variable. For each helper thread you can see thread state – if thread…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… earlier that IO scheduler CFQ coming by default in RedHat / CentOS 5.x may be not so good for MySQL. And …innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_write_io_threads=4 innodb_read_io_threads=4 innodb_io_capacity=800 innodb…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… server we recommend to run MySQL on. What is important I used Noop IO scheduler, instead of default CFQ. Disclaimer…DIRECT innodb_file_per_table = 1 And for XtraDB I additionally used: innodb_io_capacity = 10000 innodb_adaptive_checkpoint = 1 innodb_write_io_threads = 16 innodb_read_io_threads …
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… IO bound or CPU bound, while to understand if MySQL …Innodb storage engine to be more specific. Lets look at update queries (from replication thread…Innodb tries to optimize these reads a bit – there is sequential read ahead and random read… the background on its own schedule. Such flush activity is …
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed by the slave’s SQL thread. This patch allows….067538 # InnoDB_pages_distinct: 20 InnoDB_IO_r_ops is the counter for the number of page read operations scheduled. The acutal number of read operations…
