Tag: query

Performance

Updated: ClusterControl Tips & Tricks: MySQL Query Performance Tuning

Bad query performance is the most common problem DBA’s have to deal with. There are numerous ways to collect, process and analyze the data related to query performance – we’ve covered one of the most popular tools, pt-query-digest, in some of our previous blog posts: Become a MySQL DBA blog series When you use ClusterControl …

Software

ProxySQL Releasing ProxySQL 1.4.6

Proudly announcing the release of the latest stable release of ProxySQL 1.4.4 as of the 1st of February 2018. ProxySQL is a high performance, high availability, protocol aware proxy for MySQL. It can be downloaded here, and freely usable and accessible according to GPL license. ProxySQL 1.4.6 includes a number of important improvements and bug …

Miscellaneous

ProxySQL | Compiling ProxySQL on FreeBSD

Compiling ProxySQL 1.4.6 on FreeBSD 11.1 FreeBSD is the operating system of choice for many MySQL installations and a topic that often comes up in the ProxySQL Google Forums as well as the ProxySQL Github Issue Tracker is related to ProxySQL on FreeBSD. An official package for FreeBSD (and BSD in general) is not available …

Performance

How to choose the best indexes for MySQL query and database optimization

Many of our users, developers and database administrators, keep asking our team about EverSQL’s indexing recommendations algorithm. So, we decided to write about it.   Tip: Do not click here if all your SQL queries are as fast as a lightning!   This tutorial won’t detail all the internals of the  algorithm, but rather try …

Miscellaneous, Software

Enhanced replication monitoring in ProxySQL 1.4.4

ProxySQL and pt-heartbeat The Percona toolkit provides a very useful script for more accurate replication lag monitoring called pt-heartbeat. The pt-heartbeat script provides replication lag metrics based on actual data that has been replicated and is more accurate than the Seconds_Behind_Master metrics gathered from the output of SHOW SLAVE STATUS. Seconds_Behind_Master relies purely on system …