Yeah, a discussion is brewing. You pointed out an important use case for PARTITIONing (“uneven reads”, Re: #1); let me …) remove one record. PARTITIONing makes very little difference. * If it cannot prune, then partitioned would be slower, since it would attempt…
Post: Why message queues and offline processing are so important
August 10, 2010 By 3 Comments
…. Capacity – The system’s capacity is the point where load cannot be increased without degrading response time below acceptable levels. Setting…
Post: Announcing Percona Live MySQL Conference and Expo 2012
August 9, 2011 By 11 Comments
… and opensource-focused conferences are a vitally important part of the MySQL ecosystem, they cannot — cannot — replace the traditional MySQL conference and expo…. Our goal with this conference is to ensure the vitally important combination of business and community continues to have a place…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… a hundred different ways. The kickoff call has some other important goals too. We want to know what your concerns are… disk saturated? Is the machine swapping actively? (This is more important than whether it’s using swap.) There are a lot… I save this part of the analysis for last. You cannot consider any one of these factors (schema, queries, indexing) in…
Post: Percona Toolkit 2.1.9 is ready
February 15, 2013 By Leave a Comment
…-heartbeat 2.1.7 and older, but it also has important bug fixes for other tools. * Fixed bug 1103221: pt-heartbeat…-positive error “Cannot nibble table because MySQL chose no index instead of the PRIMARY index” This is an important bug fix for…-checksum resulted in an impossible WHERE, causing the false-positive “Cannot nibble” error, if those chunks had diffs. * Fixed bug 1099836…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… parts after the part on which range condition is applied cannot be used for filtering records. For example, suppose you have…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… was extended a little bit and what’s even more important the patch is available for all the recent MySQL releases… be created. This is also the only option which you cannot change at runtime from MySQL console wit SET or SET… comma-separated flags. Currently “microtime†is mandatory meaning you cannot disable it. “innodb†is only available with the patch…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… little bit different story. With Oracle’s stock MySQL you cannot move your ibd files freely from one server to another…: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries IMPORT TABLESPACE; mysql> set FOREIGN_KEY_CHECKS=1; mysql> SELECT * FROM… stored in .ibd file. innodb_import_table_from_xtrabackup=1 should be enabled for such advanced import process to work. You can…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… memory available but since we run on 32 bit we cannot turn up the innodb_buffer_pool higher than 1.8G right? 2.4 kernel (cannot change to 2.6 because of internal politics). Tmp area… two guides but cannot really convert the gained knowledge to solve our situation. Lesser questions but probably as well important. b. The…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… checkpoint , I thought it might be useful to explain another important mechanism that affects both response time and throughput – The transaction… is action consistent and each operation is idempotent. It is important to note that physiological logging needs to operate on consistent… every update it can become an important overhead to your response time. Indeed if InnoDB cannot log at all, your transaction will…
