…patterns the MySQL designers know can be improved. But there’s a finite amount of engineer-years … choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY…what you specify in the query? The tuple comparison you’re referring to is this example: WHERE…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…. The following chart shows a results comparison on a single-node (on the left)… first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but…0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL…HDD MySQL configuration for purposes of comparison….mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… consider is string comparison in MySQL is case insensitive by default while hash comparison will be done …, PRIMARY KEY(id1,id2), KEY K(id2)) engine=INNODB; when table has to be traversed … 5″ and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… to publish his comparison of all caches anyway, I decided to check peak performance of all caches compared to MySQL Server, by measuring… MySQL Cache to work CREATE TABLE `test` ( `k` varchar(60) NOT NULL default ”, `val` varchar(255) default NULL, PRIMARY KEY (`k`) ) ENGINE…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… in write workload, though currently comparison with InnoDB will not be fair, as PBXT do not perform fsync() after commit and fully… to fix it soon. Falcon The Storage Engine which is developed in MySQL. The performance we see in our previous benchmarks was not…. Also this engine will not support index coverage optimization, that makes Falcon less attractive from performance reasons. Solid The engine with both pessimistic…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…for MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL…of forum posts. Transactional Storage Engines Performance We’re looking at performance at Open Source Transactional Storage engine MySQL – Innodb, Falcon, SolidDB, …
Page: Presentations
May 3, 2006 By
…- Mercurial Egypt, December 2007 Talk about Mercurial version systems, comparison with similar tools and basic usage patterns Download …storage engine. Download MySQL/Innodb Performance: OS and Hardware MySQL Users Conference 2004, Orlando, FL Presentation shows how much you can improve performance…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… interesting information about how Shard-Query will perform on each database. To do the size comparison, I used the du utility: InnoDB… [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
….mysqlperformanceblog.com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this… DEFAULT NULL, `Div5TailNum` varchar(10) DEFAULT NULL ) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=latin1; Last fields …After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA… about air performance…
