… than I do, and this can be only checked by comparing performance with your own optimized settings and one database engine would… of Innodb performance problems come however. We should however see how “compact” they would be in real world cases and how much performance… to most storage engines, it certainly can be applied for MyISAM and Innodb. I remember there were plans to implement such handler…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
… and so improving performance dramatically. Actually packed indexes not a bit longer rows is frequent reason of MyISAM performing better than Innodb. In this… string keys is so much slower compared to integer keys. Integer keys still best but for Innodb for example difference is not…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
Everyone using Innodb tables probably got use to the fact Innodb tables perform non locking reads, meaning unless you use some modifiers such… to be Innodb – even if writes are done in MyISAM table. So why was this done, being pretty bad for MySQL Performance and…-READ mode, this operation will be performed in READ-COMMITTED mode, potentially giving different result compared to what pure SELECT would give…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
….5 and instead of expected performance improvement you see your performance being worse. What should you do… rather system warming up. You need to compare apples to apples such as both systems…stats sampling settings such as innodb-stats-method and myisam-stats-method. For Innodb storage engines it is…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and …OS to cache what Innodb is caching already. Innodb cache is more efficient compared to OS … Innodb Buffer Pool selection for dedicated Innodb system. If you have fair amount of MyISAM, Archive,…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? …that look wrong. When I find something, I compare it against the server’s variables or …indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
…time I worked with similar system it used MyISAM and the system was built using multiple tables…be compared directly, still it is nice to see you can get the numbers as high with Innodb…a good workaround but remember partitioning can impact performance of your select queries dramatically. The inserts …
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… as they do not require disk head movement, compared to IO requests in random locations other threads… use Innodb tables and so do not suffer from table locks reporting queries can affect web site performance …or even careful file transfer if you’re using MyISAM tables. Chop it If you can’t execute…
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… response time. OK. Lets start with first simple MyISAM table and join query performed on INT fields: CREATE TABLE `intjoin` ( `i` int… in 4.5 seconds on Innodb which is about 50% slower compared to Joining on Int, for MyISAM however the time became 11… slower for joins compared to integer keys Performance degradation can range from few percent to couple of times for Innodb tables MyISAM Tables may…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… second. Compare that to what your disks are capable of, and draw your own conclusions about whether this is a performance problem… true performance optimization method. I’ve shown that if we make some assumptions that are hard to prove, we can compare Key… a machine that’s dedicated to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM, which is more important to…
