… already. OS Waits are relatively slow, and if you get tens …Innodb kernel and still has 400 tickets to use. Innodb tries to limit thread concurrency allowing only innodb_thread_concurrency threads to run inside Innodb…records is insert buffer. Next it shows how many inserts were done in insert buffer…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent…INSERT with multiple values? We build up INSERTS on our clients and insert…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… smaller) or can a bit slow it down. Plus there were bunch of micro optimizations in Innodb in 5.0 series. Also… – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…/sys/5.5.8 tmpdir=/home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache… = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool_size=32M innodb_data_home_dir=/home/mysqld/mdmp/data/ innodb_log…
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… hundreds of queries stuck in the innodb queue, with innodb_thread_concurrency set to 8 Happily enough innodb_thread_concurrency is the variable which can… which again was a false one – because single insert slows down a lot of inserts pile up waiting on the AUTO-INC lock… hundreds of AUTO-INC insert to pile up. This was also very interesting case about optimal innodb_thread_concurrency. I continue reading (and…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… insert statement. concurrent_insert – Enables concurrent insert (while Selects are running) for MyISAM storage engine. Other Storage engine ether always have it (ie Innodb) … from master. It does not affect Innodb and other storage engines transaction logs, slow query log or general log. flush, …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… contains some real-time information, so if the database is slow it start to be an issue. I have implemented some… default-storage-engine=InnoDB bulk_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file_per_table=1 innodb_doublewrite=0…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… ’0′ ‘Com_help’, ’0′ ‘Com_insert‘, ’17889656′ ‘Com_insert_select’, ’11′ ‘Com_kill’, ’47′… ’0′ ‘Slave_running’, ‘OFF’ ‘Slow_launch_threads’, ’0′ ‘Slow_queries’, ’27405′ ‘Sort_merge_passes’,…innodb_flush_log_at_trx_commit=0 #innodb_log_file_size=400M # Approx 20% of buffer pool innodb_thread_concurrency…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…=24M read_buffer_size=9M max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8… set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1 The… not available, for instance) and eking performance out of an InnoDB table for raw SELECT speed will take a committee of…
