… of architecture implementation details of how it would compare to Innodb storage engine – old timer in this space. Does it add… on each other and as books says competition leads to customer winning. When Falcon looses to Innodb in certain cases it makes… will be an extra pressure to do the fixes. While Innodb was only transactional storage engine there surely was less pressure…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… lets assume you have not followed these recommendations to the book or some things just slipped through. First lets talk about…. Check stats sampling settings such as innodb-stats-method and myisam-stats-method. For Innodb storage engines it is possible for stats… update the stats. You may consider disabling innodb_stats_on_metadata and increasing innodb-stats-sample-pages to get more accurate results…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… way. For instance, when testing the InnoDB FT index, I made sure to increase innodb_buffer_pool_size to 50% of my… to memory was that when I tried to create an InnoDB FT index before declaring the `FTS_DOC_ID` primary key… that compares these technologies for different application types. There are books that describe how to use one technology or the other…
Post: Announcing Training for Operations Teams
August 18, 2010 By 3 Comments
…. The new additions are created by: Splitting our current InnoDB day in half. We now have one day for DBAs, and one day just on InnoDB topics. A new Operations Day – covering how to maintain MySQL… of attending all four days for $1,450 if you book before 30 August. After our initial BETA, the courses will…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
April 21, 2010 By 117 Comments
… had to give up the “speed†of MyISAM for InnoDB. Your benchmarks make me feel much better about my decision… into it deeply since MySQL stated they were moving to InnoDB as their default engine and that there are so many… great article… now I have to get ahold of your book as I feel there is so much I do not…
Comment: Unused indexes by single query
September 14, 2008 By 14 Comments
… additional indexes. In our book we have benchmark for InnoDB and MyISAM: To insert 1 million records in InnoDB with 1 index took…
Comment: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
Thanks Harrison, Indeed we cover a lot of Innodb stuff but again it is hard to get very mich in depth as it could be the whole book alone about Innodb architecture and advanced performance optimization tricks. We of course cover basic things such as short primary keys, clustering etc.
Comment: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
Some very indepth analysis of InnoDB and how it functions, tuning it, etc… would be a … of your blog entries, such as the show innodb status walkthrough). The original book didn’t get into a lot of details…
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
… Ordulu, Software Engineer, and Justin Tomer, Software Engineer, will present “InnoDB Compression: Present and Future”. They will discuss Facebook’s compression… stay at the Hyatt Santa Clara, I encourage you to book your hotel room immediately. Our room block is already full…
Comment: Understand InnoDB spin waits, win a Percona Live ticket
November 28, 2012 By 2 Comments
I came here searching for additional info after reading the section on “show innodb status” in the High Performance MySQL book. This was very clear. Thank you!
