… type of investigations and drill-downs that are common in OLAP analysis. Each query in each flight (Q1.1 for example… MyISAM for everything!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with. MyISAM does not maintain checksum consistency during regular operations and is not ACID compliant. MyISAM…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… functionality and compatibility of ICE (Infobright Community Edition) compared with MyISAM on a small data set. The second part of my…” for typical OLAP analysis queries. These tests were intended to approximate what would happen if you ported a MyISAM OLAP application to ICE…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…. I have next goals with proposed benchmark: Compare engines in OLAP queries for planning, predicting growth, analyzing access patterns to wiki… to load data and run queries against available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB MonetDB LucidDB Greenplum…
Comment: Should you move from MyISAM to Innodb ?
January 28, 2009 By 59 Comments
… speak mostly about OLTP. OLAP with full table scans and similar stuff indeed is the good usage for MyISAM. I should have… InnoDB is almost always better choice than MyISAM. Because I’m that guy who develops OLAP system. My DBs are very small… live without InnoDB. So I think I should stick to MyISAM. I can guess that now, when you started developing XtraDB…
Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 6, 2009 By 26 Comments
…. As you see it is doing better than MyISAM in all queries.” But MyISAM isn’t known for being good at OLTP…’s confusing because I expect InnoDB to be better than MyISAM at general OLTP, so why not benchmark TokuDB against InnoDB… “even though TokuDB is better at this benchmark of an OLAP workload, it does OLTP well too”…?
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… OLTP between MyISAM and InnoDB However, you have to realize that a lot of people has use MySQL in their OLAP application or hybird operation. In that case, I think MyISAM has the advantage. I also…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… joins and aggregation. A star schema is the most common OLAP/DW data model, since it typically represents a data mart…. I should note that I did this preprocessing with the MyISAM storage engine, then I dumped the data to tab delimited…
Comment: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 29, 2010 By 16 Comments
…, I do not think db design in CMS suitable for OLAP benchmarks. Either I do not think OLTP oriented FireBird and… be just pain. I am going to ran on MySQL MyISAM / InnoDB only to have baseline.
Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 10, 2009 By 26 Comments
I agree — InnoDB should do much worse than MyISAM…but I’d like to see how much worse. It … to compare TokuDB to InnoDB in the case of an OLAP workload….TokuDB is supposed to be good for OLTP too…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
David, Yes I speak mostly about OLTP. OLAP with full table scans and similar stuff indeed is the good usage for MyISAM. I should have been more clear with that.
