Global Transactions Identifiers are one of the new features regarding replication in … probably want to gradually enable GTID replication for an easier rollback in the event of a problem. And some items in… simplify the transition to GTID-based replication and allow easier rollbacks if something goes wrong.
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… SELECT_COMMANDS: 5904 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 30 COMMIT_TRANSACTIONS: 0 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED… SELECT_COMMANDS: 214801 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 124497 COMMIT_TRANSACTIONS: 0 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED…
Post: Innodb undo segment size and transaction isolation
January 12, 2011 By 3 Comments
… other transactions for execution, this however only applies to read transactions while problem with undo space growth exists for read only transactions as well. This is how long transaction looks: —TRANSACTION 17402D749… record in undo space so row can be deleted on rollback, update and delete however need to put the old row…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… the problem is in concurrency on rollback segment, which by default is single and all transactions are serialized accessing to segment. Fortunately InnoDB internally has mechanism to support multiple rollback segments – and Yasufumi…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… system you should not see transactions spending more than couple of seconds in ACTIVE state. Especially ACTIVE transactions which do not currently… do not explicitly commit transactions unless there were any writes. If database is configured in READ-COMMITTED transaction mode it is actually… killer. If you can’t fix your connection pool to rollback transactions when they are recycled it might be good idea to…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… SELECT_COMMANDS: 14 UPDATE_COMMANDS: 103 OTHER_COMMANDS: 3556 COMMIT_TRANSACTIONS: 0 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 2 LOST_CONNECTIONS: 16 ACCESS_DENIED…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
July 2, 2012 By 63 Comments
… of a High Availability solution without having to deal with rollbacked transaction that needs to be retried at application level because as… of the cluster so they can manage the case where transaction will be rejected by the cluster because of conflictual queries…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… SELECT_COMMANDS: 181243 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 0 COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… SELECT_COMMANDS: 0 UPDATE_COMMANDS: 119127 OTHER_COMMANDS: 89557 COMMIT_TRANSACTIONS: 90259 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 1 LOST_CONNECTIONS: 0 ACCESS_DENIED…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
…_COMMANDS: 0 UPDATE_COMMANDS: 580431 OTHER_COMMANDS: 338857 COMMIT_TRANSACTIONS: 1016571 ROLLBACK_TRANSACTIONS: 0 You can compare the BUSY_TIME to one-half…
