by Roman Vynar | Dec 30, 2013 | MySQL, Percona Events
Percona announces the release of Percona Monitoring Plugins 1.1.1 to address the critical bug that appears after the 1.1 upgrade. Changelog: * Cacti mysql graphs stop working with data input field “server-id” after 1.1 upgrade (bug 1264814) * Non-integer poller errors...
by Muhammad Irfan | Dec 30, 2013 | Insight for DBAs, MySQL, Percona Services
Recently, one of our support customers faced this: “[ERROR] mysqld: Sort aborted: Server shutdown in progress.” At first it would appear this occurred because of a mysql restart (i.e. the MySQL server restarted and the query got killed during the stopping...
by Peter Zaitsev | Dec 26, 2013 | Insight for DBAs, Insight for Developers, MySQL
Your MySQL server is overloaded. You see hundreds of running queries in the SHOW PROCESSLIST taking many seconds to run, or can’t connect at all because all connections slots are busy. If you have worked with MySQL long enough you surely have seen it, probably...
by Akshay Suryawanshi | Dec 24, 2013 | Insight for DBAs, MySQL
One of the routine tasks for a DBA is MySQL renaming database schemas, and as such MySQL added a command to carry out that purpose called “RENAME DATABASE <database_name>”. However, this command just made it through a few minor releases before being...
by Peter Zaitsev | Dec 23, 2013 | MySQL
It is wonderful to see some of my original pet peeves fixed in MySQL 5.7.3! It has not even taken 10 years 🙂 I remember when starting my work at MySQL Support that I would recommend using UNION ALL instead of plain UNION because it would not require duplicate...
by Hrvoje Matijakovic | Dec 20, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.35-33.0 on December 20th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.35, including all the bug fixes in it, Percona Server 5.5.35-33.0 is now the...
by Hrvoje Matijakovic | Dec 20, 2013 | Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.1.73-14.11 on December 20th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.73, including all the bug fixes in it, Percona Server 5.1.73-14.11 is now the...
by Hrvoje Matijakovic | Dec 20, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.2.6 on December 20th, 2013 (Downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series. This release has...
by Hrvoje Matijakovic | Dec 19, 2013 | Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.15-63.0 on December 19th, 2013 (Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.15, including all the bug fixes in it, Percona Server 5.6.15-63.0 is the current...
by Jay Janssen | Dec 19, 2013 | MySQL
A decade ago MySQL folks were in love with the concept of a relay slave for MySQL high availability across data centers. A relay is a single slave in a remote data center that receives replication from the global master and, in turn, replicates to all the other local...
by Roman Vynar | Dec 18, 2013 | MySQL, Percona Events
Percona is glad to announce the release of Percona Monitoring Plugins 1.1. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios, Cacti and Zabbix, and are delivered in the form of templates, plugins, and scripts. In this...
by Hrvoje Matijakovic | Dec 18, 2013 | MySQL
Percona is glad to announce the first RC release of Percona XtraDB Cluster 5.6 on December 18th, 2013. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.15-63.0 including all the bug fixes in it, Galera...
by Michael Coburn | Dec 13, 2013 | Insight for DBAs, MySQL, Percona Services
Recently I was working with a customer where we noticed that Seconds_Behind_Master fluctuating from an expected value of 0 seconds behind to a fairly high six figure value. The servers were configured in a master-master relationship and used 5 figure server_id...
by Jervin Real | Dec 12, 2013 | Insight for DBAs, MySQL, Percona Services
While troubleshooting deadlocks for a customer, I came around an interesting situation involving InnoDB gap locks. For a non-INSERT write operation where the WHERE clause does not match any row, I expected there should’ve been no locks to be held by the...
by Tom Diederich | Dec 11, 2013 | MySQL, Percona Live
MySQL gurus from Oracle, Facebook, Google, LinkedIn, Twitter, Yelp (and more) have submitted papers and will speak at the third annual Percona Live MySQL Conference and Expo 2014 in sunny Santa Clara, California this coming April 1-4. If you attended last April’s...
by Dave Rosenlund | Dec 10, 2013 | MySQL
Use your MySQL expertise to analyze the strengths and weaknesses of MongoDB. SPEAKER: Tim Callaghan, VP of Engineering at Tokutek DATE: Tuesday, December 17th TIME: 1pm ET Register Now! MongoDB is a popular NoSQL DBMS that shares the ease-of-use and quick setup that...
by Yves Trudeau | Dec 10, 2013 | Insight for DBAs, MySQL
My December 4 webinar, “Geographical disaster recovery with Percona Replication Manager (PRM),” gave rise to a few questions. The recording of the webinar and the slides are available Percona Gold or Platinum Support contract. It is not availabe with...
by Alexander Rubin | Dec 7, 2013 | MySQL
Because most MySQL production systems probably run on Linux, I’ve decided to place the most important Linux tuning tips that will help improve MySQL performance. There is nothing new here, most of them are well known, however, I’ve decided to collect those...
by Dave Rosenlund | Dec 6, 2013 | MySQL
Nominate Tokutek for the 2013 Best Technology Achievement Crunchies award! Help us be recognized for our database performance engines, TokuMX™ and TokuDB, and our revolutionary Fractal Tree® technology. Nominations will only be accepted until December 15, 2013 at...
by Dave Rosenlund | Dec 5, 2013 | MySQL
Get the Most out of Your Database – Understand Indexing SPEAKER: Zardosht Kasheff, Tokutek DATE: Tuesday, December 10th TIME: 1pm ET Register Now! Join Tokutek’s Zardosht Kasheff as he discusses one of the quickest and least expensive ways to increase your...
