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...
by Dave Avery | Jul 19, 2017 | MariaDB, MongoDB, MySQL
In this post, we’ll use a blog poll to find out what operating system you use to run your development database servers. In our last blog poll, we looked at what OS you use for your production database. Now we would like to see what you use for your development...
by Vadim Tkachenko | Jul 6, 2017 | Benchmarks, Insight for DBAs, MySQL
In this blog, we’ll look at ClickHouse on its one year anniversary. It’s been a year already since the Yandex team released ClickHouse as open source software. I’ve had an interest in this project from the very start, as I didn’t think there was an...
by Barrett Chambers | Jun 29, 2017 | MongoDB, MySQL, Percona Services, Percona Software
In this blog post, I’ll discuss my experience as a Solutions Engineer in explaining the value of Percona software and services to customers. The inspiration for this blog post was a recent conversation with a prospective client. They were exploring open source...
by Dave Avery | Jun 8, 2017 | MongoDB, MySQL
In this post, we’ll use a blog poll to find out what operating system you use to run your production database servers. As databases grow to meet more challenges and expanding application demands, they must try and get the maximum amount of performance out of...