Tag - MySQL

MySQL Monitoring and Reporting Using the MySQL Shell

Monitoring Using the MySQL Shell

MySQL Shell is the advanced MySQL client, which has many excellent features. In this blog, I am going to explain the MySQL shell commands “\show” and “\watch”. Both commands are very useful to monitor the MySQL process. It provides more insights into the foreground and background threads as well. 
Overview
“\show” and “\watch” are the MySQL […]

Read more

MySQL 5.6 and Percona Server for MySQL 5.6 are End of Life

MySQL 5.6 End of Life

MySQL 5.6.51 is the last release of the MySQL 5.6 series. Oracle will no longer provide updates or security fixes for this version.
Following Percona’s Release Lifecycle policies, the Percona Server for MySQL 5.6 series has reached End of Life (EOL) as well, and we will no longer provide public builds for bugs and security […]

Read more

Various Types of InnoDB Transaction Isolation Levels Explained Using Terminal

InnoDB Transaction Isolation Levels

The goal of this blog post is to explain the various types of transaction isolation levels available in MySQL. After reading the blog, you will be able to explain dirty reads, non-repeatable reads, and the concept of phantom rows as well.
What is the Isolation Level in MySQL?
Isolation (I) is one of the properties from […]

Read more

Webinar February 24: What’s Old Is New, What’s Coming Is Here – Percona Offerings for MySQL 5.6 and DBaaS in PMM

Percona Webinar February 24

Join Brian Walters and Brandon Fleisher for an interactive discussion around new service and software offerings coming from Percona.
Oracle has decided that MySQL 5.6 will reach its end of life in February 2021. This means there will be no more updates and, more importantly, no more security fixes for discovered vulnerabilities. Yikes! Did you […]

Read more

Q&A on Webinar “Using PMM to Identify and Troubleshoot Problematic MySQL Queries”

Problematic MySQL Queries

Hi and thanks to all who attended my webinar on Tuesday, January 26th titled Using PMM to Identify & Troubleshoot Problematic MySQL Queries!
Like we do after all our webinars, we compile the list of questions that were answered verbally and also those that were posed yet remained unanswered since we ran out of time […]

Read more