… System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables and materialized views using…
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…right now only MySQL storage nodes are supported. Amdahl’s law applies to the distributed processing. The results …
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
… radio telescopes. This data is extracted from the source system(s) and then cleaned up and inserted into the data warehouse…, bitmap indexes, table partitioning, parallel query execution, clustered tables and materialized views. These features make working with a star schema much easier…
Comment: Should we give a MySQL Query Cache a second chance ?
April 11, 2011 By 64 Comments
Improving QC would be great, but Materialized Views could also be used instead of the QC for quite a few senario’s. Could the QC be used to speedup COUNT(*) w/o where for InnoDB/XtraDB?
Comment: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
Improving QC would be great, but Materialized Views could also be used instead of the QC for quite a few senario’s. Could the QC be used to speedup COUNT(*) w/o where for InnoDB/XtraDB?
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables and materialized views using…
Post: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
… gives him an edge on how to make material understandable to the people. Arjen also did fair… he can offer us another competent point of view. Baron has a experience in performance optimization for… already seen the outline, if not read Baron’s announcement so we would appreciate hearing your comments…
