…: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 2h for…. I think Intel SSD 910 is suitable to use with MySQL / Percona Server, especially if you are looking for quick performance boost in…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
…Percona Server for MySQL version 5.1.68-14.5[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.1.68 -14.5… their MySQL database server. Compare Percona Server to MySQL. Performance Percona Server‘s performance is exceptional. Not only is it faster, but in benchmarking, …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…5.5.24-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona…benchmark. # sysbench –test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…. At Percona we surely will be doing fine tuning for our Percona Server for MySQL version 5.6 release. Another thing to remember about MySQL 5.6… noticed in most production cases. For benchmark with 64 threads MySQL 5.5 is 26% faster compared to MySQL 5.6 and if you disable Performance…
Post: Percona Server scalability on multi-cores server
September 29, 2010 By 14 Comments
…”. So, I took Percona Server 5.1.47-11.2 and ran the sysbench oltp read-only and read-write benchmarks using from 1 to 32 threads. The database size was 100 million rows ( about 23GB of data). (Starting with Percona Server 5… will be interesting to compare these results with the latest MySQL 5.5 releases, and especially in cases with the number of threads…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
…12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: … use with MySQL / Percona Server. Link to raw results and stats Raw results, config, OS and MySQL metrics are available from Benchmarks …
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…server from generic application. Right. Default configuration for Percona…Percona XtraDB Cluster related configuration # PXC Settings for Version: ‘5.5.29-55-log’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Percona…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the… that I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log… about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…, Peter and Ovais are doing a lot of benchmarking of specific MariaDB 5.3 and MySQL 5.6 optimizer improvements, and both of them… MySQL versus MariaDB wiki page. Note that a lot of these features are also available either in Percona Server or in the upcoming MySQL 5… subtlety to this list. For example, Percona Server has the same group commit fix, and MySQL 5.6 offers microsecond timestamp support, as well…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…: XFS, mkfs.xfs -s size=4096, mount -o nobarrier Benchmark: For the benchmark I took a sysbench uniform oltp rw workload. 256… backend database I use Percona Server 5.5.19. I should mention that on these datasizes, sysbench workload is pretty nasty, MySQL will mostly reads…
