…. So there you have it — yet another surrogate measure. How to choose a key_buffer_size Let’s recap. So far I… ratio and in fact, ignore Key_read_requests altogether. I’ve explained that counters are a surrogate measure, but the fact that…? What about InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… special column `mview$pk` which is an auto_increment BIGINT surrogate key for the table. For complete refresh views which are ordered…, simply ignore this column. It is used to prevent wide innodb primary keys on the MV. mysql> select mview$pk as rank…
