… MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB…/wiki/benchmark:fusionio:mysql:start, here are my thoughts and interesting facts. First, chart with results for InnoDB vs InnoDB-plugin during… on FusionIO) To summarize MySQL InnoDB/InnoDB-plugin/XtraDB is not fully able to utilize throughput of FusionIO. XtraDB is doing better job…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… point is that you can convert your existing MySQL / Percona Server into Node and roll Cluster using…when you run write traffic to 2 nodes vs all traffic to 1 node, but you …available in Percona XtraDB Cluster: mysqldump, rsync and xtrabackup ( Percona XtraBackup with support of XtraDB Cluster will be…
Comment: Announcement of Percona XtraDB Cluster (alpha release)
January 12, 2012 By 30 Comments
Pretty good discussion here on NDB vs XtraDB clusters. One point that didn’t come up is that … operations N is 1 or 2 ms. For InnoDB (ie XtraDB Cluster) you will not see as stable performance as this… you will need application changes if migrating from a standard MySQL server to an NDB Cluster. This is all true. Otoh…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… sec, to exclude warmup period, the average will be different: MySQL: 3746 tps Percona Server: 3704 tps And for comparison, average throughput for 4 tables: MySQL: 3882 tps Percona Server: 6735 tps The Percona Server is…, you can see that with a proper tuning, Percona Server/XtraDB outperforms MySQL, and provides a more stable throughput. Of course if…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… based hash was almost 2x faster then combining memcached and MySQL, and about 20% slower then the all memory memcached approach… does performance differ or change? One knock on Tokyo -vs- Memcached is Tokyo is not distributed by default. Now… was started with 16 threads ( 1.4 memcached ), mysql was 5.1 XtraDB. Each environment had 2 tables each with 2…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… for TPCC load, so why don’t we take tpcc-mysql bencmark and check on results. I took 3 different datasets… row level having small dataset. I used as usually tpcc-mysql benchmark with 16 and 32 (for 10w) concurrent users. Also… based replication in 5.1), and everything was run under XtraDB-9 ( based on InnoDB-plugin 1.0.6) So there…
Comment: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
February 3, 2013 By 8 Comments
… vs depsolve: mysql conflicts with Percona-XtraDB-Cluster-client-5.5.29-23.7.1.387.rhel5.x86_64 mysql-devel conflicts with Percona-XtraDB-Cluster-devel-5.5.29-23.7.1.387.rhel5.x86_64 mysql-libs conflicts with Percona-XtraDB-Cluster-shared-5.5.29-23.7.1.387.rhel5.x86_64 mysql-server conflicts with Percona-XtraDB…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… issues we should look for? A: Percona XtraDB Cluster is a synchronous replication technology, therefore … successive queries. Q: Is RBR faster replicating vs SBR replication? RBR is faster than statement based,… the official manual page for MySQL Proxy 0.8.2 still says: “MySQL Proxy is currently an …
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
… | 5903053 | +—————————+ 1 row in set (2 min 8.92 sec) mysql> SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | Value | …really control it (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so be…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
…), and compared 1 and 16 users in MySQL-5.1.46/PBXT and Percona Server / XtraDB – 5.1.45-rel10.2. As… the maximal throughput in PBXT is about 1.5x better XtraDB, but there periodical drops which are very similar to periodical… results are also better for PBXT: 5785.567 TpmC vs 4905.967 TpmC ( XtraDB) For 16 threads final result is: 26129.350…
