… the keynotes are available on percona.tv for your viewing pleasure anytime. Sheeri Cabral also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides will be available soon. Thanks…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…but there are precious few innodb crash recovery tests available. Some folks have noticed this and asked for… hitting a rule that will issue a SET SESSION debug=”d,crash_commit_*”. The test will then… for general test runs. For example, we can view the comparisons of master-slave checksums after the…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…STATUS, there are however few which were not available before. In SHOW INNODB STATUS many values …hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: —TRANSACTION 0 0, not started, process no 3396…queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 10099…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… Release Candidates will introduce new features not yet available in Stable releases. Along with new features, … introduced: innodb_flush_log_at_trx_commit_session – Implements a session-level version of the MySQL global … be delayed if an old consistent read view exists that could see the rows to be…
Post: Percona Server 5.1.49-rel11.3
September 10, 2010 By 1 Comment
…TABLE command. A new session variable was introduced: innodb_flush_log_at_trx_commit_session. Fixed bugs Bug #…operations be delayed if an old consistent read view exists that could see the rows to be…“crash resistent mode†The binary packages are available on our website. The latest source code …
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… number of tables. I still have the same view on Storage Engines – Innodb is my oppinion is … become busy waiting on this table to become available effectively bringing down. Much better solution for us …you see this is where our problems reside. Cache/Session tables (you can throw them away if it …
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… 8192 transaction-isolation REPEATABLE-READ transaction-prealloc-size 4096 updatable-views-with-limit YES userstat FALSE verbose TRUE wait-timeout 28800… refer to “default” or “startup” in addition to “global” and “session” prefixes which are available now it would be quite nice.
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… quite a bit. I simply start a screen session and run it in a loop with a…/ | awk ‘/^\//{print $5}’ | sed -e ‘s/%//g’); if [ "${avail}" -le "${MB_THRESHOLD}" -o "${full}" -ge "${PCT_THRESHOLD}" ];…a sequence of queries in an easy-to-view format, rather than aggregating the worst queries together….
