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
June 12, 2013 By 22 Comments
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…tables in this way, for example when using replication, a temporary table could vanish if the slave restarts and then subsequent queries… insert/update/delete operations…in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the first table in…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…, 2013. A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69… were not found in 32-bit builds due to a typo. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap file in the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…in reordering TCP packets can actually result in performance that’s worse than a single NIC.] The other two…queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows… two indexes with the same columns (in the same order) and the server will not complain. If we execute the same sentences in MySQL…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap file in the…_PAGES table couldn’t be queried if the log tracker wasn’t running. Bug fixed #1185304. Fixed the upstream bug #68970 that, in…. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online documentation. Bugs can be reported…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…customer and I am involved with servers located in two data centers, one with Solaris servers and the…excessive so a single server can easily handle the write load of all the MySQL instances. The original…to start the snapshot while holding a “flush tables with read lock” and the flush operation will…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as SELECT…) group by ld.label_id, cai.inventory_id All 4 tables in the query are locked!
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… blueprint in innobackupex). He also included this helpful script to generate all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… insert or updates into completely different table (unrelated to the select query) also get hang up. If I do show processlist, the update queries show up with state =’Updating‘ or…
