… Percona Software Repositories). Based on MySQL 5.1.67, including all the bug fixes in it, Percona Server 5.1.67-14.3 is now the current stable release in the 5.1 series. All of Percona‘s…
Post: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… | grep ^Percona Percona-Server-client-51-5.1.67-rel14.3.507.rhel6.x86_64 Percona-Server-shared-51-5.1.67-rel14.3.507.rhel6.x86_64 Percona-Server-server-51-5.1.67-rel14.3…. PS 5.5 without conflict. The current package candidates for versions 5.0.92 (which required an update), 5.1.67-14.3 and 5.5….
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…Percona Server with log_slow_verbosity=full: # Time: 111229 3:11:26 # User@Host: msandbox[msandbox] @ localhost [] # Thread_id: 1… # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT …_time # 14 0x3E84BF7C0C2A3005 0.0624 0.8% 272 0.0002 1.00 …3.99 202.40 # Rows examine 13 73.63k 238 296 241.67…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…also available on percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, …binary builds with 5.1.36. On new server we run set global innodb_expand_import=1; to put XtraDB… InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 …59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…re running Percona Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1 …sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes 0 0…14 783 158.14 621.67 149.04 107.34 # InnoDB: # IO r bytes 14.81G 0 1.10G…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…the ways to measure it: 1) Use “UserStats” functionality from Google patches, which is now available in Percona Server and MariaDB. This …0 1.04 0 # Rows exam 30.88M 0 1.28M 26.48 0 3.07k 0 # Time range 2010-07-19 14:…350.99M 5 1022.34k 301.01 719.66 5.75k 124.25 # Bytes sen 1.94M 0 9.42k 1.67 0 110….
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…1 setting) 4) run alter table IMPORTEDTABLE discard tablespace; 5) copy .exp and .ibd files to destination server…3 indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14…62 63 64 65 66 67 68 69 70 71 72… on http://www.percona.com/docs/wiki/percona-xtradb:patch:innodb_expand…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…the load on the database server and [as a result] …all the eXtra benefits from Percona slow query log patch), …1.0], V/M = 19.02 # Query_time sparkline: | ^______| # Time range: 2011-04-05 16:12:13 to 16:14…# Rows examine 1 4.97M 0 445.49k 9.80k 5.73k …0 # pages distin 1 67.99k 0 10.64k 1.26k 3.88k 2….
