…for transaction depending if it was committed or not. Log Sequence Number (LSN) Log Sequence Numbers correspond to given position in the log files and typically incremented for each log…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 38 Comments
… give you a formula for choosing a configuration …queries at your server’s peak usage time: mysql> pager grep sequence PAGER set to ‘grep sequence…Log sequence number 84 3838334638 1 row in set (0.05 sec) Notice the log sequence number. That’s the total number of bytes written to the transaction log…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… OF TRANSACTIONS FOR EACH SESSION: —TRANSACTION 0 0, not started, process no 3396, OS thread id 1152440672 MySQL thread id 8080, query… much for informational purposes only. — LOG — Log sequence number 84 3000620880 Log flushed up to 84 3000611265 Last checkpoint at 84 2939889199 0 pending log …
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
…For that we will monitor checkpoint age. The checkpoint age is a difference between current log sequence number… global innodb_max_dirty_pages_pct=0; Query OK, 0 rows affected (0.01 sec…all transactions up to very last ———— TRANSACTIONS ———— Trx id counter 0 16644 Purge done for trx’s …
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…sequence of queries in an easy-to-view format, rather than aggregating the worst queries together. This has worked for…logging. There was a transaction that was blocking others and had locks and undo log records, yet had only run SELECT queries…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…log_pos 773 Table_map: `test`.`test` mapped to number 17 #130201 11:21:35 server id 1 end_log…query it would simply block waiting for the long running transaction to finish, this would cause the slave to lag for hours waiting for the transaction…
