Percona Server version 5.1.56-12.7 is now available for download. It is based on MySQL 5.1.56 and is the current stable release in the 5.1… feature, importing .ibd files created on MySQL 5.0 or Percona Server versions prior to 5.1.7 could crash the server. (Yasufumi Kinoshita) Bug… see the following links: Downloads – binary distributions and Percona Software Repositories Installation instructions Consulting, support, training, and custom development…
Post: Percona Server and XtraBackup for MacOS – experimental binaries
May 2, 2011 By 9 Comments
…/Percona-Server-5.5.11-20.2/release-5.5.11-20.2/114/MacOSX/ Percona Server 5.1: http://www.percona.com/downloads/TESTING/Percona-Server-51/Percona-Server-5.1.56-12.7/release-5.1.56-12.7/226/MacOSX/ Percona XtraBackup: http://www.percona…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only … in memory in this test. I have compared Percona Server 5.1.56-12.7 and Percona Server 5.5.11-20.2 with former being configured with innodb… at 1 thread to the peak performance we see the number is 2.3 for Percona Server 5.1 and around 6 for Percona Server 5.5…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…also inefficient. Percona Server as of versions 5.1.56 and 5.5.11 allows …in total which is about 1.7 times faster than updating … optimize | status | OK | +——–+———-+———-+——————————————————————-+ 2 rows in set (1 min 12.19 sec) mysql> SHOW…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…1 Rows_examined: 655360 use test; SET timestamp=1325145746; select count(*) from auto_inc; Compare that to Percona…56 0 # Rows affecte 1.34k 0 65 0.07 0 1.35 0 # Rows read 105.76k 0 1000 5….36k 81.56k 83.83k 7.31k 79.83k # Merge passes… 1 1 1 1 0 1 # Tmp disk tbl 30 149 1 1 1 1 0 1 # Tmp tbl size 16 12…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 46 Comments
…percona.com/docs/wiki/benchmark:ssb:start, and graph is below. There couple comments from me. InfoBright was fully 1…) 19 min 49.56 sec (1189.56 sec) 9399.965 sec Q2.3 1 hour 8 …19843.213 sec Q4.2 5 hours 38 min 7.60 sec / 5 hours 36 min 35.69….45 sec) 15292.648 sec Q4.3 12 hours 58 min 4.27 sec (46684…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 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… indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
…. In fact, both Percona Server and MySQL 5.5.7rc have numerous performance … Shard-Query16 worker24 worker32 worker.1 year4.5481.0440.8540.8524…..1344.4002327919017.59638905525213.13861489295963.1295669078827.12 year48.7268.1843.4863.46448….. On the other hand, MySQL 5.5.7 does not do this on its…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… 0.7 and state we can safely run 0.7*16 ~= 12 queries per…Percona Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1… 28us 35us # Rows sent 7.15M 0 56.36k 4.19 0….77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…it: 1) Use “UserStats” functionality from Google patches, which is now available in Percona… 15:12:24 2010 # Files: slow-log # Overall: 1.22M total, 1.27k unique, 558.56… table 8.30G 0 2.01M 7.12k 0 117.75k 0 # 0% (5k) … I would measure replication capacity on 5 minute intervals (or something similar) …
