…. In the 2nd benchmark it is closer to 150K qps. What accounts for the drop? 2) The MySQL Bug #49169 was… reason why we have decided to close this bug.” Does that mean they don’t agree with the Percona server fix? Is…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…some of them are reset to default values. This means that if you run START SLAVE (or if … message, specifically the ‘fix in config file’ part. What happens if we specify the master-user, master-password… set (0,00 sec) Very good! The command does work as expected without any additional tricks. As …
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: Innodb Table Locks
July 31, 2012 By 4 Comments
… are number of row level locks in “S” mode. What does it mean ? Well we asked Innodb to do locking reads so it… being touched. However with Innodb’s lock hierarchy this also means the table need to be locked in “IS” mode. “IS… be prevented until it is unlocked. What does this illustrate ? Very simple – SHOW INNODB STATUS does not know anything about MySQL level locks…
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 16 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
Post: CentOS 5.8 users: your UTF-8 data is in peril with Perl MySQL
February 22, 2013 By 3 Comments
… Perl is concerned, this is Latin1 data. What does this mean for you? In general, it means that Perl could corrupt the data by…
Comment: Innodb Performance Optimization Basics
March 26, 2011 By 75 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…
