…of supporting aggregation. Then I hit upon the idea of taking SQL constructs like IN and BETWEEN and making these queries execute in…In the end, this means that things get slower as the query has to examine larger volumes of data. Regarding the performance of Shard-Query…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…SQL features used in the query Incremental refresh doesn’t support all of the SQL features available to SELECT statements. Refresh type Aggregation Outer join All SQL…of SQL features not available with the incremental method, like ORDER BY or use of NOW(), it but still provides improved performance…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…of slicing and dicing. And as a result, one of the most common questions we hear is how to build high-performance…of queries you absolutely have to have, if possible, and note the ways and types of aggregation…improve…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…in works which would improve performance of index accesses/index scans. For example retrieving index values first and then accessing rows in…of CPUs will not help. Sometimes it is good idea to manually split query into several, run in parallel and aggregate…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…query pattern responsible for large portion of the load in the application by aggregating query log with mk-query-digest. When I filtered out only queries of…improvements for this workload in Percona Server 5.5 showing up to 2.5 times better performance…mysql_execute_command,my sql_parse,dispatch_…
Post: Intro to OLAP
July 12, 2010 By 9 Comments
…queries. Performance challenges with larger databases, and some ways to help performance using aggregation. Using materialized views to automate that aggregation process. Comparing the performance of…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
…in the query cache. If the results have been cached they are used instead of actually running the query.. This improves…of the unpredictable performance of the MySQL query cache, since the rate of…SQL commands can be used to either replace the contents of…aggregated over time. With this type of…
