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.
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.
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.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
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).
View a complete list of O'Reilly MySQL Conference Contacts