… I see “End-to-End Data Protection”, not sure what does that mean. And I just figured that Intel 520 uses compression. http…
Comment: Finding out largest tables on MySQL Server
April 24, 2012 By 24 Comments
….ibd file will not shrink if data is deleted. However, what I’m wondering is if there is a large discrepancy… vs the information_schema query, there is around 9GB discrepancy. Does this have any real world meaning? Thanks
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
…, meaning you could not really recover corrupted Innodb tables this way for about 6 months. What does this mean ? I guess it could mean all…
Post: Table locks in SHOW INNODB STATUS
June 8, 2010 By 1 Comment
… lock does not prevent other threads taking intention shared or even intention exclusive locks on the same table. What does Intention mean ? Just what it says. If Innodb sets intention exclusive lock on the table this means it plans to…
Post: Derived Tables and Views Performance
August 31, 2006 By 14 Comments
Starting MySQL 4.1, MySQL had support for what is called derived tables, inline views or basically subselects in … query merge is impossible or if requested by view creator. What does it mean in terms of performance: Query on base table executes… it took just to execute explain for derived table So what does it mean in practice: Avoid derived tables – If there is other…
Comment: Using LVM for MySQL Backup and Replication Setup
January 14, 2009 By 53 Comments
… is this the case in MySQL? What is the worse case in MySQL? Does it just mean that there may be missing records… tablespaces. I just want to be really clear on this! What does “inconsistent” mean for “user” (non mysql.*) tables? Thanks, Mike
Comment: Innodb Performance Optimization Basics
March 26, 2011 By 70 Comments
What is a loose transaction versus a tight one? You wrote “can loose transactions for last second or two.” What does that mean. I’ve worked in this industry for over 30 years, and I’ve never heard that term before.
Post: Percona's patches spread to a wider audience
October 13, 2008 By 7 Comments
… Lentz is really the brainchild behind this. Kudos Arjen! What does this mean for the Percona patches? Well, now you can get them… The Percona patches and builds represent our best judgment about what‘s the state of the art in the MySQL server…
Comment: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
What is a loose transaction versus a tight one? You wrote “can loose transactions for last second or two.” What does that mean. I’ve worked in this industry for over 30 years, and I’ve never heard that term before.
Comment: xtrabackup-0.9.5rc
October 25, 2009 By 13 Comments
What does hotbackup mean? Can Xtrabackup hotbackup tool work perfectly while MySQL running heavy workload? I met MySQL crashes when running workloads on the recovered data by Xtrabackup.
