… presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets … a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB)…InnoDB may perform differently under concurrency, which this benchmark does not cover. I will make a follow-up post about concurrency…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…concurrent threads…innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the …asynchronous when Thread Pool feature was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the …asynchronous when Thread Pool feature was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized …
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… that still stands in the way of InnoDB scalability is the trx_list scan on …a notable drop in throughput starting from 256 threads. But Percona Server’s scalability is the …stable throughput even at 4096 concurrent connections. So both the general “trx descriptors” optimization introduced in Percona …
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: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…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…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…of replacement policy optimizations possible. Q8: How do you assess current state of Innodb scalability with multiple threads and multiple concurrent transactions ? HT: … What’s the status of INNODB in 5.1.x? Specifically: What’s the current status of innodb_thread_concurrency ? Is it suggested …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…Thread declared inside InnoDB 400″ means thread is running inside Innodb kernel and still has 400 tickets to use. Innodb tries to limit thread concurrency allowing only innodb_thread_concurrency threads…been flushed you can check if your innodb_log_buffer_size is optimal – if you see more than 30% of…
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… scales pretty bad and there is a big room for optimization. READ_PK_RANGE Query: SELECT min(dob) FROM $tableName WHERE…
