June 19, 2013

Comment: Performance Schema overhead

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.

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…