Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering
Thanks for sharing.
Comment: Performance Schema overhead
Post: Migrating between MySQL schemas with Percona Xtrabackup
… disclosure, here are the versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6…
Comment: MySQL and Percona Server in LinkBench benchmark
… than 50GB BP even I used O_DIRECT when I tested) might not be from PCI-e flash card (cached etc…. I think LinkBench should have less dependency for GC to test on fast storage, reusing objects/sessions/stmt more or something…
Comment: ZFS on Linux and MySQL
… do the same for xfs… I am redoing my tpcc test with primarycache=metadata, if giving more arc to metadata make…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
… start to degrade. If you’re just setting up a test environment to get familiar with the technology, certainly there’s…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
… on an interface every second. I’m running a sysbench test on one node and measuring the outbound (UP) bandwidth on… TCP *:3306 (LISTEN) Now, let’s re-do our above test: # 2 nodes in the cluster eth1 DOWN:15 KB/s…
Comment: MySQL 5.6.7-RC in tpcc-mysql benchmark
Hy, I’m new to TPC-C benchmarking and i would like to know how and what are the steps for testing MySQL with TPC-C benchmark. My goal is to compare VoltDB and MySQL under TPC-C benchmark. Thanks
Post: MySQL Query Patterns, Optimized - Webinar questions followup
…’s a finite amount of engineer-years spent developing and testing the query optimizer. The developers have to make a decision… unexpected differences in performance like this, so it pays to test all different solutions, and measure the resulting performance! Q: Bill…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
…=user:pass@localhost test.test # Source on localhost: … connected. $ pt-duplicate-key-checker –tables test.test # ######################################################################## # test.test # ######################################################################## # Key redundant ends…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
… #2 on the picture below, following various scenarios: For these tests, all servers are running on 127.0.0.1 with…

