…condition: USING (order_id) mview_join_order: 999 3 rows in set (0.00 sec) Using the dictionary The following SQL…SQL statement, similar to a regular view. If you choose to use only the complete refresh method, then FlexCDC is not required to use Flexviews. In…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
…to show how to count the number of unique words, an how many times those words appear in…to use the words of the Constitution of the United States of America as an example. It is my favourite document in…to the where clause. This creates boundary conditions… version: — SQL TO SEND TO SHARDS: Array ( …
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…how to maintain cheaply in the previous post. Here are some things we can do: Plot the data as time-series or in…conditions are true. Analyze the distribution of completion times. This is extremely useful… #2 in my numbered …SQL in hand, we might be able to answer questions about what’s happening in…
Post: Four ways to optimize paginated displays
September 24, 2008 By 26 Comments
…use an index (commonly the case), it uses a filesort. Suppose there are a million rows that meet any WHERE conditions…to show the list of pages and the total count, you either a) use SQL…in the same way doesn’t mean you need to. Think about how you use such pages. Do you really go clicking directly to…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
…in those conditions, user’s perceived performances may be more reflected by per-request time to…to happen?) neither how well do the different I/O elevators handles those features. And to the best of my knowledge, SQL…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…SQL…in particular that the server is trying to find is c1=1, but how…conditions under which replication went out of sync? To determine exactly what row is having an issue, we can use the ‘mysqlbinlog’ utility in…
