by Dave Avery | Feb 8, 2018 | Cloud, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live
Percona has revealed the line-up of in-depth tutorials for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, Calif. Secure your spot now with Advanced Registration prices...
by Ananias Tsalouchidis | Feb 7, 2018 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For...
by Michael Coburn | Feb 6, 2018 | Monitoring, MySQL, Open Source, Percona Software
In this blog post, we’ll introduce how you can look at some experimental Percona Monitoring and Management (PMM) features using Percona Labs builds on GitHub. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools...
by Peter Zaitsev | Feb 5, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look into four ways MySQL executes GROUP BY. In my previous blog post, we learned that indexes or other means of finding data might not be the most expensive part of query execution. For example, MySQL GROUP BY could potentially be...
by Alexander Rubin | Jan 29, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at ways you can use MySQL 5.7 generated columns (or virtual columns) to improve query performance. Introduction About two years ago I published a blog post about Generated (Virtual) Columns in MySQL 5.7. Since then, it’s been...
by Alex Poritskiy | Jan 25, 2018 | Insight for DBAs, MySQL, Open Source
In this blog post, we’ll provide an overview of the new MySQL 8.0 RESOURCE_GROUP feature. One great new feature introduced in MySQL 8.0 that – from my point of view – requires attention is RESOURCE_GROUP. Short disclaimer: I want to point out that MySQL 8.0 is...
by Peter Zaitsev | Jan 9, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents Why We’re Excited About MySQL 8.0 on Wednesday, January 10, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Experience: Basic Tags: Developer, DBAs, Operations, Executive, MySQL There are many great...
by Peter Zaitsev | Jan 8, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at how ioping can be used with other tools to understand and troubleshoot storage performance, specifically as it relates to MySQL workloads. I recently ran into ioping, a nice little utility by Konstantin Khlebnikov that checks storage...
by Peter Zaitsev | Jan 5, 2018 | MySQL, Webinars
Thank you for attending my webinar on Wednesday, December 20, 2017, InnoDB Performance Optimization. In this blog, I will provide answers to the Q & A for the webinar. Are the T2 CPUs similar to the M4 series? I would expect them to be similar. Amazon does not...
by Borys Belinsky | Jan 4, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.6 on January 4, 2018. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona...
by Lorraine Pocklington, Community Manager | Jan 3, 2018 | Cloud, Insight for DBAs, Monitoring, MySQL, Percona Services, Percona Software
In 2017 we have welcomed many new customers into the Percona fold. It’s always interesting to find out what challenges the Percona team helped them to address and how they chose their relationship with Percona. As unbiased champions of open source database software,...
by Dave Avery | Dec 29, 2017 | Benchmarks, MariaDB, MongoDB, MySQL
Let’s look at some of the most popular Percona Database Performance Blog posts in 2017. The closing of a year lends itself to looking back. And making lists. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open...
by Colin Charles | Dec 22, 2017 | MySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. I think the biggest news from last week was from cPanel – if you haven’t already read the post, please do – on Being a...
by Colin Charles | Dec 15, 2017 | MongoDB, MySQL, Percona Events, Percona Live, Percona Software
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. The Percona Live Call For Papers closes on December 22, but why aren’t you submitting already? Don’t wait till...
by Colin Charles | Dec 11, 2017 | Insight for DBAs, MariaDB, MongoDB, MySQL, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents 2017 Year in Review for Open Source Database Software on Wednesday, December 13, 2017 at 7:00 am PST / 10:00 am EST (UTC-8). Register Here 2017 is soon coming to an end, and it’s good to pause and...
by Tyler Duzan | Oct 19, 2017 | Cloud, Insight for DBAs, Insight for Developers, MongoDB, MySQL
Percona latest blog poll asks how you currently host applications and databases. Select an option below, or leave a comment to clarify your deployment! With the increased need for environments that respond more quickly to changing business demands, many enterprises...
by Colin Charles | Sep 29, 2017 | MariaDB, MongoDB, MySQL, Open Source, Percona Live
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Europe 2017 Dublin We’ve spent a lot of time in the last few months organizing Percona Live Europe...
by Colin Charles | Sep 15, 2017 | Insight for DBAs, Insight for Developers, Percona Events, Percona Live, Percona Software
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. What a long, packed week! Spent most of it at Open Source Summit North America, while still enjoying the myriad phone calls...
by Colin Charles | Aug 25, 2017 | MariaDB, MongoDB, MySQL, Open Source, Percona Live, PostgreSQL, ProxySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. We are five weeks out to the conference! The tutorials and the sessions have been released, and there’s an added bonus...
by Colin Charles | Aug 18, 2017 | MariaDB, MongoDB, MySQL, Percona Live
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Has a week passed already? Welcome back to the second column. A lot of time has been spent neck deep in getting speakers...
