…it’s valuable to be able to see both views of query execution time. Why would you want to see the …is to log only selected traffic that is of interest, instead of the potentially large and hard-to-analyze amount of … lot of work for you. Or, you can log queries to a database table and then use SQL to …
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…RDONLY) = 32 <0.000013> So, why is this? It …of the FRM file. This is due to VIEWs being stored as the plain text of the SQL query inside the FRM file instead of…TABLE code path, MySQL uses this magic byte to work out which Storage Engine to ask to drop the table. The main consequence of this bit of…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… -a’ to correct the problem. While everyone should stop and check what this means instead of …, but also updates system tables (if needed), scans all tables for consistency problems, etc. I…use any of these two. With the choice left between RedHat/CentOS and SuSE, I lean towards the former. Why…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… SQL doesn’t work on rows! Why would you break this paradigm by passing around rows instead of sets? From a distributed processing… materialized view over a union of all the already joined and aggregated data from all the nodes. A single temporary table is used to store… insertions into the base table from each node correspond logically to a records in a Flexviews materialized view delta table and thus the logic…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…why. Assume you have a counter in the blogpost table instead which has 2000 byte rows in average. 10mil of posts result in 20GB table…use MyISAM or HEAP tables for this purpose, how do you deal with Table Locks in this case – the script which processes the views…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…to-write ratio is. What are some workarounds? Here are a few I’ve seen: Use DRBD replication instead of…to choose a solution that works for all situations. For example, mixtures of transactional and non-transactional tables…of view…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… disks they have instead of how many systems… hours ALTER TABLE command. Let …it very easy to use LVM for …views of black boxes. If you want to be able to resolve your performance problems you need transparency, you need to have X-Ray vision, you need to understand what is happening and why. A lot of…
