… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… these things operate. For example, if the workload is a star schema data warehouse, it is important to know a lot about…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 46 Comments
…com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, http://www.mysqlperformanceblog…early-alpha/). Addressing these issues, I took Star Schema Benchmark, which is TPC-H modification, and…s blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-…
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… to at least 20 nodes This post is a detailed performance analysis of what I’ve coined “distributed set processing”. Please… this, but it requires further investigation. Next I compared the performance of 20 m1.large machines cold, versus hot. I did… raw input data set was 55GB before converting to a star schema (21GB) and being compressed by ICE to 2.5GB. Many…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
… this reason OLAP analysis usually is performed on a star schema which partially denormalizes the data. A star schema about a particular subject matter, such…. These are not as popular as star schemas because they tend to not perform as well as a star schema, particularly as the volume of… working with a star schema much easier than it may be on MySQL, but it is definitely possibly to use MySQL as long as…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
… we are able to get from performance schema tables. 1. table_io_waits_summary_by_table mysql> select * from table_io_waits_summary… mysql> select OBJECT_NAME,COUNT_STAR from table_io_waits_summary_by_table order by COUNT_STAR DESC LIMIT 5; +————-+————+ | OBJECT_NAME | COUNT_STAR…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… open source tool kit which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines… is desirable to benchmark using a star schema, even though it involves work to transform the data. Star schema Transforming the data was straightforward…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… use traditional DW methods, like star schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing workload… some of MySQL‘s weaknesses in some cases. Not only that, but star schemas are not intended to be fast. The star schema is essentially… a lot of rows — MySQL can’t handle too many of those at once. Aside from star schemas, another tactic I see people…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
…about how I measured the performance on a join between a few tables in a typical star schema data warehousing scenario. In …_row_length: 117 Data_length: 17217646764 Index_length: 11993816064 mysql> show table status like ‘dim1′\G *************************** 1. row *************************** Name: …
Post: How to estimate query completion time in MySQL
April 22, 2008 By 14 Comments
… star schema query. The fact table was very large, and after some tuning (I’ll write more about that later) I convinced MySQL to perform the query as a table scan of the fact table… to choose another thread and watch only its status, but MySQL doesn’t currently let you do that.) The solution was…
Post: Intro to OLAP
July 12, 2010 By 9 Comments
… structured as a STAR or snowflake type schema. To go back to the sales analysis example above, in a STAR schema the facts about…. [caption id="attachment_3264" align="aligncenter" width="293" caption="Example star schema about sales. "][/caption] Often a dimension will include redundant information… bar charts is possible. Focusing on ROLAP. This is the MySQL performance blog, and as such an in depth discussion of MOLAP…
