… points given the conditions. Percona XtraBackup for MySQL for binary backups. Strong Points: It can restore an entire server very fast. Often the… as painless as possible. Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we upload mydumper backups to s3…
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… cache online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix… 2145.32 2188.38 There is still performance difference binlogs vs no-binlogs, but it is much smaller when you have…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… 10.04.2 LTS (lucid) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ################################################## Processors | physical… was running on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run… slightly lower, the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important metric for…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
…: Test Intel SSD 910 under tpcc-mysql workload and compare with HDD RAID10 Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel… OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB…. I think Intel SSD 910 is suitable to use with MySQL / Percona Server, especially if you are looking for quick performance boost in…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5… It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does…. This is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
…Of course, I wanted to know more about how MySQL executes this query. So I used commands you… change in data access pattern (reads on disk vs reads in memory, execution plan instability) or contention… output of SHOW PROFILE? This is specific to Percona Server 5.5 and used only for debugging purposes …
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…the total response time of the server: that’s typical of a …recommendation on when to use ENUM vs. CHAR? Especially for one character values… recommendations true of all versions of MySQL? If not which versions? The …Is any logical backup facility provided by Percona like mysqldump? No, on the backup…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… 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 Server. The results are there: There is nothing unexpected, staring with InnoDB-plugin, MySQL…. Profiling MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… percentage of time the replication thread was busy replicating events vs staying idle. Note you can speak about idle replication capacity… in Percona Server and MariaDB. This is the probably the easiest and most accurate approach but it does not work in Oracle MySQL Server. set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… RBR faster replicating vs SBR replication? RBR …MySQL servers? Or is it possible to split only read queries (select etc.)? A: You can set up a pair of MySQL…Percona and the MySQL community in Santa Clara, April 22-25 2013 for the Percona Live MySQL Conference & Expo. Watch more webinars from Percona…
