…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…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… done similar way ? Other the years variables like innodb_thread_concurrency were added with rather complicated history of …’t mix what do you currently have set in your my.cnf file – For example using…0,1,2 will be more explanatory. Furthermore MySQL even has infrastructure to support both string …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…concurrently. It is very typical to hear complains about MySQL…mysql –num-threads=1 –max-requests=0 –oltp-dist-type=uniform –max-time=180 –oltp-read-only –mysql-host=localhost –mysql-table-engine=innodb –mysql… There is a variable innodb_old_blocks_… so setting innodb_old_blocks_time variable …
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:100M:autoextend set-variable = innodb_buffer_pool_size=100M set-variable = innodb_additional_mem_pool_size=10M innodb…=1 #skip-innodb skip-name-resolve # Try number of CPU’s*2 for thread_concurrency thread_concurrency = 16 set-variable=max_connections=2000 [mysql.server] user=mysql basedir=/var…
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… of queries stuck in the innodb queue, with innodb_thread_concurrency set to 8 Happily enough innodb_thread_concurrency is the variable which can be set online so it is… famous Innodb AUTO-INC lock. That would be an easy excuse to blame everything on this lock, suggest upgrading to MySQL 5…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…concurrent_insert – Enables concurrent insert (while Selects are running) for MyISAM storage engine. Other Storage engine ether always have it (ie Innodb…Innodb to not use this variable. sort_buffer_size Buffer used to sort result set (allocated by each thread…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…innodb_support_xa ON innodb_sync_spin_loops 30 innodb_table_locks ON innodb_thread_concurrency 0 innodb_thread_sleep_delay 10000 innodb_use_sys_malloc ON innodb…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… it is not MySQL problem, might be even not problem with your MySQL configuration, queries and …Do push concurrency too high Many developers will test script with multiple level of concurrency and find …. It also often helps with monopolizing replication thread. For example if I need to delete …
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…concurrency of 32 this corresponds to pretty significant load. sysbench –test=oltp –mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads…variables…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…set…variables…MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log_at_trx_commit=0 #innodb_log_file_size=400M # Approx 20% of buffer pool innodb_thread_concurrency…
