by Daniel Nichter | Mar 12, 2015 | MySQL, Percona Software
The MySQL Performance Schema exposes so much data that it’s not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics – like min, max, and average query execution time – with a few clicks: Click...
by Justin Swanhart | Mar 10, 2015 | MySQL
by Robert Barabas | Mar 6, 2015 | MySQL
Have you ever had a case where you needed to find a process which sent a HUP/KILL/TERM or other signal to your database? Let me rephrase. Did you ever have to find which process messed up your night? 😉 If so, you might want to read on. I’m going to tell you how...
by David Busby | Mar 5, 2015 | MySQL, Security
The CVE-2015-0204 FREAK SSL vulnerability abuses intentionally weak “EXPORT” ciphers which could be used to perform a transparent Man In The Middle attack. (We seem to be continually bombarded with not only SSL vulnerabilities but the need to name...
by Peter Zaitsev | Mar 5, 2015 | MySQL, Percona Events, Percona Live
I am thrilled to announce that Apple co-founder and Silicon Valley icon and philanthropist Steve Wozniak will participate in a moderated Q&A on creativity and innovation April 14 during this year’s Percona Live MySQL Conference and Expo in Santa Clara, California....
by Nik Vyzas | Mar 3, 2015 | Cloud, MySQL, Percona Software
As the need for information grows so does the size of data we need to keep in our databases. SST is unavoidable for spinning up new nodes in a PXC cluster and when datasets reach the “terra-byte” range this becomes ever more cumbersome requiring many hours...
by Muhammad Irfan | Feb 27, 2015 | Insight for DBAs, MySQL, Percona Software
DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL server that would impact performance. Long-running queries can be the result of many factors. Fortunately, Percona Server contains some handy tools...
by Fernando Laudares Camargos | Feb 26, 2015 | Insight for DBAs, MySQL
If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or later you’ll see the following lines on the server’s error log and chances are you’ll be worried about them: Shell InnoDB: detected cycle in...
by Jon Tobin | Feb 25, 2015 | MySQL
In Mo’ Data, Mo’ Problems, we explored the paradox that “Big Data” projects pose to organizations and how Tokutek is taking an innovative approach to solving those problems. In this post, we’re going to talk about another hot topic in IT, “The Cloud,” and how...
by Alexander Rubin | Feb 25, 2015 | Insight for DBAs, MySQL
MySQL introduced the Event Scheduler in version 5.1.6. The Event Scheduler is a MySQL-level “cron job”, which will run events inside MySQL. Up until now, this was not a very popular feature, however, it has gotten more popular since the adoption of Amazon...
by Brock Wilson | Feb 24, 2015 | Benchmarks, MySQL, Percona Services, Percona Software
MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Many...
by Tom Diederich | Feb 23, 2015 | MySQL, Percona Events, Percona Live
Have designs on Percona Live this April in Silicon Valley? Send them to us! The winning entry will appear on a cool limited edition t-shirt that we’ll award to a few dozen lucky recipients at our booth’s new Percona T-Shirt Bar. The winner will also get a...
by Fernando Laudares Camargos | Feb 20, 2015 | Insight for DBAs, MySQL, Percona Software
This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as
by Matt Griffin | Feb 18, 2015 | Insight for DBAs, MySQL, Percona Events
Percona has submitted seven talks for the next Voting ends February 23, and if you aren’t already an OpenStack Foundation member (required to vote), you can join now for free MySQL and OpenStack Deep Dive Speakers: Peter Boros, Jay Pipes (Mirantis) MySQL on Ceph...
by Justin Swanhart | Feb 17, 2015 | MySQL
by Joe.Laflamme | Feb 11, 2015 | MySQL
Section I: Fractal Tree and Optimization Overview Tokutek’s Fractal Tree® technology provides fast performance by injecting small messages into buffers inside the Fractal Tree index. This allows writes to be batched, thus eliminating I/O that is required in...
by Stephane Combaudon | Feb 10, 2015 | Insight for DBAs, MySQL, Percona Software
Global Transaction IDs (GTIDs) are one of my favorite features of MySQL 5.6. The main limitation is that you must stop all the servers at the same time to allow GTID-replication. Not everyone can afford to take a downtime so this requirement has been a showstopper for...
by Rich.Prohaska | Feb 5, 2015 | MySQL
In the recently released TokuDB 7.5.5 the implementation of TokuDB hot-backup moved from a patch to the MySQL Server, to MySQL Plugin. Why did we make this change? TokuDB hot backup makes a transactionally consistent copy of the TokuDB files while applications...
by Kortney Runyan | Feb 3, 2015 | MySQL, Percona Live
It’s hard to believe that the Percona Live MySQL Conference and Expo is just over two months away (April 13-16 in Santa Clara, California). So if you’ve been thinking about submitting a proposal for the popular “Lightning Talks” and/or...
by Kortney Runyan | Jan 30, 2015 | Insight for DBAs, MySQL, Percona Live
This April 13-14 Percona is introducing an annual conference called OpenStack Live. I’ve seen a few questions about the new event so decided to help clarify what this show is about and who should attend. Unlike OpenStack Summits, held twice a year and dedicated to...
