… Large Instance 68.4 GB of memory 26 EC2 Compute Units (8 virtual cores with…Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the … innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush…
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
…. Here are links to the source releases: mysql-5.0.62-percona.tar.bz2 md5:0d8a37e09eca93cde6170866293a82ff mysql-5.1.26-percona.tar.bz2 md5:0574b38755786a97bc476058051cbe82 You can find the individual patches here: http://www.mysqlperformanceblog.com/mysql-patches/ Besides standard 5.1, we…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…Percona Server. Another great thing about Percona Server is the ability to enable logging atomically, not just for new connections as in MySQL…options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film… part of the output: # Query 1: 0.26 QPS, 0.00x concurrency, ID 0x92F3B1B361FB0E5B at…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… results of my testing of the new Group Commit in Percona Server 5.1. As background information, the problem appears when you have… cache online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied. The….12 2288.33 16 3098.33 3409.97 32 3180.26 3662.40 64 3074.08 3860.01 128 2765.78…
Post: New patches, new builds
September 5, 2008 By 24 Comments
… 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes we separated releases of 5.0 into two branches. First, just “-percona… it and run mysql with option –skip-innodb. We think InnoDB plugin is stable enough to use it with MySQL 5.1 RC, at least stable to name whole MySQL-5.1-percona release as RC. Along with previously mentioned patches, to 5.1 we added…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is …to handle the write workload. Since we’re running Percona‘s patched server, we can actually measure what’…site.user_achievements 1.36 1.20 0.35 site.clicks 1.26 3.05 5.13 site.actions_finished 1.14 0….
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…-tool# ./create_defs.pl –host 127.0.0.1 –port 5520 –user root –password msandbox –db … link: http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:generating_a_…~/recovery-tool# ./constraints_parser -5 -D -f pages-1329221407/FIL_PAGE_INDEX/0-26/ > data/salaries.recovery …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…5.2pl1. Requires m1.large or larger ami-8eb648e7 shard-query-innodb-demo-64bit x86_64 Percona Server 5.5… 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row … NULL Create_time: 2011-05-10 04:26:14 Update_time: NULL Check_time: …
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… video will be also available on percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we… of our binary builds with 5.1.36. On new server we run set global innodb_expand_import=1; to put XtraDB into… 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26…
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… that the application is always only sending query 1 to MySQL it’s actually a pretty good index!…South America’) NOT NULL DEFAULT ‘Asia’, `Region` char(26) NOT NULL DEFAULT ”, `SurfaceArea` float(10,2) NOT… there, there’s a helpful patch in 5.0-percona called INDEX_STATISTICS that can then show you…
