… Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the… always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For…=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… also running our new Moving to MySQL 5.6 class. This class covers new features in MySQL 5.6, migration planning, and application verification… MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday, June 10, 2013 , 9am – 5pm Moving to MySQL 5…: Moving to MySQL 5.6 – Miami, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins Thursday, August 8, 2013…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team, will talk about MHA for MySQL High Availability… Memorial Student Union, located at 1825 SW Broadway, Suite 327/8/9 Portland, Oregon 97201. Afterward, we’ll have a networking…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql…_A to parent table: 8“?>
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
Since my first post on MySQL transaction descriptors optimization introduced in Percona Server 5.5.30-30.2 and a followup by Dimitri…’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between… –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available… leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would… #1164893 (Seppo Jaakola). Galera builds would fail when gcc 4.8 was used. Bug fixed #1164992 (Alex Yurchenko). Percona-XtraDB-Cluster…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… delivered in the form of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data…-check-mysql-replication-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp-check-mysql… Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network Traffic”. A new tarball is available from…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… the IO-bound scenario. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops in… MySQL 5.5.30 top mutex is &doublewrite->mutex: trx0sys.c:196. And most likely this symptom is related to BUG#67808. For MySQL 5…_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… support for MySQL 5.6 and Percona XtraDB Cluster We started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta. Now that MySQL 5.6 is GA, so… is at least confused with, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer… jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel replication…. In terms of benchmarks, Mark Callaghan published an example where 8 sysbench tables are used which means the lowest concurrency you…
