… available from Percona Server 5.1.60-13.1 downloads and from the Percona Software Repositories). Based on MySQL 5.1.60, including all the bug fixes in it, Percona Server 5.1.60-13.1 is… users with large MyISAM tables, this could be a great improvement in |myisamchk|, CREATE INDEX and ALTER TABLE performance. Bug Fixed: #878404…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…, and it can’t be because we used MyISAM tables which are not ACID complaint. Plus we …MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5…may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6….
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 53 Comments
… assume MySQL would optimize your VIEWs same way as more advanced database systems would. Same as with subqueries and derived tables MySQL 5.0 will fail and perform very inefficiently in many counts. MySQL has two ways of handling…_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 So how would you get number of comments left by the given user ? mysql> select count…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… say you upgraded from MySQL 5.1 to Percona Server 5.5 and instead of expected performance improvement you see your performance being worse. What should…. Check stats sampling settings such as innodb-stats-method and myisam-stats-method. For Innodb storage engines it is possible for…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1… bad performance. We hope the performance of LIMIT queries will be fixed before release. MyISAM shows stable result. InnoDB is better than MyISAM by…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… distribution but good enough for performance gotcha illustration purposes. The benchmark shows following results for MyISAM using MySQL 5.0.45 run on 4… work to do in addition to fixes done in later MySQL 5.0 versions. We also decided to take a time and… As you can see Falcon perform extremely poorly when single query executed being 1/3rd of MyISAM and 1/6th of Innodb…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
…improving performance dramatically. Actually packed indexes not a bit longer rows is frequent reason of MyISAM performing…be treated differently. For uncompressed index blocks MySQL can do binary search inside the page -…=1 we got join by integer key performing almost 5 times slower than it was – this…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… will LOAD DATA INFILE be optimized same way as for MyISAM tables by separate phase of building Indexes ? Will be UNIQUE… READ-COMMITED isolation mode which will start offering more performance benefits in MySQL 5.1 It also should be possible to start unlocking… some of them to MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge…
Post: How number of columns affects performance ?
September 28, 2009 By 10 Comments
…) unsigned NOT NULL, `t100` tinyint(3) unsigned NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `t99v1` ( `t1` tinyint(3) unsigned… MyISAM format and conversion is needed in all cases. We can also see the table scan speed can be up to 5…. MyISAM is much faster than Innodb when it comes to in memory full table scan. P.S Tests were done on MySQL 5…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself… same with MyISAM tables, because MyISAM can’t be disabled and so if you create tables as MYISAM or ALTER them to MyISAM you… in my todo to see how well MySQL 5.1 row based replication works and performs and I will be testing filtered scenarios…
