… know, not very balanced in terms of I/O). mysqlslap –concurrency=25,50,100,200,500,1000,2000 –iterations=10 –number…-indexes=3 –auto-generate-sql –csv=/tmp/mysqlslap_3index_innodb.csv –engine=innodb –auto-generate-sql-add-autoincrement –auto-generate-sql-load…
Comment: Is Synchronous Replication right for your app?
May 15, 2013 By 18 Comments
… need skip-locked or even more support to improve innodb-as-queue concurrency with and without Galera? http://asktom.oracle.com/pls…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… did the test on 5.6 and load data infile concurrently results for two threads is 20 times slower then 1… we are facing more and more big data challenges where innoDB and TokuDB will have to be compare with LevelDB at…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency variable. A thread is placed in a queue when it tries to enter InnoDB if…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…_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_sleep…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… of threads that runs concurrently you should read about innodb_thread_concurrency: http://www.mysqlperformanceblog.com/2011/07/28/how-innodb-contention-may-manifest…/05/24/tuning-innodb-concurrency-tickets/ innodb_thread_concurrency places a limit on the number of threads that can be running inside InnoDB. The default…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… still have massive scalability drop with increasing concurrency – going from 10 to 20 concurrent connections drops performance from about 620 to 450… nasty surprise. It may be possible to improve it with innodb concurrency settings though – I do not know, this requires some extra… MySQL scalability problem with high number of CPUs and high concurrency is elevated but it is far from being completely eliminated…
Post: kernel_mutex problem cont. Or triple your throughput
December 2, 2011 By 10 Comments
… with innodb_thread_concurrency also may help. So I ran some benchmarks with innodb_thread_concurrency. My explanation on the performance degradation is following: InnoDB… 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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb_data_home_dirblogpercona.commanual Innodb_data…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…€™s the status of INNODB in 5.1.x? Specifically: What’s the current status of innodb_thread_concurrency ? Is it suggested to…_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments. Sets the max\ imum number of threads allowed inside InnoDB…
