… and extended Innodb Plugin version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in a nonGA version… MySQL Alternatives including keynotes for Drizzle and MariaDB. MySQL 5.5 replaced MySQL 5.4 as next planned GA release. Percona releases GA version… source alternative to Innodb Hot backup. MySQL 5.1.46 is GA and MySQL 5.5.4 is not GA at the time of…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…-8577-11e2-a3d7-080027635ef5:1-5 Executed_Gtid_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-4 There are different ways to find… has retrieved transactions 1 to 5 but has only executed 1 to 4. That means that transaction 5 is the one that is…. STOP SLAVE; SET GTID_NEXT=”7d72f9b4-8577-11e2-a3d7-080027635ef5:5“; BEGIN; COMMIT; SET GTID_NEXT=”AUTOMATIC”; START SLAVE; [...] Retrieved_Gtid…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… KEY (hid,mid,id) ). Also please note the transaction produces 4 INSERTs and workload is very write intensive. So what are… are not quite stable, that is why I also show 5-minute moving averages to TokuDB. So TokuDB shows about 2…: [mysqld_safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-release modules I received… benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each…_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid = 101…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… with the memcached plugin… As part of the standard MySQL 5.6 GA distribution, there is a memcached plugin included in… both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are some details… test: Minimal hardware (vBox instances on MacBook Pro) Centos 6.4 Single core VM 528M RAM Host-Only network 1 Box…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… to achieve better consistency, if you have an async master <= 5.0 though, you can workaround this by turning off wsrep… the previous bug has been fixed on latest release (5.5.30-23.7.4), table without PK imposes an additional overhead, and…
Comment: Percona Server for MySQL 5.5.30-30.2 now available
April 15, 2013 By 10 Comments
Great release. Unfortunately latest version in RHEL6 repo is 5.5.29.rel29.4.401.rhel6. I believe it’s the same problem as for Percona Fan.
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… 27143 27637 8 7 80 5 0 Fri Mar 22 10:03:28 UTC 2013 1 4 291992 219104 138832 7262820 0 0 174854 160 18893 17002 6 5 83 6 0 Fri… 324640 138836 7153440 0 0 143736 132 19318 17425 7 5 76 12 0 Fri Mar 22 10:03:32 UTC… 138480 1206 19126 16359 3 5 81 12 0 Fri Mar 22 10:03:34 UTC 2013 4 0 291984 216932 138832…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…-4“; slave1 > CHANGE MASTER TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5…_Running: Yes [...] Retrieved_Gtid_Set: c777888a-b6df-11e2-a604-080027635ef5:5 Executed_Gtid_Set: c777888a-b6df-11e2-a604-080027635ef5:1… slave has retrieved a new transaction with number 5, so transactions from 1 to 5 are already on this slave. That’s…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…| CLUSTER_NAME | SPACE | +————–+—–+——–+——+——–+———+————–+——-+ | sakila/actor | 741 | 4 | 1 | 0 | 0 | | 738 | +————–+—–+——–+——+——–+———+————–+——-+…’ (`INDEX_ID`, `POS`, `COL_NAME`); 5. Now everything is ready…
