…this sample database to spread processing over up to 20 nodes….airport_id`), KEY `CityName` (`CityName`), KEY `State` (`State`) ) ENGINE=InnoDB DEFAULT CHARSET=… -v internal |tee hosts.internal [host list omitted] Now you need …=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 …
Comment: MySQL 4 to MySQL 5 Upgrade performance regressions
June 15, 2009 By 8 Comments
… a day MySQL hangs. In the process list I see some update statements in the ‘end state‘, often I also see a commit statement. This statments need about 1 min to execute. In the meantime the process list grows an all statments are blocked from executing (time column increasing). As soon the update or commit statment is…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…MySQL version: 5.5.16 Initial benchmark, which InnoDB configured for this hardware innodb_flush_log_at_trx_commit…MySQL stuck. As you see stalls are very severe. There are 4 mins periods, when MySQL is not able to process… state. Vanilla MySQL …list 105, single page 0 First, Pending writes “flush list…
Post: Announcing Percona Server 5.5.27-29.0
October 11, 2012 By Leave a Comment
…dump would hold LRU_list_mutex during the entire dump process. Now the …_logs_days was broken by group_commit patch introduced in Percona Server … XA transactions in the PREPARED state. Bug fixed #1036040 (Stewart Smith). … of indexes per table. Upstream MySQL bugs: #54127, #61178, #61179 and #61180. …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… Software Repositories). Based on MySQL 5.5.16, including …process can be speed up by having prefetch threads to warm the server: replay statements and then rollback at commit…were left in a bogus state until an explicit ANALYZE …slow-admin-statements was not listed with SHOW VARIABLES. #830199 (Oleg…
Post: When does Innodb Start Transaction ?
January 11, 2011 By 9 Comments
… see “not started” status in transaction list. It is only when you read …F56AED, ACTIVE 4 sec, process no 23727, OS thread id 139753656395520 MySQL thread id 112,…start of transaction until it is committed so delaying the start makes sense… repeatable read mode reads will see state of data at the time …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…LIST OF TRANSACTIONS FOR EACH SESSION: —TRANSACTION 0 0, not started, process no 3396, OS thread id 1152440672 MySQL… on your innodb_flush_log_at_trx_commit value your log writes may be more…open inside InnoDB Main thread process no. 10099, id 88021936, state: waiting for server activity Number…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…_COMMANDS: 89557 COMMIT_TRANSACTIONS: 90259…the list of…it processes query or…mysql> show processlist; +——–+————-+———–+——+———+——+———————————————————————–+——————+ | Id | User | Host | db | Command | Time | State…
Post: Innodb undo segment size and transaction isolation
January 12, 2011 By 3 Comments
… —TRANSACTION 17402D749, ACTIVE 15867 sec, process no 19349, OS thread id 1630148928 MySQL thread id 188790, query id…check history size in SHOW INNODB STATUS: History list length 4000567 Mind however this size is … state of any row in Innodb table at that point in time. If you use READ-COMMITTED…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… state and appropriate .ibd file may be open or closed. Furthermore besides MySQL table_… tables with single integer column. The process of creating tables took about 45 … (with innodb_flush_log_at_trx_commit=0) go giving 550 and 380 … for replacing open files in the list. I guess Heikki knows how to…
