…table SELECT * FROM old_table is done and then RENAME old_table to tmp_table, new_table to old_table and finally DROP tmp_table. Let’s see another…table waiting to run on the same table, and as such I have reported the bug: http://bugs.mysql.com/bug.php?id…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…mysql> select * from flexviews.mview_table where mview_id= flexviews.get_id(‘demo’,'dashboard_customer_sales’)\G *************************** 1. row *************************** mview_table_id: 27 mview_id: 21 mview_table…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…from a MySQL master. I’ll talk more about that in another…from that insert. We need to add the table to the list of tables to changelog. There is a utility included with FlexCDC called ‘add_table.php…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…MySQL data sets and queries. Another advantage is that it works with all MySQL…id and destination_airport_id in the fact table, respectively. There are nearly 400 major airports included in the data set. mysql> select count(*) from…loader (loader.php) which…adds parallelism when “subqueries in the from…
Post: GROUP_CONCAT useful GROUP BY extension
September 4, 2006 By 49 Comments
…id,GROUP_CONCAT(client_id) FROM services WHERE id = 3 GROUP BY id; +—-+————————-+ | id | GROUP_CONCAT(client_id) | +—-+————————-+ | 3 | 5,6,7 | +—-+————————-+ Handling in PHP…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…MySQL load on the system. Latency Goal is another…mysql_time/wtime) mysql_ratio ,avg(sphinx_time/wtime) sphinx_ratio, avg((wtime-mysql_time-sphinx_time-utime)/wtime) lost_ratio from…ID as comment to Sphinx log so you can profile it carefully or you can add…
