… MySQL manual, especially the option and…log_fileblogpercona.commanual group_concat_max_lenblogpercona.commanual Handler…commanual interactive_timeoutblogpercona.commanual join_buffer_sizeblogpercona.commanual …commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona.commanual…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… by FlexCDC to update the snapshot to… aggregate functions supported, except GROUP_CONCAT and AVG(distinct). **non…alias: o mview_join_condition: NULL mview_join_order: 999 *************************** 2…too high +——————+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… modified and updated but you can surely use different formula if you like. mysql> select t….)),”;”) cmd from information_schema.table_statistics ts join information_schema.tables t on t.table_… to assign tables to the key caches: mysql> select concat(“CACHE INDEX “,table_schema,”.”,table_name,” IN…
