… thread is not runniing inside innodb kernel status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is… consitent information would cause significant overhead. Note: our book has an updated, more complete, more in-depth explanation of SHOW INNODB OUTPUT.
Post: Doing Re-run of Migrating MyISAM to Innodb Webinar
December 1, 2010 By 9 Comments
… to join webinar. I personally would be very upset having booked my time to attend event, pre-registered to ensure there… to me). As result we have scheduled Migrating MyISAM to Innodb webinar to run again on Tuesday, December 7 at 9AM…
Post: InnoDB/XtraDB Training in New York City!
September 25, 2009 By 2 Comments
… be New York City on October 30, 2009. We’ve booked a training venue in the financial district of Manhattan (90…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… example. If you’re familiar with Malcolm Gladwell’s excellent book Blink, you know the term “thin-slicing.” That describes an… indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe the… might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… for a slave. So you may want to: relax InnoDB durability (innodb_flush_log_at_trx_commit) disable binary logging if it… query writing and wanted to learn MySQL administration suggest any book or practices. Of course I’m biased but High Performance MySQL 3rd edition is a very good book. The online documentation is also a valuable resource. Q: Is…
Post: Friday challenge: ibd recovery
May 15, 2009 By 8 Comments
… by query CREATE TABLE `tryme` ( `email` mediumblob, `content` mediumblob ) ENGINE=InnoDB … (SOME PARAMETERS SKIPPED) …; and I inserted one record into this… content (meaningful English sentence) to given email – will receive our book “High Performance MySQL” 2nd edition, or if he has already…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 18 Comments
… INT NOT NULL DEFAULT 0, PRIMARY KEY (ancestor, descendant) ) ENGINE=InnoDB; Because there isn’t much written about using the Closure…’m using Closure Table, which I learned about from your book and your presentations. I can neither find nor invent a… of itself. I also wrote about Closure Table in my book, SQL Antipatterns: Avoiding the Pitfalls of Database Programming.
Comment: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
I’d just like to point out that Peter is giving you a sneak peek at the upcoming second edition of High Performance MySQL here. This post is like the cliff notes version of the InnoDB tuning advice in the book. So if you like Peter’s posts, get the book when it comes out.
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… was a great workaround if you’re using only Innodb tables – Innodb when Innodb does crash recovery it would print position in master log files up to which replication was done: InnoDB: In a… we were verifying some of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… to my next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually… capacity. What does this have to do with InnoDB? Data clustering. InnoDB‘s primary keys define the physical order rows are… faster. I wrote a lot about this in our book, which is linked from the sidebar above. Don’t Assume…
