… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
….m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In… that have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use the… temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement transactions (TPS… perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition… box and varied cpu combinations with taskset. The following chart shows a results comparison on a single-node (on the left…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… result sets or objects. Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc) Full… pages) Full objects (user or cart object built from several queries) Infrequently changing data (configurations, etc) In pseudo-code, here is… (~.06 ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
… queries with which developers struggle. I’ll test several SQL solutions for each type of query objective, and show how you can use MySQL 5.6 built-in methods to analyze them for optimal query efficiency. The discussion will cover optimizer reports, query profiling…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows much better…=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose…
Comment: Fun with the MySQL pager command
May 1, 2013 By 6 Comments
The show processlist trick is not quite right: it is also counting the header lines. I modified it as follows: mysql> pager… ‘|’ ‘{print $6}’ | sort | uniq -c | sort -r’ mysql> show processlist; 5 Sleep 2 Connect 1 Query 8 rows in set (0.00 sec…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… that offers the best response times (MySQL server does not use multiple threads to execute query in parallel at this point). Response… jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel… high concurrency you might not understand why the system is showing worse response times when you are actually running it in…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… Percona XtraBackup enables backups without blocking user queries, making it ideal for companies with large… Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client….Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and…
