Summary Tables, Aggregate Tables and Materialized Views Using Flexviews

Justin Swanhart (Percona), Ryan Lowe (Percona)
Average rating: ****.
(4.67, 3 ratings)

Learn to use Flexviews, a stored procedure and PHP based materialized view solution for MySQL. Flexviews is an open source set of tools for creating and maintaining materialized views. Materialized views are also known as summary tables, or aggregate tables. This talk will show how to install Flexviews and take advantage of summary tables to improve your application performance.

Flexviews is a unique materialized view toolkit for MySQL. An open source project started in 2008, it has generated interest from various MySQL community members since its inception, even getting mention in Mark Callaghan’s keynote last year.

This talk will explain at a high level how Flexviews works, and will then dive into how you can create specific views to improve performance for both OLTP and OLAP type workloads.

Materialized views are essential for BI/OLAP and data warehousing environments.

Photo of Justin Swanhart

Justin Swanhart

Percona

I’m a Principal Consultant at Percona. I’ve worked for Proven Scaling, Yahoo, AdBrite and other high volume web sites. My expertise is in scaling high volume websites through horizontal partitioning, data aggregation and query parallelism.

Photo of Ryan Lowe

Ryan Lowe

Percona

Ryan Lowe is a high performance consultant for Percona, where he advises clients on performance and scaleability best practices for a variety of application architectures. In his free time, he likes to blog, play with agent-based simulation models and travel the world.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts