Tag - Open Source

Using MySQL 5.7 Generated Columns to Increase Query Performance

MySQL Generated Columns

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 one of my favorite features in the MySQL 5.7 release. The reason is simple: […]

Read more

MySQL 8.0 RESOURCE_GROUP Overview

MySQL 8.0 innodb_dedicated_server

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 not GA yet, so it is possible for the MySQL 8.0 RESOURCE_GROUP […]

Read more

Webinar Wednesday, January 10, 2018: Why We’re Excited About MySQL 8.0

MySQL 8.0 innodb_dedicated_server

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 new features in MySQL 8.0, but how exactly can they help your applications? This session […]

Read more

Using ioping to Evaluate Storage Performance for MySQL Workloads

ioping

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 latency.  
For me, the main beauty of ioping is its simplicity and […]

Read more

InnoDB Performance Optimization: Webinar Q & A

InnoDB Performance Optimization

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 disclose what specific version of CPUs they use […]

Read more

Percona Toolkit 3.0.6 Is Now Available

percona toolkit

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 Toolkit, like all Percona software, is free and open source.
You download packages from the website or install […]

Read more

Case in Point: A Year of Customer Experience with Percona

Customer Experience

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, our consultancy, support and managed services staff apply their expertise across […]

Read more

Percona Database Performance Blog Year in Review: Top Blog Posts

Percona Database Performance Blog

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 source community with insights, technical support, predictions and metrics around multiple […]

Read more

This Week in Data with Colin Charles 20: cPanel changes strategy, Percona Live CFP extended

Colin Charles

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 Good Open Source Community Member: Why we hesitated on MySQL 5.7. cPanel […]

Read more

This Week in Data with Colin Charles 19: Percona Live Tickets, Call for Papers and FOSDEM

Colin Charles

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 the last minute! Look at our broad scope as well. Worth noting that the best prices […]

Read more