… pt-table-checksum with Percona XtraDB Cluster. First, you’ll need Percona Toolkit v2.1.5 or newer and Percona XtraDB Cluster 5.5.27-23.6… ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE 10-05T14:47:52 0 1 10 1 0 0.023 test.t Success! The difference… differences. In summary: pt-table-checksum v2.1.5 and newer works with Percona XtraDB Cluster 5.5.27-23.6 and newer You must…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… Summary: 3747 out of 10000 rounds (37.47%) Delay distribution: Min: 0.86 ms; Max…: mysql> set global wsrep_causal_reads=1; Query OK, 0 rows affected (0.00…Percona XtraDB Cluster related configuration # PXC Settings for Version: ‘5.5.29-55-log’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Percona…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
….1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All versions are vanilla MySQL, not Percona… is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73 596… 64 4688.41 5078.02 4910.21 7535.65 7269.47 6994.04 Scripts and results are also on our Launchpad…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
….1 and XtraDB-6. Now I am going to show how to use it (the video will be also available on percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we… engine, you can take one of our binary builds with 5.1.36. On new server we run set global innodb_expand… 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… 0 12, fields 1/2, uniq 2, type 0 root page 47, appr.key vals 1, leaf pages 1, size pages 1 FIELDS: FOR_NAME… busier than expected during execution. He had data collected using Percona Tookit’s pt-stalk during the time and asked me… called twice for each table, at least in the latest Percona Server 5.1 in: storage/innodb_plugin/dict/dict0load.c: line 226…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… them (assuming its going to be dedicated to the database: 1) Update to the latest firmware (http://downloadcenter.intel.com/Detail…_per_table=1 I’m sure other people can chime in with some additional settings such as using the percona or ourdelta…% change db 34.73% SELECT 2.93% DELETE 1.47% INSERT 5.31% REPLACE 5.57% UPDATE All of this on a 43.4GB…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… 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 …
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
…://www.percona.com/docs/wiki/benchmark:ssb:start, and graph is below. There couple comments from me. InfoBright was fully 1 CPU….49 sec ) 19843.213 sec Q4.2 5 hours 38 min 7.60 sec / 5 hours 36 min 35.69 sec (20195… 58 min 4.27 sec (46684.27 sec) 33 min 47.32 sec (2027.32 sec) 7241.791 sec Graph with…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…: import: 3 indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14… 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57… done. Some more information available on http://www.percona.com/docs/wiki/percona-xtradb:patch:innodb_expand_import If you want some… get them from Launchpad projects https://launchpad.net/percona-xtradb and https://launchpad.net/percona-xtrabackup. Binary releases will be ready as…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…1/100 of the second. (This is pretty idle test system). So 347 and 5303 correspond to 3.47…Percona Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1… 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes …
