… continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both… tests a database’s ability to optimize queries for a star schema. A star schema presents some unique challenge to the database optimizer. The… data at the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests…
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… RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times are… pool and the other secondary indexes have been pushed out of the buffer pool. mysql> select * from information_schema.innodb_buffer_pool_stats\G…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
…-early-alpha/). Addressing these issues, I took Star Schema Benchmark, which is TPC-H modification, and… requires that index fits into memory during indexing procedure, and for 610GB the index may get to …s blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
…index: mysql> select * from table_io_waits_summary_by_index_usage where OBJECT_NAME=’sbtest55′G *************************** 1. row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA… OBJECT_TYPE: TABLE OBJECT_SCHEMA: sbtest OBJECT_NAME: sbtest55 INDEX_NAME: NULL COUNT_STAR: 17168 SUM_TIMER_…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
… joins, bitmap indexes, table partitioning, parallel query execution, clustered tables and materialized views. These features make 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: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…) ); What can we improve here? Especially assuming that there are indexes other than the primary key, we can shrink the primary… you should use traditional DW methods, like star schemas. The problem is that MySQL doesn’t tend to perform well on a… 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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… checking for default users in the mysql.* tables, running mk-duplicate-key-checker to find redundant indexes, and so on. As with… fixed and bring big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index structures, and the queries… these things operate. For example, if the workload is a star schema data warehouse, it is important to know a lot about…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
…on a join between a few tables in a typical star schema data warehousing scenario. In short, a query that could …: 147045493 Avg_row_length: 117 Data_length: 17217646764 Index_length: 11993816064 mysql> show table status like ‘dim1′\G *************************** 1. row *************************** …
Post: How to estimate query completion time in MySQL
April 22, 2008 By 16 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, then an index lookup in each… to choose another thread and watch only its status, but MySQL doesn’t currently let you do that.) The solution was…
Comment: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… were used instead of multiple instances of MySQL on one, which generally has lower overhead. … varchars in frequently queried tables without covering indexes. StateName VARCHAR(100) in a commonly queried … questions are missing the point about generic star schema queries that you’re really looking at…
