… here and from the Percona Software Repositories). Based on MySQL 5.5.14, including all the bug fixes in it, Percona Server 5.5.14-20.5 is now the current stable release in the 5.5 series. All of Percona…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…plethora of useful information reported by Percona Server. Another great thing about Percona Server is the ability to enable logging…wp_term_taxonomy wp_term_relationships # 5 0xA3EEB63EFBA42E9B 0.1999 2.5% 51 0.0039 1.00 …1.00 0.00 TRUNCATE TABLE poller_time # 14 0x3E84BF7C0C2A3005 0.0624 0.8% 272 0….
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
Percona is glad to announce the release of Percona Server 5.5.16-22.0 on October 14, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.16…
Comment: Percona Server 5.5.14-20.5
August 23, 2011 By 4 Comments
Any news on when Percona Server 5.5.14-20.5 will be available in the Maverick APT Repository?
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… Percona Server and MariaDB. This is the probably the easiest and most accurate approach but it does not work in Oracle MySQL Server…-19 14:35:53 to 2010-07-19 15:12:22 # bytes 350.99M 5 1022.34k 301.01 719.66 5.75k… replication capacity of 6. The challenge of course having spare server around and it is quite labor intensive. At the same…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…_64 ICE 3.5.2pl1. Requires m1.large or larger ami-8eb648e7 shard-query-innodb-demo-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1.large or larger. ami-f65ea19f shard-query-infobright-demo i686 ICE 3.5.2pl1… 34.354,60.978,114.175,27.138,45.751,14.905,14.732,34.946,126.599,250.222,529.287…
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 …files should be copied to remote server. Now on remote server you have to run MySQL server ® with XtraDB6 storage engine, you … Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 …
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… I diagnosed it on one customer’s server. The server is running a Percona build of 5.0.84, so I have microsecond logging…_read: 0 # administrator command: Quit; # User@Host: webuser[webuser] @ [10.14.82.196] # Thread_id: 3329398985 Schema: app_db # Query_time… disabling or reconfiguring some part of the server. Interestingly, the above is happening on a server that’s really NOT running that…
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
…you can see them in information_scheme database in Percona Server though). The structure of these tables is following: …_SPACE_OR_CHKSUM 4 /* in < MySQL-4.0.14 space id the page belongs to (== 0) but … has valid checksums: #./innochecksum /var/lib/mysql/ibdata1 # 5. Now you can start MySQL and take a …
Comment: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… may try galera replication http://www.mysqlperformanceblog.com/2011/07/14/percona-server-5-1-with-galera-replication/
