by Laurynas Biveinis | May 9, 2016 | MySQL
In this blog post, we’ll discuss the ins and outs of Percona Server 5.7 parallel doublewrite. After implementing parallel LRU flushing as described in the previous post, we went back to benchmarking. At first, we tested with the doublewrite buffer turned off. We...
by Vadim Tkachenko | May 6, 2016 | MySQL
In this blog, we’ll examine how CPU governor performance affects MySQL. It’s been a while since we looked into CPU governors and with the new Intel CPUs and new Linux distros, I wanted to check how CPU governors affect MySQL performance. Before jumping to...
by Laurynas Biveinis | May 5, 2016 | MySQL
In this blog post, we’ll discuss how to use multi-threaded LRU flushing to prevent bottlenecks in MySQL. In the previous post, we saw that InnoDB 5.7 performs a lot of single-page LRU flushes, which in turn are serialized by the shared doublewrite buffer. Based...
by Peter Zaitsev | May 4, 2016 | MySQL
This blog post discusses what is going on in the MySQL high availability market, and what Percona’s plans are for helping customers with high availability solutions. One thing I like to tell people is that you shouldn’t view Percona as a “software” company, but...
by Laurynas Biveinis | May 3, 2016 | MySQL
In this post, we’ll examine why in an initial flushing analysis we find that Performance Schema data is incomplete. Having shown the performance impact of Percona Server 5.7 patches, we can now discuss their technical reasoning and details. Let’s revisit...
by Peter Zaitsev | May 3, 2016 | MySQL
In this blog post, we’ll discuss some of the best practices for configuring optimal MySQL memory usage. Correctly configuring the use of available memory resources is one of the most important things you have to get right with MySQL for optimal...
by Tibor Korocz | Apr 27, 2016 | MySQL, Percona Software
In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade. MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP and DATETIME types. Now these parameters...
by Manjot Singh | Apr 26, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll discuss upgrading MySQL with Orchestrator. I recently had a client, Life360, that wanted to upgrade from Percona Server 5.5 to Percona Server 5.6, and implement GTID in their high transaction environment. They had co-masters and multiple...
by Dave Avery | Apr 21, 2016 | Percona Live
Well, that is it for Percona Live 2016! This year was bigger and better than last year and included more sponsors, speakers, technologies, and talks than ever before. Once again we’d like to thank everybody who participated, and the entire open source community...
by Dave Avery | Apr 21, 2016 | Percona Live
It’s almost time for the closing remarks and passport prize give away at Percona Live 2016, but still the talks keep coming. I was able to quickly pop into a lecture on MongoDB Security with Stephane Combaudon, MySQL Consultant at Slice Technologies. Stephane...
by Dave Avery | Apr 21, 2016 | Percona Live
We’re starting to wind down here at Percona Live 2016, but there are still talks to see even this late in the conference! One of the talks I saw was Sometimes “Less is More” for dash-boarding and graphing with Michael Blue, Senior DBA at Big Fish Games. In this...
by Dave Avery | Apr 21, 2016 | Percona Live
Wednesday night at Percona Live 2016 was reserved for fun, fun, fun! Once again, the Percona Live Game Night proved to be a popular and amazing event. There were more games this year than last, as well as food, drinks, and lots of friendly competition! This year,...
by Dave Avery | Apr 21, 2016 | Percona Live
We wrapped up Thursday morning’s Percona Live 2016 keynotes (April 21) with The MySQL Community Award Ceremony. The MySQL Community Awards is a community-based initiative, with the goal of publicly recognizing contributors to the MySQL ecosystem. The idea is to...
by Dave Avery | Apr 21, 2016 | MySQL, Percona Live
We’re heading into the final day here at Percona Live 2016! People are looking a little tired, but still excited for some excellent talks today. Once again the day started off with two great keynote lectures. Read to the end for an important announcement! Peter...
by Dave Avery | Apr 21, 2016 | Percona Live
The second day of Percona Live 2016 is wrapping up, but I still wanted to get to one last lecture. Fortunately, there was a great one available: What’s New in MySQL with Geir Høydalsvik, Senior Software Development Director at Oracle, and Simon Mudd, DBA at...
by Dave Avery | Apr 20, 2016 | Cloud, Percona Live
The afternoon sessions at Percona Live 2016 are just as intriguing as the morning sessions. I’m trying to hit as many as I can, especially talks on interesting and upcoming technologies that are improving deployments and manageability. One of the talks I saw in...
by Dave Avery | Apr 20, 2016 | Percona Live
The second day at Percona Live 2016 is moving along, and there is just too much to see to get to it all. Percona acquired Tokutek last year and with it a MongoDB platform. I was interested in learning more about MongoDB this year at Percona Live 2016, and I’m...
by Dave Avery | Apr 20, 2016 | Percona Live
It’s another packed day here at Percona Live 2016, with many, many database topics under discussion. Some technical, some strategical, and some operational. One such talk I sat in on was given by Ernie Souhrada, Database Engineer and Bit Wrangler at Pinterest....
by Dave Avery | Apr 20, 2016 | Percona Live
We’ve started the second full day at Percona Live 2016, and again we had some pretty impressive and fascinating keynote speakers. This morning featured four keynote talks from some pretty heavy hitters in our industry: Anurag Gupta, Vice President of Big Data...
by Dave Avery | Apr 20, 2016 | Percona Live
It’s been a long first day at Percona Live 2016, filled with awesome insight and exciting topics. I was able to get to one more lecture before calling quits. For the final talk I saw today I listened to Igor Canadi, Software Engineer at Facebook, Inc.,...
