… order. What am I doing wrong with my hand-wavy estimates? 234M * (200 + 20) for PK index + 234M * (12 + 7) * 1…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… Double Tree hotel near the San Jose airport with an estimated 500-600 people attending. Monty and David kicked-off the…
Post: When EXPLAIN estimates can go wrong!
October 13, 2011 By 7 Comments
…} (foo2) > show create table test_estimate \G *************************** 1. row *************************** Table: test_estimate Create Table: CREATE TABLE `test_estimate` ( `id` int(11) NOT NULL… pages is going to increase the quality of the estimation, and make the estimation very precise if the index tree is not…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… process so you can see how correct was your original estimates. Assuming you have already some space allocated for LVM undo… space. The last advice I would give on snapshot space estimation would be not to try to save too much on…
Post: How to estimate query completion time in MySQL
April 22, 2008 By 16 Comments
… to finish, anyway? There are actually a few ways to estimate how long it’ll take for the query to complete… what the query is. One of the simplest is to estimate how many rows the query needs to examine, measure how…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… to drop these indexes, an exercise left to the reader. 
Estimating the size of these indexes But, what if we want…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… catch up quickly. So the question becomes how can we estimate replication capacity, so we can deal with replication load before…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… with large number of hard drives. So how do you estimate how long it takes Innodb to Recover ? Now you know…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
… 0 ~ 50% nothing 50% ~ 87.5% estimate flushing as bellow * 87.5% ~ (flushing storm) * estimate blocks to flush based on… how many…_adaptive_flushing = false innodb_adaptive_checkpoint = reflex <estimate> innodb_adaptive_flushing = false innodb_adaptive_checkpoint = estimate case1: “innodb_doublewrite = false” [0~1800…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…/link_out104, index: PRIMARY, space id: 12, root page 3 estimated statistics in dictionary: key vals: 25265338, leaf pages 497839, size…_out104, index: revert_domain, space id: 12, root page 6 estimated statistics in dictionary: key vals: 1204830, leaf pages 133869, size…_out104, index: domain_id, space id: 15, root page 49160 estimated statistics in dictionary: key vals: 5750565, leaf pages 34383, size…
