Flexviews adds materialized view support to MySQL. Flexviews includes FlexCDC, a change data capture utility which reads MySQL binary logs and produces "change log" tables. These tables can be used to incrementally refresh materialized views, which can be significantly faster than completely rebuilding the views each time. Flexviews also supports "complete refresh" materialized views, which are always rebuilt from scratch each time.
|Tags||MySQL materialized view performance incremental aggregation summary table summaries aggregates aggregate table|