…tables t join information_schema.statistics i using (table_schema, table_name) join information_schema.innodb_index_stats s using (table_schema, table…to update our droppable_indexes view to use that information: mysql> drop view if exists droppable_indexes; mysql…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…to you. I’m giving a talk on it at the MySQL … of the result set are updated periodically, not each time the …to ALTER TABLE) Supports all SQL syntax (like outer join) but can’t be refreshed to…How Flexviews uses the deltas to actually make the changes Finally, the last blog post will describe how to…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
… by joining data to yet another table though why it does not work for multiple group remains question to check with MySQL Optimizer team 
UPDATE: I… I figured out how to make MySQL Optimizer to do what we want to do – Just add yet another table to the join so the info table just has…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… want but not how to get it. Most …joined and aggregated data from all the nodes. A single temporary table is used to…to a records in a Flexviews materialized view delta table and thus the logic for applying changes via ON DUPLICATE KEY UPDATE…MySQL storage nodes are supported. Amdahl’s law applies to…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… now as MySQL has triggers which can make updates very different. Also there is no way to tell you how ALTER table would be executed… In MySQL 5.0 with addition of greedy join the problem on looking at too many table join combinations in joins with very large tables is… impossible to tell at which stage MySQL actually perform the sort or creates temporary table and so how much rows will be stored to temporary table…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…to some newly purchased hardware. But how to…MySQL performance counters broken down by users (full joins, table scans, disk temp tables, etc.) limiting command availability to…
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 8 Comments
…to the column. Prior to MySQL 5.1.22 InnoDB used a method to…UPDATE produce gaps on the auto_increment column. To avoid this little inconvenience it is possible to return to…table, as explained on Baron’s blog to get rid of the gaps problem. A “mutex” table is a clever trick that allows joining tables…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…how to…to set up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL…table to the list of tables to changelog. It does this by adding an entry to the `flexviews`.`mvlogs` metadata table, and it creates the changelog table…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
…MySQL…to keep the tables updated and in the complexity of the many scripts or jobs which might be necessary to keep the tables…table to the dimension tables. A note about degenerate dimensions: Any values in the fact table that don’t join to…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…no updates to our msl patch, however recently I managed some time to …how your current MySQL installation was built, so you can have the new binary to be as close to…join, tmp_table, tmp_table_on_disk, filesort, filesort_on_disk] It allows you to filter queries logged by execution plan. For example to…
