…_innodb > 0) { 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_sleep_delay…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 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… help to decrease the time thread waits before it enters the queue. This is done by adjusting innodb_thread_sleep_delay variable. Value is specified…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb_thread_sleep_delayblogpercona.commanual Innodb…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… innodb_stats_sample_pages 8 innodb_strict_mode OFF 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: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=0 innodb-stats-sample-pages=256 innodb-stats-update-need-lock=0 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=4 join…
Comment: kernel_mutex problem. Or double throughput with single variable
December 5, 2011 By 17 Comments
… look at innodb-adaptive-max-sleep-delay in MySQL 5.6. It makes innodb-thread-sleep-delay adaptive and is of particular value over 1024 threads in 5…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL… number of dedicated purge threads. The workload is single-table, and the InnoDB team advises using just one thread for such workloads. On… activity is interspersed with short sleeps and apparently those sleep delays are too long, so let’s try not sleeping at all. This is…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…Created_tmp_tables’, ’669137′ ‘Delayed_errors’, ’0′ ‘Delayed_insert_threads‘, ’0′ ‘Delayed_writes’, ’0′ ‘Flush_commands….95 328 processes: 326 sleeping, 2 running, 0 zombie…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…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
…them eventually). There are no delays between transactions (no thinking time,…innodb_buffer_pool_size = 2048M innodb_thread_concurrency = 0 innodb_max_dirty_pages_pct = 70 innodb…innodb_ibuf_contract_burst is used – comment from InnoDB code /* If there were less than 5 i/os during the one second sleep…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
…which are in “running” state or in “uninterruptable sleep” state which typically corresponds to disk IO. … level locks) or other limiting factors such as innodb_thread_concurrency. The most interesting question I think is…up to 8 and you will see some delays due to queuing. If there are 4CPUs (Cores…
