Monthly Archives - January 2018

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

Percona Server for MySQL 5.7.20-19 Is Now Available

Percona Server for MySQL

Percona announces the GA release of Percona Server for MySQL 5.7.20-19 on January 3, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
Based on MySQL 5.7.20, including all the bug fixes in it, Percona Server for MySQL […]

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

This Week in Data with Colin Charles 22: CPU vulnerabilities and looking forward to 2018

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Happy New Year. Here’s to 2018 being a great year in the open source database world. What is in store for us? Probably: MySQL 8.0 and MariaDB Server 10.3 as generally available. What will we […]

Read more

Meltdown and Spectre: CPU Security Vulnerabilities

CPU Security Vulnerabilities

In this blog post, we examine the recent revelations about CPU security vulnerabilities.
The beginning of the new year also brings to light fresh and new CPU security vulnerabilities. Today’s big offenders originate on the hardware side – more specifically, the CPU. The reported hardware kernel bugs allow for direct access to data held in the […]

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

Generated Columns and ProxySQL Instead of Referenced Tables

Generated Columns

In this post, we’ll look at how to improve queries using generated columns and ProxySQL instead of implementing a referenced table.
Developers and architects don’t always have the time or complete information to properly analyze and design a database. That is why we see tables with more fields than needed, or with incorrect types. The […]

Read more