…0.000000 Rows_sent: 1 Rows_examined: 655360 use test; SET timestamp=1325145746; select count(*) from auto_inc; Compare that to Percona Server…16 0xBE797E1DD5E4222F 0.0524 0.6% 79 0.0007 1.00 0.00 SELECT wp_posts # 17 0xF8EC4434E0061E89 0.0475 0.6% 62 0.0008 1.00 0…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… Percona Software Repositories). Based on MySQL 5.5.16, including all the bug fixes in it, Percona Server 5.5.16-22.0 is now the current stable release in the 5.5 series. All of Percona‘s…
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 …files should be copied to remote server. Now on remote server you have to run MySQL server ® with XtraDB6 storage engine, you …2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 …
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…: #111213 23:16:21 server id 1 end_log_pos 269 Query thread_id=3 exec_time=0 error_code=0 use test/*!*/; SET… bug related with this described on https://bugs.launchpad.net/percona-server/+bug/860910. In a master-master setup a master can… it to perform writes. The issue is fixed only in Percona server 5.5.17-22.1. AUTO INCREMENTAL VALUES In order to have the…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… 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 get all the InnoDB bug fixes each of these releases contain. Using xtrabackup to back up older MySQL or Percona Server…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… ago before I even worked at Percona). It automatically detects and connects to every server in the replication hierarchy, and…Version 5.1.57-rel12.8-log Server ID 6275 Uptime 10+01:18:10 (started 2011-10-08T19:22:04…InnoDB version 1.0.16-12.8 +- 10.124.62.76 Version 5.1.57-rel12.8-log Server ID 6276 …
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…cache online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix… last test was done with a disabled sync_binlog=0 and without write-back cache: Threads Nofix Group …97 8 170.42 170.58 16 332.21 331.26 32 630.22 654.35 64 1122.06 1116…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…Percona offerings. If Server…0.52802563348716 | | 13 | 2313 | 3.1297905412629 | 0.47887915792732 | | 14 | 4155 | 2.9788750504185 | 0.53700871350403 | | 15 | 4081 | 4.4940078389087 | 0.67605124513469 | | 16 | 3720 | 3.1698921914062 | 0…
