by Zardosht.Kasheff | Feb 12, 2014 | MySQL
Patrick McFadin recently wrote a post titled “MongoDB. This is not the database you are looking for”, where he mentions “In the past year there has been a rising chorus of users stuck on a cliff with MongoDB and are desperate to get out.” The key theme seems to be...
by Bill Karwin | Feb 12, 2014 | Insight for DBAs, Webinars
January 22 I gave a presentation on “How to Avoid Common (but Deadly) MySQL Operations Mistakes” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to...
by Zardosht.Kasheff | Feb 11, 2014 | MySQL
With TokuMX 1.4 coming out soon, with (teaser) wonderful improvements made to sharding and updates (and plenty of other goodies), I’ve recently reminisced about how we got TokuMX to this point. We (actually, really John) started dabbling with integrating Fractal Tree®...
by Peter Zaitsev | Feb 11, 2014 | Insight for DBAs, MySQL, Percona Software
A couple of weeks ago, shortly after Vadim wrote about Percona Cloud Tools and using Slow Query Log to capture the data, Mark Leith asked why don’t we just use Performance Schema instead? This is an interesting question and I think it deserves its own blog post...
by Bill Karwin | Feb 11, 2014 | Insight for Developers, MySQL
Over the past few years, we’ve seen MySQL technology advance in leaps and bounds, especially when it comes to scalability. But by focusing on the internals of the storage engine for so long, MySQL has fallen behind regarding support for advanced SQL features....
by Jaime Sicam | Feb 10, 2014 | MySQL
One of the common tasks requested by our support customers is to optimize slow queries. We normally ask for the table structure(s), the problematic query and sample data to be able to reproduce the problem and resolve it by modifying the query, table structure, or...
by Jay Janssen | Feb 7, 2014 | MySQL, Webinars
Thanks to all who attended my webinar yesterday. The slides and recording are available on the webinar’s page. I was a bit overwhelmed with the amount of questions that came in and I’ll try to answer them the best I can here. Q: Does Percona XtraDB...
by Tom Diederich | Feb 6, 2014 | MySQL, Percona Events, Percona Live
Twitter’s Calvin Sun (@Calvinsun2012) is looking forward to the fast-approaching Percona Live MySQL Conference and Expo this April 1-4 in Santa Clara, Calif. He’ll be speaking, yes, but he’s also looking forward to learning from his peers – particularly those at...
by Vadim Tkachenko | Feb 5, 2014 | Insight for DBAs, MySQL, Percona Software, Webinars
Next week (Wednesday, February 12 at 10 a.m. Pacific) I will host a webinar titled “Analyze MySQL Query Performance with Percona Cloud Tools.”
by Vadim Tkachenko | Feb 4, 2014 | Benchmarks, MySQL, Percona Software
We just published results with improvements in Thread Pool in Percona Server: Percona Server: Thread Pool Improvements for Transactional Workloads Percona Server: Improve Scalability with Thread Pool What I am happy to see is that Percona Server is able to handle a...
by Terry Erisman | Feb 4, 2014 | MySQL, Percona Events, Percona Services, Percona Software
ClusterControl for Percona XtraDB Cluster is now available in three different versions thanks to our partnership with Severalnines. ClusterControl will make it simpler to manage and monitor Percona XtraDB Cluster, MySQL Cluster, MySQL Replication, or MySQL Galera. I...
by Zardosht.Kasheff | Feb 3, 2014 | MySQL
William Zola over at MongoDB gave a great talk called “The (Only) Three Reasons for Slow MongoDB Performance”. It reminded me of an interesting characteristic of updates in MongoDB. Because MongoDB’s main data store is a flat file and secondary indexes store offsets...
by Michael Rikmas | Feb 3, 2014 | Insight for DBAs, MySQL, Percona Software
Here in Percona Support, we’re receiving several requests per day for help with Percona Cloud Tools installation steps. So I decided to prepare a step-by-step example of the installation process with some comments based on experience. Percona Cloud Tools is a...
by Jericho Rivera | Feb 3, 2014 | Insight for DBAs, MySQL, Percona Software
This is the first in a series of posts highlighting a few of the seldom-used but still handy Percona Toolkit tools. Have you ever had a problem understanding the EXPLAIN statement output? And are you the type of person who would rather use the command line than a GUI...
by Vadim Tkachenko | Jan 30, 2014 | MySQL, Percona Software
Percona is pleased to announce the first General Availability release of the leading open source High Availability solution for MySQL, Percona XtraDB Cluster 5.6 on January 30, 2014. Binaries are available from downloads area or from our software repositories. Percona...
by Dave Rosenlund | Jan 30, 2014 | MySQL
MongoDB is loved by developers for its productivity, but productivity can decline when you begin to write enterprise applications and realize that some database features you take for granted are not available in MongoDB. One of these features is support for...
by Peter Zaitsev | Jan 30, 2014 | MySQL, Percona Events, Percona Live
The Percona Live MySQL Conference and Expo 2014 is just two months away. I’m very excited about this year’s event which continues our tradition of open technical discussions and inviting all parties to the table. We have a great amount of technical talks...
by Alexey Stroganov | Jan 29, 2014 | Benchmarks, MySQL, Percona Software
In a previous thread pool post, I mentioned that in Percona Server we used an open source implementation of MariaDB’s thread pool, and enhanced/improved it further. Below I would like to describe some of these improvements for transactional workloads. When we...
by Vadim Tkachenko | Jan 29, 2014 | MySQL, Percona Software
In our practice we often see that MySQL performance optimization is done in a sort of “black magic” way. A common opinion is: “If there is a performance problem – then it must be a database issue, because what else could it be? And if this is a...
by Stephane Combaudon | Jan 28, 2014 | Insight for DBAs, MySQL
Note: This blog has been updated for MySQL 5.7 here! In this blog, we’re going to discuss the top ten MySQL performance tuning settings that you can implement after an installation. When we are hired for a MySQL performance audit, we are expected to review the...
