… matter how crazy the topology or how many servers were missing, we’d have some guidepost for where everything is relative… *************************** 2. row *************************** ts: 2011-08-03T18:12:18.003000 server_id: 5508 file: ginger-bin.000020 position: 21198 relay_master_log… *************************** 3. row *************************** ts: 2011-08-03T18:12:18.001960 server_id: 15511 file: ginger-bin.000002 position: 26478 relay_master_log…
Post: Missing Data - rows used to generate result set
July 20, 2008 By 15 Comments
… instead use Full Text Search indexes. If you have WHERE ID%100=0 you can have extra column divisible_by_hundred…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… our simple example, we know that all the rows are missing, and the one in particular that the server is trying…/*!*/; BEGIN /*!*/; # at 340782 # at 340823 #100506 12:42:56 server id 1 end_log_pos 340678     … update statement. The OLD value (the row that is missing) is represented in the WHERE clause. The binary log…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… ~]$ tail -n 25 /proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R… example, the absence of skip-name-resolve is easy to miss, as is the absence of innodb_log_file_size. I… over it once again and make sure I didn’t miss anything important or write something in a confusing way, and…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… ’0′, PRIMARY KEY (`link_id`), UNIQUE KEY `domain_id_2` (`domain_id`,`link_id`), KEY `domain_id` (`domain_id`,`from_site_id`,`message_published`), KEY `revert_domain…`), KEY `site_message` (`from_site_id`,`message_day`,`isexternal`), KEY `from_message_id` (`from_message_id`,`link_id`) ) ENGINE=InnoDB AUTO_INCREMENT=26141165 DEFAULT… the last point of the post – if you are badly missing some features in MySQL, InnoDB, InnoDB-plugin, XtraDB, XtraBackup – you…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon… couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(64… NOT NULL default ’0′, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY `country_id` (`country_id`,`state_id`,`city`) ) In this benchmark we used…
Comment: Innodb vs MySQL index counts
November 30, 2011 By 6 Comments
… the missing column. The Innodb Table Monitor shows me that ‘foo’ is still in the Data Dictionary: TABLE: name test/test, id… vals 2, leaf pages 1, size pages 1 FIELDS: id DB_TRX_ID DB_ROLL_PTR data foo > alter table test ENGINE… vals 2, leaf pages 1, size pages 1 FIELDS: id DB_TRX_ID DB_ROLL_PTR data I might think twice about…
Comment: Is there a performance difference between JOIN and WHERE?
April 15, 2010 By 25 Comments
Rob: You are missing the fact that JOIN .. ON .. syntax does *not* prevent having … C ON (B.id = C.id) JOIN D ON (A.id = C.id AND D.id = B.id) JOIN E WHERE E.id = A.id AND A.x…, C, D, E WHERE B.id = C.id AND A.id = C.id AND D.id = B.id AND E.id = A.id AND A.x = ‘foo’ AND…
Comment: Innodb vs MySQL index counts
November 30, 2011 By 6 Comments
… (old table frm already copied back, and extra column missing): > select * from test; +—-+——-+———-+ | id | data | foo | +—-+——-+———-+ | 1 | 49999 | NULL | | 2 | 1000 | some… OK, 1 row affected (0.00 sec) > select * from test; +—-+——-+—————+ | id | data | foo | +—-+——-+—————+ | 1 | 49999 | NULL | | 2 | 1000 | NULL | | 3 | 1001…
Post: mk-query-digest, query comments and the query cache
… this comment includes important information, such as the PHP session ID, and the application user name. This allows mk-query digest… results where stripping is not enabled. There are many more misses due to the random values in the query comments. Also… query with static comments. There are 1000 hits and 1000 misses because MySQL treats identical queries with identical comments as the…