… Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team… Memorial Student Union, located at 1825 SW Broadway, Suite 327/8/9 Portland, Oregon 97201. Afterward, we’ll have a networking…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only… better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the…=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
May 28, 2013 By 3 Comments
I backed port percona’s perf tuning for read_view to AliMySQL-5.5, with 1K connections case, RO 13187 -> 40797, RW QPS 2W -> 3W TPS 5K-> 8.5K Amazing ~
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… Monday, June 17, 2013 , 9am – 5pm Eastern Moving to MySQL 5.6 – Manchester, UK Begins Monday, June 17, 2013 , 9am – 5pm… Begins Monday, July 22, 2013 , 9am – 5pm Moving to MySQL 5.6 – Belfast, IE Begins Thursday, August 1, 2013 , 9am – 5pm…, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins Thursday, August 8, 2013 , 9am – 5pm San…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… called SchemaSpy. SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in… is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver…_A to parent table: 8“?>
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… post on MySQL transaction descriptors optimization introduced in Percona Server 5.5.30-30.2 and a followup by Dimitri Kravchuk, we… 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: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… to run this benchmark for MySQL Server 5.5.30, 5.6.11 and Percona Server 5.5.30 and check how these servers will…-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…=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
… started beta support for Percona XtraDB Cluster in 2.1.8, but now that support is official in 2.2 because… at least confused with, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set…. Now that we have four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… #1164893 (Seppo Jaakola). Galera builds would fail when gcc 4.8 was used. Bug fixed #1164992 (Alex Yurchenko). Percona-XtraDB-Cluster… in it and on Codership wsrep API 5.5.30-23.7.4, Percona XtraDB Cluster 5.5.30-23.7.4 is now… open-source and free. Release notes for Percona XtraDB Cluster 5.5.30-23.7.4 are available in our online documentation…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… equated to serving >1B ad impressions per day on a 8-core DL380 with 32GB RAM. Back in 2006 I recall…’s common to see much higher numbers from NDB and 5.5.x clusters with not just simple queries or simple transactions… and stability than life back in the days of MySQL 5.0.x. On that end, I’m in the process…
