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: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
… performance at low concurrency. The SSB The SSB tests a database’s ability to optimize queries for a star schema. A star schema… operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
…: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements… is a waste of resources that could potentially impact our performance, and should be avoided. By the way, a good practice…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
…-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. … files. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
… instead of using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686. Under very…, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS…
Post: Percona Server for MySQL 5.5.31-30.3 now available
… with the fix for bug #710799. This regression caused mysql schema to be missing after the clean RPM installation. Bug fixed…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This…
Post: Webinar: MySQL 5.6 Performance Schema
… MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new… you can use the wealth of information Performance Schema gathers to understand some of the typical performance bottlenecks. Other areas of focus include…
Post: MySQL and Percona Server in LinkBench benchmark
….30 and MySQL 5.6.11 demonstrate notable drops in performance. What can be the reason for that? Below is a… MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance…-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks…
Post: More on MySQL transaction descriptors optimization
… variation, e.g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but…_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and indices…
Comment: Webinar: MySQL 5.6 Performance Schema
….com/sites/default/files/presentations/Webinar-Using-MySQL-5.6-Performance-Schema-To-Troubleshoot-Typical-Workload-Bottlenecks.pdf I’m Percona’s…

