…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 the normal binary format FRM. some legacy check for a generic table…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… on the master. So we learned it can be…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: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… Why would you break this paradigm by passing around rows instead of…view over a union of all the already joined and aggregated data from all the nodes. A single temporary table is used to store the results from all the nodes. Since we… do 99.9% of the work, due to the multiple levels of…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…Use DRBD replication instead of MySQL replication. Problem: you end up with an idle standby server, which can’t be used…we could avoid that. Do the replication in the application. I know of applications where they just don’t use…of transactional and non-transactional tables…of view…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… many disks they have instead of how many systems they …because Sphinx is doing all search heavy lifting we only need…or 5 hours ALTER TABLE command. Let me …it very easy to use LVM for backups … support Matt in his views of black boxes. If you… is happening and why. A lot of pieces – filesystem, disk…
