…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…= InnoDB, PARTITION p10 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5 concurrent…
Comment: InnoDB thread concurrency
March 19, 2012 By 4 Comments
…/O thread 9 (thread id: 18587) state: waiting for completed aio requests (write thread) but i found that the value of the innodb_thread_concurrency is 8. so, what is wrong with this sitution? what the innodb_thread_concurrency real…
Post: Mess with innodb_thread_concurrency
May 12, 2006 By 1 Comment
….0.8 for unlimited threads you had to set innodb_thread_concurrency over 500 (and default value for innodb_thread_concurrency was 8 ). Starting with MySQL 5.0.8, the default value is 20, and concurrency checking…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…thread->n_tickets_to_enter_innodb–; ENTER; } retry: if (entered_thread < innodb_thread_concurrency) { entered_threads++; thread->n_tickets_to_enter_innodb = innodb_concurrency_tickets; ENTER; } if (innodb_thread_sleep_delay > 0) { thread_sleep(innodb_thread…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max… query for 1, 4, 16, 64, 128, 256 concurrent threads. 3. For each thread perform a warm-up run (duration 180 sec), and…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… on a lot of short write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The actual number may be higher or lower depending on your application and default which is 8 is decent start innodb…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…. Problems in InnoDB that were fixed: Thread trashing issues with count of theads 100+. In this case performance of InnoDB degraded dramatically. The…-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8…
Post: kernel_mutex problem cont. Or triple your throughput
December 2, 2011 By 10 Comments
….8). The best throughput is with innodb_thread_concurrency=8. So now let’s compare results for innodb_thread_concurrency= 0 vs 8 for all range of threads: Threads innodb concurrency=0 innodb concurrency=8 1 11178.34 2 27741.06 4 53364.52 8 92546.73…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 innodb_max_dirty…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… _each_ blob (if we have 8 blobs 8xN bytes will be allocated) Question: How much space InnoDB allocates for each blob outside…: What’s the status of INNODB in 5.1.x? Specifically: What’s the current status of innodb_thread_concurrency ? Is it suggested to set this value to a LARGE value (somewhat like 200) for additional throughput? HT: ha_innodb…
