…fixed #1181887. Changed page tracking used to hold the log system mutex for the log reads needlessly,… error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete … fixed #1177780, bug fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… one query in this flight, Q4.3, which is faster using MyISAM than InnoDB. Like the queries in Flight #3 that are faster using… better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests, a 64GB buffer pool was used. O…
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
… Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…=1; s0> start slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of… give it a try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then… from the MySQL Utilities (this will be the topic of a future post). Unfortunately, this will not work for every use case, and…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… encourages people to use Pacemaker in … [ OK ] Starting cman… [ OK ] Waiting for quorum… [ OK ] Starting fenced… [ OK ...MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision … well-known MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… had more than enough for our purpose and some ZFS features are just too useful for backups (most apply also for btrfs). Let’s… put together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
… very natural place for our next Percona MySQL University event scheduled for June 17. We run this event in partnership with MySQL Meetup at…. Percona MySQL University is a daylong, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers…
Comment: Impact of logging on MySQL’s performance
June 11, 2013 By 8 Comments
Slow Query should be run on as-needed basis, and re-actively … slow query turned on, especially for very large (but not necessarily slow) queries. It’s a good tool but it should only be used…
