… of Percona Server 5.1.59-13.0 on October 15, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.59, including all the bug fixes in it, Percona Server 5.1.59-13.0 is now the current stable release in the 5.1 series. All of Percona…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… stable release of Percona XtraBackup. In this release we now compile the xtrabackup binary against more recent MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL 5.5.17, Percona Server 5.1.59-13.0 and Percona Server 5.5.16-22.0 and…
Comment: MariaDB 5.3.4 benchmarks
February 19, 2012 By 22 Comments
… 5.3.4 runs ontop XtraDB 1.0.17-13.0 which in turn is based on InnoDB 1.0.17 from MySQL 5.1. So indeed MySQL 5.1 or Percona Server 5.1.59-13.0 would be proper targets for a comparison with MariaDB 5…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…sent: 1 Rows_examined: 655360 use test; SET timestamp=1325145746; select count(*) from auto_inc; Compare that to Percona Server … SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 …32ms 43us 163us 103us 131us 19us 98us # Rows sent 59 62.41k 203 231 204.82 202.40 …
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… results of my testing of the new Group Commit in Percona Server 5.1. As background information, the problem appears when you have strict…-back cache online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied. The first… cache thread trx=1, No binlog trx=0, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 59.45 468.59 33.11…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…, ages ago before I even worked at Percona). It automatically detects and connects to every server in the replication hierarchy, and prints… version 1.0.16-12.8 +- 10.124.62.78 Version 5.1.57-rel12.8-log Server ID 6278 Uptime 12+03:53:59…].compute-1.amazonaws.com Version 5.1.43-60.hardy.7-log Server ID 207 Uptime 12+23:40:41 (started 2011-10-05T20:59…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… will be also available on percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we… of our binary builds with 5.1.36. On new server we run set global innodb_expand_import=1; to put XtraDB into extended… 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
…been focused on OLTP workloads. In fact, both Percona Server and MySQL 5.5.7rc have numerous performance improvements which benefit workloads…Query16 worker24 worker32 workerNo Shard-Query16 worker24 worker32 worker.1 year4.5481.0440.8540.8524.5484452247621.04397392272950.854340076446530….
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… mysql-data-201202230157 sb swi-a- 5.00g mysql-data 0.00 mysql-logs… #120223 1:59:55 server id 1 end_log_pos 336797275 Query thread_id=47 exec_time=1…/etc/init.d/mysql start Starting MySQL (Percona Server) [ OK ] You should shutdown MySQL first…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…expand_import=1 setting) 4) run alter table IMPORTEDTABLE discard tablespace; 5) copy .exp and .ibd files to destination server 6… 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 … Some more information available on http://www.percona.com/docs/wiki/percona-xtradb:patch:innodb_expand_import If you …
