MySQL Select and Sort Status Variables This page is a reboot of the original written 15 years ago in 2005. Back then, I must have been using MySQL 4.1 or 5.0. Today, I am using MySQL 8.0.22. A lot changed in MySQL from 4.1 to 8.0, but it still has the same Select_% and Sort_% status variables which are equally important today in 2021. Let’s examine them in greater detail and with better examples.

Database monitoring is a critical part of any application’s maintenance. Finding database issues on time can help the application remain healthy and accessible. Without monitoring in place, database outages can be prolonged, resulting in increased downtime for users. In this blog we are going to explain what you need to monitor in a Moodle Database, and how you can do it using ClusterControl.

ClusterControl Monitoring 

Using ClusterControl you can monitor the databases efficiently, it can do so by deploying agents on the database hosts or in an agentless fashion, by simply connecting to the databases via SSH . Data is presented in a GUI, in the form of a number of dashboards and charts. 

How Does ClusterControl Monitoring Work ?

ClusterControl …

We are pleased to announce that MySQL Database Service with HeatWave is now available in 22 regions worldwide. 

With the introduction of 10 new regions, MySQL Database Service is now present in all Oracle Cloud Infrastructure commercial regions:

North America  US East (Ashburn)  US West (Phoenix)  US West (San Jose)  Canada Southeast (Toronto)  Canada Southeast (Montreal) Latin America  Brazil East (Sao Paulo)  Chile Central (Santiago) EMEA  UK South (London)  UK West (Newport)  Germany Central (Frankfurt)  Switzerland North (Zurich)  Netherlands Northwest (Amsterdam)  Saudi Arabia West (Jeddah)  UAE East (Dubai) APAC  Japan East (Tokyo)  Japan Central (Osaka)  South Korea Central (Seoul)  South Korea North (Chuncheon)  Australia East (Sydney)  Australia Southeast (Melbourne)  India West (Mumbai)  India South …

We are pleased to announce that MySQL Database Service with HeatWave is now available in 22 regions worldwide. With the introduction of 10 new regions, MySQL Database Service is now present in all Oracle Cloud Infrastructure commercial regions: North America US East (Ashburn) US West (Phoenix) US We...

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.6, 5.7 and 8.0, consisting of MySQL-wsrep 5.6.50 (release notes, download), 5.7.32 (release notes, download) and 8.0.22 (release notes, download) with Galera replication library 3.32 ( …

In this post, we will see, how easily user can take NDB Cluster backup and then restore it. NDB cluster supports online backups, which are taken while transactions are modifying the data being backed up. In NDB Cluster, each backup captures all of the table content stored in the cluster.

User can take backup in the following states:

• When the cluster is live and fully operational
• When the cluster is live, but in a degraded state:
  • Some data nodes are down
  • Some data nodes are restarting
• During read and write transactions
  

Users can restore backups in the following cluster environments:

• Restore to the same physical cluster
• Restore into a different physical cluster
• Restore into a different configuration cluster i.e. backup …

2020 was a very eventful year at MySQL. Now that we just started 2021, this is a great time to look back at everything we accomplished in 2020, from the anniversary celebrations to the year's best webinars, the best events, the best customer quotes, the best new product addition, the best animated videos, the best social media contribution, the best social media posts and of course, Larry’s best quote and many more.  Here is our "Best of 2020," enjoy!  (We'd love to see your favorites too.  Feel free to share your favorites with us in the comment section)

1. 2020 was our MySQL 25th anniversary which we shared and celebrated with our friends from Java and PHP.  Watch the animated video that celebrates 25 years of community contribution and loyal customers and users.

2020 was a very eventful year at MySQL. Now that we just started 2021, this is a great time to look back at everything we accomplished in 2020, from the anniversary celebrations to the year's best webinars, the best events, the best customer quotes, the best new product addition, the best animated v...

The FOSDEM 2021 MySQL Devroom Schedule is now online.

Thank you again to all who submitted a talk and thank you the to Committee for having build such agenda.

It seems that once again, MySQL Operations and Architecture are very popular.

As you probably know already, this event will be totally online this year.

I would like to thanks the people who were able to jump after some cancellations… virtual events are not the most popular for speakers.

The MySQL Devroom will take place Sunday February 7th form 10AM to 6PM CEST.

Join us as Michael Coburn, Percona Product Manager, discusses two methods to identify and troubleshoot problematic MySQL queries using the RED Method and Percona Monitoring and Management (PMM) Query Analytics. He will also highlight specific Dashboards in PMM that visualize the rate, errors, and duration of MySQL events that may be impacting the stability and performance of your database instance.

Please join Michael Coburn, Product Manager, Percona, on Tuesday, January 26th, 2021 at 2:30 pm for his webinar “Using Percona Monitoring and Management to Identify and Troubleshoot Problematic MySQL Queries”.

Watch Recorded Webinar

If you can’t attend, …