… for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL is really stupid here, and… price for that as I understand), while InfoBright ICE edition allows you only LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that… if you want to compare or get info about air performance.
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… (the same one Peter wrote about recently). The client’s performance is suffering in part because of the number of columns… the next three together. Notes on Infobright A few miscellaneous notes: don’t forget that Infobright is not just a storage engine… a thing. LOAD DATA INFILE in Infobright isn’t what it seems to be. Otherwise, Infobright behaved about as I expected it…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard-Query. Data set It… in cooperation with Infobright, including on benchmarking. These particular tests were performed independently of Infobright, without their knowledge or approval. Infobright was, however, given…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 46 Comments
… http://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, http://www.mysqlperformanceblog.com/2009/10/26… not good for InfoBright, the synthetic nature of benchmark does not allow InfoBright to show better results. But I hope InfoBright will be…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… you can build the functionality you need and get the performance you need. Because I’ve built two such systems to… doing here starts to look like a hillbilly version of Infobright, which I’ll talk about later. Alternately, you can store…, then look at other solutions. One that holds promise is Infobright. While I have not evaluated their technology in depth…
Post: Air traffic queries in LucidDB
October 26, 2009 By 20 Comments
After my first post Analyzing air traffic performance with InfoBright and MonetDB where I was not able to finish task … some compression, but it is not so aggressive as in InfoBright case. As original dataset is 55GB, compression rate for LucidDB…(*) FROM otp.”ontime”; 1 row selected (55.165 seconds) Both InfoBright and MonetDB returned result immediately. It seems LucidDB has to…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… database to spread processing over up to 20 nodes. The Infobright Community Edition (ICE) images are available in 32 and 64… XtraDB. Requires m1.large or larger. ami-f65ea19f shard-query-infobright-demo i686 ICE 3.5.2pl1 32bit. Requires m1.small… favorite storage engine or database About the cluster For best performance, there should be an even data distribution in the system…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… effort was sponsored by Infobright, but this analysis reflects my independent testing from an objective viewpoint. I performed two different types of testing. The first focused on core functionality and compatibility of ICE (Infobright Community Edition) compared…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
November 28, 2009 By 50 Comments
… offer is that I performed the test on 10 years of data using the current version of Infobright Enterprise Edition (3.2… 8,836 seconds) with the single-threaded loader provided in Infobright Community Edition, a ~20X improvement (on my server) and using…. When appropriate I used the COMMENT ‘LOOKUP’ attribute offered by Infobright to transparently convert repetitive text strings to internal, integer lookup…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
This is next post in series Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB Air traffic queries… http://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, and queries I posted on sheet “Queries…
