…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 33 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: 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…
