…0.000011> [pid 19876] close(32) = 0 <0…from several code paths in the server: DROP TABLE RENAME TABLE DROP VIEW open table filling INFORMATION_SCHEMA…how this is used is that in the DROP TABLE code path, MySQL uses this magic byte to work out which Storage Engine to ask to drop…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…to spare. We’re using Percona Server 5.5…To understand it we should take a look at the buffer pool contents. mysql [localhost] {msandbox} (information_schema) > select concat_ws(‘.’, t.schema…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…5 5 iostat -dx 5 5 If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL…server and see what I think about it. If the server is not heavily loaded, I may even do some INFORMATION_SCHEMA queries to…dropped from InnoDB, for example. (The INFORMATION_SCHEMA…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…5.2pl1. Requires m1.large or larger ami-8eb648e7 shard-query-innodb-demo-64bit x86_64 Percona Server 5.5…schema from one shard. The schema is duplicated 20 times (but not the ontime_fact data): DROP…
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
…How let’s connect actor.ibd from sakila database taken from some MySQL server. 0. Create empty InnoDB tablespace. 1. Create the table: mysql…to drop…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to my next point: Use InnoDB Assuming that you will use the stock MySQL server…to scan the whole table to query for information…to think about how to avoid enormous tables that are hard to…from star schemas, another tactic I see people try a lot is to build “flexible schemas…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…to some newly purchased hardware. But how to avoid the undesired situation that you only sort out the least active customers from…to SUPER users only or restricting regular users to see their own statistics only information_schema support to…
