… really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute Units (8 virtual cores… to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that… = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
Percona is glad to announce the release of Percona Server 5.5.23-25.3 on May 16, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it, Percona Server… the details of the release can be found in the 5.5.23-25.3 milestone at Launchpad. Bugs Fixed: Percona Server…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 7 Comments
…. I am happy to announce next version Percona XtraDB Cluster 5.5.23, which comes with bug fixes and improvements. List of… tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http://www.percona.com…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
…; and it returned the following result xyz abc 1.52MB 4.00MB(free space) after this I executed alter table abc…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Any particular reason for choosing 4 1GB log files instead of 2 2GB?
Comment: Percona Server 5.5.23-25.3 released!
May 17, 2012 By 2 Comments
@ James Ubuntu Precise (12.04 LTS) will be officially supported with the next Percona Server releases. Percona Server 5.5.24-26.0 is currently scheduled for release in the first week of June.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… big, so Inno starts slowing down again. The factor of 4 speedup that occurs when you get rid of the secondary… cost, and the performance difference is basically that factor of 4. The variance is lower with only the primary key because… Memory sizes are perhaps 10 times bigger than they were 4 years ago when the iiBench project started, today the challenge…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 93 Comments
On my boxs with MySQL 5.5 (Ubuntu Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make an…
Comment: Testing Fusion-io ioDrive2 Duo
May 14, 2012 By 12 Comments
I actually requested pricing just last week, here are the numbers I received: 365GB MLC = $5,950 785GB MLC = $9,950 1.2TB MLC = $13,900 2.4TB Duo MLC = $28,500
