Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 3, 2020
18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part One)
This is a three-part blog series. Part two is located here, and part three can be found here. There was [...]
April 3, 2020
Percona DBaaS CLI to Simplify Deployment in Kubernetes
We recently released an experimental version of percona-dbaas command-line tool with the goal of significantly simplifying the deployment of database [...]
April 2, 2020
ProxySQL 2.0.9 Introduces Firewall Whitelist Capabilities
In this blog, we will test a new security feature added in ProxySQL 2.0.9. Since a time ago, we have [...]
April 1, 2020
Introducing Metabase, a Simple and Powerful Analytics Tool
Recently I was looking for some simple way to analyze and create graphs from data stored in MySQL tables. I [...]
April 1, 2020
Tips for MySQL 5.7 Database Tuning and Performance
While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused [...]
March 31, 2020
Becoming Familiar With the Little Known SQL Keyword LATERAL
Working on a weekend project, I became familiar with the SQL keyword “LATERAL”, which I had not used before because [...]
March 30, 2020
Advanced Query Analysis in Percona Monitoring and Management with Direct ClickHouse Access
In my Webinar on Using Percona Monitoring and Management (PMM) for MySQL Troubleshooting, I showed how to use direct queries [...]
March 30, 2020
Which Cloud Provider Performs Better for My Mysql Workload?
More and more people are nowadays thinking of cloud migration. The question of “Which cloud provider performs better for my [...]
March 26, 2020
Split-Brain 101: What You Should Know
Disclaimer: The following blog post does not try to provide a solution for split-brain situations, and the example provided is [...]
March 26, 2020
Sysbench and the Random Distribution Effect
What You May Not Know About Random Number Generation in Sysbench Sysbench is a well known and largely used tool [...]
March 25, 2020
MySQL Performance Optimization with Percona Monitoring and Management – Webinar Followup
Last week I did a webinar on MySQL Troubleshooting and Performance Optimization with Percona Monitoring And Management v2 (PMM2). There [...]
March 19, 2020
Help Drive the Future of Percona XtraDB Cluster
Percona is happy to announce the experimental release of Percona XtraDB Cluster 8.0. This is a major step for tuning [...]
March 18, 2020
How Container Networking Affects Database Performance
Percona has been investing in building and releasing Operators for Kubernetes to run traditional databases in a cloud-native fashion. The [...]
March 9, 2020
Webinar 3/23: When is MyRocks a Good Fit?
In this talk, we’ll walk through RocksDB technology and look into situations where MyRocks is a good fit versus other [...]
March 6, 2020
Configuring a Read-Only Web Interface for Orchestrator
In the MySQL ecosystem, orchestrator is the most popular and well-respected high availability and topology management tool, integrating well with [...]
March 4, 2020
ClickHouse Versus MySQL Handling of Double Quotes
If you’re a MySQL user trying ClickHouse, one thing which is likely to surprise – and annoy you – is [...]
March 4, 2020
Webinar 3/18: Optimize and Troubleshoot MySQL Using Percona Monitoring and Management
As a MySQL DBA, the databases powering your applications need to handle changing traffic workloads while remaining responsive and stable [...]
February 28, 2020
Better Prometheus rate() Function with VictoriaMetrics
There are a lot of things I love about Prometheus; its data model is fantastic for monitoring applications and PromQL [...]
February 25, 2020
MySQL ERROR 1034: Incorrect Key File on InnoDB Table
Sometimes, you may experience “ERROR 1034: Incorrect key file” while running the ALTER TABLE or CREATE INDEX command: [crayon-68c67e3af1b5b506171391/] As [...]
February 20, 2020
A Hidden Gem in MySQL: MyRocks
In this blog post, we will share some experiences with the hidden gem in MySQL called MyRocks, a storage engine [...]