While it's easier to measure the impact of Dynimize if you are running a MySQL benchmark with clear metrics, it can sometimes be a challenge on a production workload where you don't have precise performance analytics or metrics available. There are many great MySQL performance analysis tools out there, however they can often take time and effort to setup.

The simple measureDyniMysql script was created for this exact reason, and does not incur any MySQL downtime. You can find it at /opt/dynimize/measureDyniMysql after installing Dynimize. It will report the change in MySQL queries per second and mysqld CPU usage after applying Dynimize. Here is how to use it.

1. Install and start dynimize, and get your mysqld process into the dynimized state. For example, the …

MySQL is the number one open source relational database management system in the world, and is used by millions of developers across all application types. DigitalOcean, a fast-growing cloud provider that’s increasing in popularity amongst the developer community, is a great host to consider for your MySQL deployments. In this article, we’re going to show […]

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 know you have options? Did you know Percona can solve this problem? Tune in to find out how.

Choosing a database-as-a-service (DBaaS) provider can be a daunting challenge. Not ready to move to DBaaS in the public cloud? Or, are you constrained to on-prem deployment due to regulations or other market conditions? Tune-in to learn how Percona is bringing the benefits of simplified DBaaS deployment to the on-prem, private cloud, and hybrid datacenter.

This interactive webinar will be conducted in a roundtable forum style. Bring your interests, bring …

We are happy to announce another MySQL Webinar on the topic of "", see details below:

• Date: Feb 16, 2021
• Time: 2:00 pm Dubai time (GMT+4)
• Topic: Best practices for MySQL Performance
• Description: Of all the features that are available in MySQL, we will still need to optimize and fine tune our environment to our specific needs and the immediate or not-too-distant future growth. In this session we will have a look into ways to analyze the instances' performance and take into consideration some suggestions and best practices.
• Speaker: Carsten Thalheimer, the MySQL Master Principal Sales Consultant
• Registration …

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 during the broadcast.  Before we get to the questions, I wanted to make sure to include a link to the RED Method for MySQL Queries by Peter Zaitsev, Percona’s CEO:

https://grafana.com/grafana/dashboards/12470

Hi Michael, you suggested that table create and update times should be ignored. Surely these values come from information_schema.tables? Does that not reflect what I would see if I …

MySQL Firewall is an enterprise security solution providing ease of mind while protecting your database from rogue queries. Sometimes granting wide-style access privileges may feel a bit too generous, and leaves you wondering whether you could do something more. Join us as we explore Firewall, and (in particular) using Group profiles.…

Facebook Twitter LinkedIn

There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the resiliency of the solution (different hardware, network segments, etc,).

When we consider cloud environments, spreading instances across many availability zones (AZ) is considered a best practice, but that presents a problem regarding VIP handling.

Per definition, VPC subnets have to be created in a specific AZ, and subnet IP ranges can’t overlap with one another. An IP address cannot simply be moved to an instance on a different AZ, as it would end up in a subnet that doesn’t include it.

So in order to use the VIP method, we …

The MySQL team is proud to announce the general availability of version 8.0.23 of the MySQL Shell.

In addition to a considerable number of bugs fixed, the following changes were introduced.

Improved Import Table

The importTable utility continues getting better, the following enhancements:

• Multiple file import: it is now supported to load a defined set of files into the same table, glob patterns can be used to determine the files to be loaded.

… Facebook Twitter LinkedIn

Percona XtraBackup 8.0.23 enables the “lock-ddl” option by default to ensure any DDL events do not corrupt the backups. Any DML events continue to occur, and only DDL events are blocked.

A DDL lock protects the definition of tables and views. With the “–lock-ddl” option disabled, Percona XtraBackup allows backups while concurrent DDL events continue to happen. These backups are invalid and fail at the Prepare stage. If DDL events have occurred without the backup user’s knowledge, they may be unaware the backup is corrupt.

MySQL 8.0 introduced “Lock Instance for Backup”. This backup lock is lightweight, and the performance for DML operations is almost the same with or without backup locks. This lock is not available in 5.7, because …

CSV imports with MySQL Workbench, is super simple. Since CSV’s are probably the most common data interchange format, it goes without saying that importing CSV data into MySQL is a staple task for all DBA’s and Developers. Continue reading to learn how easy it is using MySQL Workbench…

Image by OpenClipart-Vectors from Pixabay

Self-Promotion:

If you enjoy the content written here, by all means, …