…and that change makes 5.1 competitive with 5.6 (http://mysqlha.blogspot.com/2013/02/mysql-56-is-much…them will be fixed in 5.6.12. They should make a difference. I think Oracle might be…between us and them. http://bugs.mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…and that change makes 5.1 competitive with 5.6 (http://mysqlha.blogspot.com/2013/02/mysql-56-is-much…them will be fixed in 5.6.12. They should make a difference. I think Oracle might be…between us and them. http://bugs.mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… and focused only on case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT… Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between results we have rerun tests…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… trip time (RTT) between any two nodes in…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…achievements SET count = count + 1 where achievement = ‘killed_troll…usually get less than 5 people who do out …and Galera is no different in that there are…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads … the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking …backup process. Bug fixed #1130145. Due to different implementation in MySQL 5.6 error messages were not printed …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…1 only retries certain operations, pt-osc 2.2 retries every critical operation, and its tries and wait time between…confused with, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is… treated their run-related options a little differently. This magic is gone now: both …
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…comment on each field you reduce the number of different ENUM elements you can have, you are correct. …-1)-3*2=1017 which is exactly the same as what I can create. That’s right folks, in MySQL 5…maximum number of columns for a table in MySQL is somewhere between 191 and 2829, depending on a number of…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test was allowed…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters… couple of different dirty-page ratios on device performance, since this is the only parameter which can be reliably varied between the…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… recovery. Even an unnoticeable difference like NULL or NOT … Here InnoDB keeps correspondence between human readable table names and…mysql/ibdata1 3. Recover SYS_TABLES, SYS_INDEXES, SYS_COLUMNS and SYS_FIELDS from indexes 0-1…FIELDS\t’ (`INDEX_ID`, `POS`, `COL_NAME`); 5. Now everything is ready …
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…is being fixed in 5.6; not sure about Percona … any ‘free’ variant of MySQL. PARTITIONs are scanned one …, UPDATE) are similar in speed between PARTITIONed or non-PARTITIONed….1) find partition (if partitioned), (2) drill down the BTree, (3) remove one record. PARTITIONing makes very little difference…
