… from the dictionary directly to determine the contents of the view. mysql> select flexviews.get_sql( -> flexviews.get_id(‘demo’,'dashboard_customer… procedure The first parameter to flexviews.refresh() is the materialized view id. Each view has an identifier which can be obtained with flexviews…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
… create and maintain incrementally refreshable materialized views. You might be asking yourself “what is an incrementally refreshable materialized view?”. If so, then keep reading… conceptually so too is the output of a SQL statement. MySQL even includes a SQL statement that makes this perfectly clear… is very expensive. What is a materialized view (MV)? A materialized view is similar to a regular view, in that it represents the result set…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
… Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables and materialized views using Flexviews Scaling Applications with Caching… Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables and materialized views using Flexviews Scaling Applications with Caching… Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… algebra. Materialized views techniques applied to distributed computation I maintain another open source tool called Flexviews which supports incrementally maintaining materialized views….compute resource which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies to…
Post: Derived Tables and Views Performance
August 31, 2006 By 16 Comments
…. Views on other hand do not have to be materialized and normally executed by rewriting the query. It only will be materialized if query merge is impossible or if requested by view…) Query using view is fast again: mysql> create view v as select * from test; Query OK, 0 rows affected (0.08 sec) mysql> select…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… by identifying the data which has changed. Maintain materialized views with Flexviews (the primary purpose of FlexCDC). Feed …. This because the source table is `test`.`demo`. mysql> select * from flexviews.test_demo\G *************************** 1. row *************************** dml_type…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 57 Comments
… to see applications being built utilizing VIEWs functionality which appeared in MySQL 5.0 and quite frequently VIEWs are used to help in… the VIEWS – query merge, in which case VIEW is simply expanded as a macro or Temporary Table in which case VIEW is materialized to… solve the same problem having things more modular and using MySQL VIEWs ? mysql> create view user_counts as select user_id,count(*) cnt from…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
… aggregation. Using materialized views to automate that aggregation process. Comparing the performance of OLAP with and without aggregation over multiple MySQL storage engines…, clustered tables and materialized views. These features make working with a star schema much easier than it may be on MySQL, but it…
Post: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… method for creating materialized views for MySQL data sets. The tool is for MySQL, but the methods are database agnostic. A materialized view is an analogue…
