…in MySQL 5.0 and quite frequently VIEWs are used to help in writing the queries – to keep queries simple without really thinking how it affects server… the VIEWS – query merge, in which case VIEW is simply expanded as a macro or Temporary Table in which case VIEW is materialized to temporary tables (…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…. It continues with an overview of how to install and run FlexCDC, and concludes … MySQL log which records changes to tables in the database. FlexCDC reads the binary log to determine … local access to the tables and the changelogs in order to maintain materialized views. Most database servers have …
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…to INSERT-only workloads, and their are other optimizations that can be applied to views that are based on only a single base table…to operate fully in parallel. Distributed set processing is database agnostic. Keep in mind, at each level of partitioning only a list of servers…
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
…tables per server which can become really inefficient. It is especially inefficient with Innodb tables both in terms of space (some tables…to underlying table MySQL tries to set it to default, which does not work as it has to be different for each of the views…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… to MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated) to… HEAP tables for this purpose, how do you deal with Table Locks in this case – the script which processes the views within last hour has to…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
…in the ‘rows’ section tells the data generator to produce 50 tables, with sizes from 1 row to 50 rows. 3) Specify the server…to use the following command to execute the test: ./dbqp.py –default-server-type=mysql –basedir=/path/to/Percona-Server…to translate Views…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
…in separate dimension tables. Some ROLAP servers support the aggregation of data into additional tables, and can use the tables automatically. These servers…to keep the tables in sync. Part five of my series will introduce materialized views which attempt to address these challenges in…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…tables — don’t use GUIDs. Which brings me to my next point: Use InnoDB Assuming that you will use the stock MySQL server…in MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL…to think about how to avoid enormous tables that are hard to…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to…table, but how long will this take? Is there a facility we can run to show any table / index fragmentation, without having to…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…server (SMT2) so it is pretty realistic setup from typical data center latency point of view though the server…table and will run a long update while running my test to see how the latency is impacted: mysql…
