Tag - mysql-and-variants

MySQL 101: Parameters to Tune for MySQL Performance

Parameters to Tune for MySQL Performance

While there is no magic bullet for MySQL tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical settings that […]

Read more

Percona Server for MySQL Highlights – Extended Slow Query Logging

mysql extended slow query logging

Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server for MySQL, by discussing binlog_space_limit option.
Today, I am going to discuss another important type of log available in MySQL that is enhanced in Percona Server for MySQL – the slow query log. The reason […]

Read more

Security Threat Tool Design in Percona Monitoring and Management

Security Threat Tool Percona Monitoring and Management

Security Threat Tool (STT) is the new Percona Monitoring and Management (PMM) feature. It provides the ability to run automated security checks across all of your databases and detect potential security problems. For example: empty or default passwords, weak security settings, outdated database versions, misconfiguration, but also more complex and tricky issues.

Security checks developed […]

Read more

MySQL 101: How to Find and Tune a Slow SQL Query

tune a slow sql query

One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket.  While this can be caused by a multitude of factors, it is more often than not caused by a bad query.  While everyone always hopes to recover through some quick config tuning, the real fix […]

Read more

Webinar July 9 – Modern Solutions for Modern Database Load: MySQL 8.0 and Percona

Modern Solutions for Modern Database Load_ MySQL 8.0 and Percona

Join Sveta Smirnova, MySQL Engineer at Percona, as she discusses modern solutions for modern database loads.
MySQL is famous for working well in high performing environments. This is the reason why it is the most popular backend for web applications. But our view of what to call high-performance changes over the cycles. Every year we […]

Read more