…-2680 (8 cores, 16 threads) with fast IO (OCZ R4…InnoDB may perform differently under concurrency, which this benchmark does not cover. I will make a follow-up post about concurrency…my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D Prabhu). Donor node…. Bug fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements, a…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for… This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey … in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for… This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey … in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed …
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
…thread_concurrency in their my.cnf file by default. One example is Debian and its variants. Furthermore the default my.cnf files of MySQL like my-large.cnf, my-innodb…tuning-innodb-concurrency-tickets/ innodb_thread_concurrency places a limit on the number of threads that can be running inside InnoDB…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_…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: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… patch). my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem…_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io_threads = 16 join…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… are still done similar way ? Other the years variables like innodb_thread_concurrency were added with rather complicated history of changes for meaning…” ? Using string values would make things much more friendly with my.cnf and “show variables” output being more obvious and self documenting…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-status-file innodb-strict-mode innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats-table innodb-write-io-threads…
Comment: Should MySQL update the default innodb_log_file_size?
November 24, 2011 By 37 Comments
… small” ” for innodb_thread_concurrency %lu.\n” “InnoDB: The combined size of ib_logfiles” ” should be bigger than\n” “InnoDB: 200 kB * innodb_thread_concurrency.\n” “InnoDB: To get mysqld to start up, set” ” innodb_thread_concurrency in my.cnf\n” “InnoDB: to a lower value…
