… I wrote about how I measured the performance on a join between a few tables…’s start with the MySQL query optimizer. The optimizer tries to choose the best join …’fact’\G *************************** 1. row *************************** Name: fact Engine: MyISAM Rows: 147045493 Avg_row_length: 117 Data_…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… build the functionality you need and get the performance you need. Because I’ve built two such … cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-…s still another reason to use InnoDB/XtraDB tables… Optimize For I/O It is pretty much inevitable:…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
…(for the same database) you join the better performance you will get. As for any rules … KEY (`id`), KEY `d` (`d`,`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=18007591 DEFAULT CHARSET=latin1 mysql> …(and newer MySQL versions will stop using this optimization method if there are too many combinations to…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…. That would clearly save indexing space. Is this a reasonable performance optimization. (Keep in mind that the prefix adaptive hashing would fail… as PRIMARY key is appended to it internally anyway. For MyISAM table you should use K(id2,id1) in the same… successful in applications which do not need to be optimized for peak performance or the cases when this does not become the…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? … indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it … big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index …
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had… tested MyISAM with myisam_use_mmap option which did not seems to give any significant performance benefit, may be even reducing performance few percents…
Post: Join performance of MyISAM and Innodb
May 29, 2006 By 6 Comments
… as data is clustered together with index and generally highly optimized Innodb builds hash indexes which helps to speed up lookup… hash, which is faster MyISAM does compression for character keys which makes it perform slower for random lookups MyISAM generally has lower processing overhead due to its simplicity MyISAM still a bit…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
… is additional research, especially when MySQL optimizer is not smart in picking …/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, and…MyISAM and TokuDB in empty table with created indexes. Load time for MyISAM: 16608 sec For TokuDB: 19131 sec Datasize (including indexes) MyISAM…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…larger table cache does not always provides the best performance. So I decided to look at yet another …be as good as it gets in terms of optimizations in this space. To keep test alligned to …in Innodb data dictionary the operation is slower than MyISAM tables. Though the difference can be related to …
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… client who has MyISAM tables with many columns (the same one Peter wrote about recently). The client’s performance is suffering in… < 5; Graphs of query performance time for all three databases are really not very helpful, because MyISAM is so much slower that… into MySQL. It’s a complete server with a different optimizer, etc. This point was hammered home during the LOAD DATA…
