… other magic that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls when flow… permission to continue replication. This setting traditionally defaulted to 0.5, meaning the queue had to fall below 50% of the…myclu P 3 3 node3 Sync T/T 0 4 0 3 0 4.3K 0.0 0 109 0 0 09…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… to achieve better consistency, if you have an async master <= 5.0 though, you can workaround this by turning off wsrep… on latest release (5.5.30-23.7.4), table without PK imposes an additional overhead, and because cluster performance is somewhat dependent on…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
MySQL 5.4 comes with Innodb engine which seems to have much better performance than MySQL 5.0 – this is due to locking and… get MySQL 5.4 release with yet another set of Innodb changes. Why not to include plugin in MySQL 5.4 with relevant performance changes… in MySQL 5.4 will this ever going to happen ? Looking at initial benchmarks I’m very impressed with Sun Performance Team work…
Post: MySQL 5.5.4 in tpcc-like workload
April 21, 2010 By 25 Comments
MySQL-5.5.4 ® is the great release with performance improvements, let’s see how it performs in tpcc-like workload. The full details are… our server: As you see our adaptive_checkpoint algorithm is performing much stable. And to put direct comparison, there is side… keep performance even, as in previous release, there was about 1.7x times difference. I expect to see more improvements in 5.5…
Post: 5.4 in-memory tpcc-like load
May 1, 2009 By 11 Comments
… I would say XtraDB performs almost the same as 5.4, but dips are a bit worse than in 5.4. Now about dips – all… can see results for 5.4 with innodb_max_dirty_pages_pct=15. There really no dips, but average performance is not acceptable. I also tried innodb_max_dirty_pages_pct=30, but results in this case similar to usual 5.4…
Post: Looking on 5.4 - IO bound benchmarks
April 30, 2009 By 5 Comments
With a lot of talks around 5.4 I decided to check how it works in our benchmarks. … cores, 32GB of RAM, RAID 10 on 8 SAS 2.5” 15K RPM disks). For comparison I took XtraDB-release5 and… with 5.4 and it shows the best results. Some more results you can find on Dimitri’s blog, one of Sun Performance…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… sda3 25.5 1.2 0.7 4.5 0.1 0.4 46% 0 84042.8 sda3 24.4 0.7 0.5 4.7 0… output of iostat.) I would characterize this as very good performance. Sub-millisecond latencies to disk, pretty much consistently, for reads… 1.4 MB/s, and we’re being stalled for a quarter of a second sometimes. This is causing acute performance problems…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… goal was to see how MySQL 5.6 performs out-of-the-box as compared to 5.5.30 with default settings. The non… the MySQL 5.6 server, rebooted and verified again. Same issue. This was very different from MySQL 5.5.30, which performs significantly better… type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: ssb.lineorder.LO_OrderDateKey rows: 1 Extra: Using where…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… serious performance regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you… 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0 can offer substantial performance…
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
… time we played with performance trying to align XtraDB performance with MySQL 5.4 ® and also port all performance fixes to 5.0 tree. So basically… see that XtraDB, 5.0.83-percona and 5.4 are almost equal, with difference we have get some extra performance turning InnoDB readahead…:start) And now 5.0-tree will contain all performance fixes and show the same results as 5.4 Both 5.0.83-percona and…
