… all nodes have their individual LSNs. Instead Cluster uses Global Transaction ID (GTID), in form 50176f05-69b5-11e2-0800-930817fe924a:8549230. So… databases from /mnt/data/mysql 130129 23:01:22 mysqld_safe WSREP: Running position recovery with –log_error=/tmp/tmp.l1zf2BIDja 130129…/local/mysql/bin/mysqld: ready for connections. So what happens there? Basically at start node detects that the last transaction had GTID…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 …COMMANDS: 0 OTHER_COMMANDS: 0 COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_…) # Query 1: 0 QPS, 0x concurrency, ID 0x382A5F3785EB3CEE at byte 114085880 # Scores: Apdex = …
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… stored in the InnoDB shared tablespace (ibdata) and the transaction IDs and log sequence numbers that are stored in the tablespace files also… /var/lib/mysql/data/employees/ Import the new tablespace: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries IMPORT TABLESPACE; mysql> set FOREIGN…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 368, undo log entries 1 MySQL thread id 9697561, query id… LIST OF TRANSACTIONS FOR EACH SESSION: —TRANSACTION 0 0, not started, process no 3396, OS thread id 1152440672 MySQL thread id 8080, query id 728900 localhost… large. Transaction id is current transaction identifier – it is incremented for each transaction. Purge done for trx’s n:o is number of transaction to…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… a transaction, the DML statements from that transaction are written to the binary log. They are called binary log events. A binary log event contains the server-id where it… was the loop of events from server-id 2? # mysqlbinlog mysql-relay-bin.000x | grep ‘id 2′ | sort | uniq Special thanks to Kenny…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 localhost msandbox TABLE LOCK table `test`.`t` trx id 72C…` trx id 72C lock_mode X locks gap before rec If you have lot of gaps locks in your transactions affecting the…
Post: Differences between READ-COMMITTED and REPEATABLE-READ transaction isolation levels
August 28, 2012 By 3 Comments
…_id = 0 where store_id = 1; —TRANSACTION 1EAB04, ACTIVE 7 sec 633 lock struct(s), heap size 96696, 218786 row lock(s), undo log entries 1 MySQL thread id…: —TRANSACTION 1EAB06, ACTIVE 11 sec 631 lock struct(s), heap size 96696, 1 row lock(s), undo log entries 1 MySQL thread id 4…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… you have long enough ACTIVE transactions which have some locks, like in this case: MySQL thread id 2059, query id 1014425 10.10.10… row lock(s), undo log entries 1 MySQL thread id 1720, query id 1011283 10.10.10.10 user —TRANSACTION 2 1418397881, ACTIVE 317 sec, process no 1098, OS thread id…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
… for how to filter by statement. Looking through the binary logs I could see this table is actually an audit table…_History_ID, Name, Value, Field_Id) Values (Old.Foo_History_ID, Old.Name, Old.Value, Old.Field_Id); Transaction 1 starts and updates. Start Transaction; Update Foo set Value=6 Where Field_ID = 3; Transaction 2 starts, updates and commits. Start Transaction…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here …Race condition after btr_cur_pessimistic_update()” (revision id: marko.makela@oracle.com-20110616072721-8bo92ctixq6eqavr ). I…log about the tablespace extension to the mini-transaction of the BLOB write, not to the mini-transaction…
