… originally built is long over, but still the tool… come to the MySQL configuration. MySQL Configuration I used …_log_at_trx_commit = 2 innodb_flush_method = …Table Structure The table structure of the table with no secondary indexes is as follows: CREATE TABLE… have a better view of the whole picture. …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… over time from the “base tables” (those tables on which the view … sec) When the view is ‘enabled’, the contents are created: mysql> call flexviews….| total_lines | +——+————-+————-+————-+ | 1 | 689 | 770793 | 3811 | | 2 | 6543 | 754138 | 3740 | | 3 | 5337 | 742034 | 3674 |…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
…view which uses the MERGE algorithm can merge filter conditions into the view query itself. This has significant performance advantages over TEMPTABLE views. A view…views. This example is somewhere in between those two extremes: mysql> create table params ( view…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…created…views that are based on only a single base table. Knowing this, the query result set is treated as a materialized view over…over any type of compute resource which speaks SQL, but right now only MySQL…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…DISTINCT and UNION may/will also create temp tables; the same applies to views and probably some other things…laptop: mysql> set @a := repeat(‘a’, 1024 * 1024 * 100); Query OK, 0 rows affected (2.34 sec) mysql> …monitoring tool to watch the actual memory usage over time and see how it varies. When …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…sure they are sampled over decent period of time…MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign key constraint fails for table…and written. Created pages is empty pages created in buffer … queries in queue 1 read views open inside InnoDB Main …
Post: Intro to OLAP
July 12, 2010 By 9 Comments
… views to automate that aggregation process. Comparing the performance of OLAP with and without aggregation over multiple MySQL storage…is performed, but more on this in post #2. OLAP? What is that? OLAP is an …the user as a ‘pivot table‘ or ‘pivot report’. While you could create such a report in a …
