… is that it works with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in… the BTS into a single database table called ontime_stage. Then, the airport information was extracted: create table dim_airport( airport_id int…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… over up to 20 nodes. The Infobright Community Edition (ICE) images are available…. Some data hand updated.’; — – Table structure for table `ontime_fact` — CREATE TABLE `ontime_fact` ( `date_id` … from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
….32.2 LucidDB was 0.9.1 The table I loaded data is: CREATE TABLE `ontime` ( `Year` year(4) DEFAULT NULL, `Quarter` tinyint… for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL is really stupid here, and EXPLAIN… price for that as I understand), while InfoBright ICE edition allows you only LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…(whatever that means.) You start out with this: create table ads_by_day_by_blueness ( day date not null… work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …look at other solutions. One that holds promise is Infobright. While I have not evaluated their technology …
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…per client requirements. First off the schema tables. CREATE TABLE `archive_table` ( `id` int(11) NOT NULL AUTO_INCREMENT…mysql> select id from archive_table order by id desc limit 1; +———+ | id | +———+ | 1143883 | +———+ 1 row in set (2.04 sec) mysql…on disk for TokuDB and Infobright…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL… I used the table from the forum search engine, leaving just bunch of ids in it, removing everything else: CREATE TABLE `sptest` ( `id…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
… with DataWarehouse oriented engines I used single table without joins, and with small (as for DW)…. While InfoBright and InfiniDB does not need indexes at all (you actually can’t create indexes here…can’t be resolved by InfoBright optimizer and I need to enable MySQL optimizer. InfiniDB is otherwise …
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… there’s a .deb of MonetDB for it). I created a table with 200 integer columns and loaded it with random numbers…. Notes on Infobright A few miscellaneous notes: don’t forget that Infobright is not just a storage engine plugged into MySQL. It’s… to be. Otherwise, Infobright behaved about as I expected it to; it seemed pretty normal to a MySQL guy. Notes on MonetDB…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… a lot of custom technologies created for caching or scalability issues MySQL could not solve well… innovation is coming from third party vendors – InfoBright and NitroDB presented Storage Engines targeting certain… scale of Big Table with Map Reduce. Indeed I think MySQL Replication usage will reduce…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… TABLES, which is big limitation from my point of view. As workaround I tried to create temporary table, but got another error: mysql> create temporary table… queries it can handle, quite often better than InfoBright. Inability to handle derived tables is significant drawback for me, I hope it…
