by Przemysław Malkowski | Oct 14, 2013 | Insight for DBAs, MySQL, Percona Services
GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status. Excellent free...
by Stewart Smith | Oct 14, 2013 | MySQL, Percona Software, Webinars
A week ago we launched our first GA release of Percona Server 5.6 and it’s a real game-changer for us. The release of Percona Server 5.6 (our enhanced, drop-in replacement for MySQL) not only provides stability and performance but also provides key features only...
by Zardosht.Kasheff | Oct 11, 2013 | MySQL
Since introducing TokuMX, we’ve discussed benefits that TokuMX has for existing MongoDB applications that require no changes. In this post, I introduce an extension we’ve made to the indexing API: clustering indexes, a tool that can tremendously improve query...
by Dave Rosenlund | Oct 11, 2013 | MySQL
It is ridiculously small. From 80% disk space utilization down to 8% disk space utilization. Absolutely ridiculous!
by Roman Vynar | Oct 11, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Monitoring Plugins 1.0.5 for MySQL. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts....
by Stephane Combaudon | Oct 11, 2013 | Insight for DBAs, MySQL, Percona Software
I recently had a case where replication lag on a slave was caused by a backup script. First reaction was to incriminate the additional pressure on the disks, but it turned out to be more subtle: Percona XtraBackup was not able to execute FLUSH TABLES WITH READ LOCK...
by Ernie Souhrada | Oct 10, 2013 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
NOTE: This is part 1 of what will be a two-part series on the performance implications of using in-flight data encryption. Some of you may recall my security webinar from back in mid-August; one of the follow-up questions that I was asked was about the performance...
by Stewart Smith | Oct 10, 2013 | MySQL, Percona Events
I’ll be speaking at the upcoming Open Source Developers Conference (OSDC 2013) in Auckland, New Zealand! It’s on October 21st-23rd and you should go here right now and register. I’m giving two talks at OSDC this year: MySQL in the cloud, As A Service...
by Vadim Tkachenko | Oct 9, 2013 | MySQL, Percona Events
This is to announce that me and Daniel Nichter (Lead of Percona Toolkit) are coming to the MYSQL NOSQL & CLOUD CONFERENCE & EXPO in Buenos Aires, Argentina on Oct. 15-16. There also will be local Percona experts in attendance. Talks from Percona include:...
by Kenny Gryp | Oct 9, 2013 | MySQL, Percona Live
Do you want to get more familiar on how to become a MySQL DBA? Are you a developer familiar with writing applications that use MySQL but you feel a bit limited on how to manage a MySQL Database? I would like to invite you in my tutorial ‘MySQL DBA In A...
by Vadim Tkachenko | Oct 8, 2013 | Benchmarks, MySQL, Percona Software
Yesterday we announced the GA release of Percona Server 5.6, the latest release of our enhanced, drop-in replacement for MySQL. Percona Server 5.6 is the best free MySQL alternative for demanding applications. Our third major release, Percona Server 5.6 offers all the...
by Jay Janssen | Oct 8, 2013 | MySQL, Percona Software
I occasionally see customers who are taking backups from their PXC clusters that complain that the cluster “stalls” during the backup. As I wrote about in a previous blog post, often these stalls are really just Flow Control. But why would a backup cause...
by Hrvoje Matijakovic | Oct 7, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the first GA (Generally Available) release of Percona Server 5.6.13-61.0 on October 7th, 2013 (Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.13, including all the bug fixes in it, Percona Server...
by Peter Zaitsev | Oct 7, 2013 | Insight for DBAs, MySQL, Webinars
We had a wonderful time during the Sept. 25 webinar, “MySQL 5.6 Configuration Optimization,” and I got a lot more questions than I could answer during the hour. So here is a followup with answers to the most interesting questions you guys asked. (You can...
by Peter Zaitsev | Oct 6, 2013 | Cloud, Insight for Developers, MySQL
Baron recently wrote about sending the query to the data looking at distributed systems like Cassandra. I want to take a look at more simple systems like MySQL and see how we’re doing in this space. It is obvious getting computations as closer to the data as...
by Matt Griffin | Oct 4, 2013 | MySQL, Percona Software
Percona Server provides users with a variety of powerful benefits including enterprise-grade features, high performance in demanding use cases, rich diagnostics, and access to unique Percona XtraBackup capabilities, all for free and open source. In addition, Percona...
by Rich.Prohaska | Oct 3, 2013 | MySQL
One of our customers reported that ‘create table select from’ statements stall for a period of time equal to the TokuDB lock timeout. This indicated a lock conflict between multiple transactions. In addition, other MySQL clients that were opening...
by Peter Zaitsev | Oct 3, 2013 | Insight for DBAs, MySQL
The cost of SSDs has been dropping rapidly, and at the time of this writing, 2.5-drives have reached the 1TB capacity mark. You can actually get inexpensive drives for as little as 60 cents per GB. Even inexpensive SSDs can perform tens of thousands of IOPs and come...
by Dave Rosenlund | Oct 2, 2013 | MySQL
Save Time & Money – Do It Right The First Time SPEAKER: Gerry Narvaja, Tokutek DATE: Tuesday, October 8th TIME: 1pm ET If you are thinking of using the leading open source database in a project, learn just how easy it is to get started with MySQL, and how...
by Miguel Angel Nieto | Oct 2, 2013 | MySQL
Recently Oracle announced several new features for the latest available development version of MySQL that is 5.7.2 at the time of writing this article. Most of them are performance and replication related that show us how incredible the new release will be. In this...
