May 25, 2012

Post: Load management Techniques for MySQL

… 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: InnoDB's gap locks

… of InnoDB is the row level locking. This feature provides better concurrency … undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id … second one is a global variable that affects all sessions and …dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses …

Post: InnoDB thread concurrency

threads) thread thrashing could be still observed even with limited innodb_thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency

Post: Mess with innodb_thread_concurrency

MySQL 5.0.19 the meaning of innodb_thread_concurrency variable was changed (yeah, again). Now innodb_thread_concurrency=0 means unlimitied count of concurrent threads inside InnoDB

Post: Ultimate MySQL variable and status reference list

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

Post: Tuning InnoDB Concurrency Tickets

…that this variable only comes in to play when innodb_thread_concurrency is greater than zero. On a stock install of MySQL, …InnoDB is limited by innodb_thread_concurrency (which is why these two variables are most often tuned in concert). To continue the example, if innodb_thread_concurrency is set

Post: SHOW INNODB STATUS walk through

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.

… 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

concurrently. It is very typical to hear complains about MySQLmysql –num-threads=1 –max-requests=0 –oltp-dist-type=uniform –max-time=180 –oltp-read-only –mysql-host=localhost –mysql-table-engine=innodbmysql… There is a variable innodb_old_blocks_… so setting innodb_old_blocks_time variable

Comment: What to tune in MySQL Server after installation

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…