June 19, 2013

Post: Intro to OLAP

between a data warehouse, and a data mart. Introduction to MDX queries and the kind of SQL which a ROLAP tool must generate tocompared or broken down into different dimensions. For example, in a sales analysis, the “sale amount” is a measure. Measures are always aggregated values

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to traditional MyISAM FTS. We’ll get to performance in

Post: Flexviews - part 3 - improving query performance using materialized views

to know right now is that there are two significant differences between the methods. Arows in set (0.00 sec) You can also use this MV to display the total sales amount for any particular customer. Notice how

Post: SHOW INNODB STATUS walk through

tables in use 1, locked 0 MySQL thread id 8079, query id 728899 localhost root Sending data select sql_calc_found_rowsto spot it. In some rare cases purge also could have hard time to keep up with update rate, in this case difference between these values