by Alexey Stroganov | Oct 26, 2015 | Benchmarks, MySQL, Percona Software
This week Oracle will release MySQL 5.7 GA, so it’s a perfect time to do a quick review of the current state of Percona Server 5.6.26, MySQL 5.6.26 and MySQL-5.7.8 RC. We used two boxes from our benchmark lab for this: – Box 1: 16 Cores+HT (32 virt...
by Alexander Rubin | Aug 24, 2015 | MySQL, Webinars
Thank you for attending my July 22 webinar titled “Advanced Query Tuning in MySQL 5.6 and 5.7” (my slides and a replay available here). As promised here is the list of questions and my answers (thank you for your great questions). Q: Here is the explain...
by Stephane Combaudon | Aug 19, 2015 | MySQL
I have heard this question quite often: “At busy times, our replicas start lagging quite frequently. We are using N schemas, so which performance boost could we expect from MySQL 5.6 parallel replication?” Here is a quick way to give you a rough estimate...
by Kortney Runyan | Aug 18, 2015 | Insight for DBAs, Percona Events, Percona Live
In the past years, both MySQL 5.6, MySQL 5.7 and MariaDB 10 have been successful implementing new features. For many DBAs, the “old way” of replicating data is comfortable so taking the action to implement these new features seems like a momentous leap...
by Peter Zaitsev | Dec 24, 2014 | Insight for DBAs, MySQL
It has been a while since I have looked at InnoDB crash recovery. A lot has change in the last few years – we have serious crash recovery performance improvements in MySQL 5.5 and MySQL 5.6, we have solid state drives raising as typical high performance IO...
by Jay Janssen | Nov 25, 2014 | MySQL, Security
I log into a lot of different servers running MySQL and one of the first things I do is create a file in my home directory called ‘.my.cnf’ with my credentials to that local mysql instance: [client] user=root password=secret 123...
by Miguel Angel Nieto | Nov 20, 2014 | Insight for DBAs, MySQL
Performance Schema (P_S) has been available since MySQL 5.5, more than 4 years ago. It is still difficult to see production servers with P_S enabled, even with MySQL 5.6 where the feature is enabled by default. There have been several complaints like the overhead,...
by Tom Diederich | Oct 30, 2014 | MySQL, Percona Live
With 1.28 billion active users, Facebook MySQL database engineers are active and extremely valuable contributors to the global MySQL community. So naturally they are also active participants of Percona Live MySQL conferences! And next week’s Percona Live London 2014...
by Peiran Song | Oct 28, 2014 | Insight for DBAs, MySQL, Percona Software
A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable. InnoDB automatically detects transaction deadlocks,...
by Stephane Combaudon | Sep 5, 2014 | MySQL, Percona Services, Webinars
Thank you to all of you who attended my webinar last week about Global Transaction IDs (GTIDs), which were introduced in MySQL 5.6 to make the reconfiguration of replication straightforward. If you missed my webinar, you can still listen to the recording and download...
by Peter Zaitsev | Jul 30, 2014 | Insight for DBAs, MySQL
As we know different storage engines in MySQL have different file structures. Every table in MySQL 5.6 must have a .frm file in the database directory matching the table name. But where the rest of the data resides depends on the storage engine. For MyISAM we have...
by Ernie Souhrada | Jul 8, 2014 | Cloud, Insight for DBAs, Insight for Developers, MySQL
This comes from an issue that I worked on recently, wherein a customer reported that their application was working fine under stock MySQL 5.6 but producing erroneous results when they tried running it on Amazon RDS 5.6. They had a table which, on the working server,...
by Alexander Rubin | Jun 9, 2014 | Insight for DBAs, MySQL
Hosting a shared MySQL instance for your internal or external clients (“multi-tenant”) was always a challenge. Multi-tenants approach or a “schema-per-customer” approach is pretty common nowadays to host multiple clients on the same MySQL...
by Stephane Combaudon | May 9, 2014 | Insight for DBAs, MySQL
One of the MySQL 5.6 features many people are interested in is Global Transactions IDs (GTIDs). This is for a good reason: Reconnecting a slave to a new master has always been a challenge while it is so trivial when GTIDs are enabled. However, using GTIDs is not only...
by Stephane Combaudon | Mar 6, 2014 | Insight for DBAs, MySQL
I recently worked on an uncommon slow query: less than 100 rows were read and returned, the whole dataset was fitting in memory but the query took several seconds to run. Long story short: the query was a join involving 21 tables, running on MySQL 5.1. But by default...
by Yves Trudeau | Jan 20, 2014 | Insight for DBAs, MySQL
Over the last few days, I integrated the MySQL 5.6 GTID version of the Percona Replication Manager (PRM) work of Frédéric Descamps, a colleague at Percona. The agent supports the GTID replication mode of MySQL 5.6 and if the master suffers a hard crash, it picks the...
by Stephane Combaudon | Jan 3, 2014 | Insight for DBAs, MySQL
by Michael Rikmas | Nov 5, 2013 | Insight for DBAs, MySQL
A few years ago Yves Trudeau and Aleksandr Kuzminsky wrote posts about different ways for recovering orphaned .ibd files: Connecting orphaned .ibd files A recovery trivia or how to recover from a lost ibdata1 file Today I want to show you how to do that in a more easy...
by Alexey Stroganov | Oct 30, 2013 | MySQL, Percona Software
In MySQL 5.6 InnoDB has a dedicated thread (page_cleaner) that’s responsible for performing flushing operations. Page_cleaner performs flushing of the dirty pages from the buffer pool based on two factors: – access pattern – the least recently used...
by Stephane Combaudon | Oct 28, 2013 | MySQL, Webinars
I want to thank all attendees of my webinar, “MySQL 5.6 New Replication Features: Benefits, Challenges and Limitations”. We had questions that I didn’t have the time to answer: Q: If I run on Amazon’s RDS, do I need to worry about enabling...
