… continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both… of performance at low concurrency. The SSB The SSB tests a database’s ability to optimize queries for a star schema. A star schema presents… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of the benchmarks posted about MySQL 5.6… sysbench table. The Star Schema Benchmark (SSB) seems ideal for this. I wasn’t going to focus on the performance of individual queries… RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times are…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 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 48 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 14 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 23 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: …
