… issues, I took Star Schema Benchmark, which is TPC-H modification, and tried run queries against InfoBright, InfiniDB, LucidDB and MonetDB. I… SSB benchmark may be not good for InfoBright, the synthetic nature of benchmark does not allow InfoBright to show better results. But I hope InfoBright…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… allocated for this benchmark. Maybe I will try sometime again. Query execution So I really have data for InfoBright and MonetDB, let see how fast they are in different queries. First favorite query for any database benchmarker is… price for that as I understand), while InfoBright ICE edition allows you only LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
… Star Schema Benchmark got a lot of interest (links: http://www.mysqlperformanceblog.com/2010/01/07/star-schema-bechmark-infobright-infinidb-and-luciddb/ http://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb…
Post: Air traffic queries in LucidDB
October 26, 2009 By 20 Comments
… on LucidDB Wiki page You can find the description of benchmark in original post, there I will show number I have… 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 turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… works with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard… 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: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… take a look at? What follows is not a realistic benchmark, it’s not scientific, it’s just some quick and… 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: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
… is next post in series Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB Air traffic queries… in picking best one. The really nice thing about MonetDB, InfoBright, InfiniDB is that they do not need indexes, so you….mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, and queries I posted on sheet “Queries” in…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… previous posts on this topic: Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB I could not… time for queries it can handle, quite often better than InfoBright. Inability to handle derived tables is significant drawback for me…
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… more more semicolon terminated SQL statements. The queries for the benchmark are in ~ec2-user/shard-query/queries.sql. I have…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
October 3, 2009 By 50 Comments
Some scaling observations on Infobright… A couple of days ago, Baron Schwartz posted some simple load and select benchmarking of MyISAM, Infobright and MonetDB, which Vadim Tkachenko followed up with a more realistic dataset and interesting figures where MonetDB beat Infobright in most…
