by Daniel Guzmán Burgos | Nov 1, 2019 | Insight for DBAs, MariaDB, MySQL
Some say that the best password is the one you don’t have to remember. That’s possible with MySQL, thanks to the auth_socket plugin and its MariaDB version unix_socket.Neither of these plugins is new, and some words have been written about the auth_socket... by Daniel Guzmán Burgos | Sep 27, 2019 | MySQL
MySQL Shell is a pretty nice piece of software. Is not just another mysql client but it is also a tool that offers scripting capabilities for JavaScript and Python. And one of the coolest things you can do with it is to check if your MySQL 5.7 server is ready for an... by Daniel Guzmán Burgos | Mar 12, 2019 | Insight for DBAs, MySQL, Percona Software
by Daniel Guzmán Burgos | Mar 14, 2018 | Monitoring, MySQL, Percona Software
In this blog post, we’ll look at how to create PMM custom graphs and dashboards to track what you need to see in your database.Percona Monitoring and Management (PMM)’s default set of graphs is pretty complete: it covers most of the stuff a DBA requires to... by Daniel Guzmán Burgos | Nov 8, 2017 | Insight for DBAs, Percona Software
In this blog post, we’ll look at how to use Prometheus to check for auto_increment value exhaustion.One of the proactive tasks DBAs perform is checking if a field defined as auto_increment is about to reach the maximum allowed value of the int definition. For... by Daniel Guzmán Burgos | Jan 3, 2017 | Insight for DBAs, MySQL
This post discusses enabling and disabling jemalloc on Percona Server for MySQL.The benefits of jemalloc versus glibc for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) you have less memory... by Daniel Guzmán Burgos | Nov 4, 2016 | MySQL, Percona Software
In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change.One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough... by Daniel Guzmán Burgos | Sep 9, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll look at some of the basic housekeeping steps for MySQL indexes.We all know that indexes can be the difference between a high-performance database and a bad/slow/painful query ride. It’s a critical part that needs deserves some... by Daniel Guzmán Burgos | Dec 2, 2015 | Insight for DBAs, MySQL
Errant transactions are a major issue when using GTID replication. Although this isn’t something new, the drawbacks are more notorious with GTID than with regular replication.The situation where errant transaction bites you is a common DBA task: Failover. Now... by Daniel Guzmán Burgos | Oct 20, 2015 | Insight for DBAs, MySQL
I love graphs. They just make things easier when it comes to finding patterns. I also love visibility. Having the ability to known what is going on inside the database is priceless. How about having visibility of the slow queries execution time on a graph? Let’s... by Daniel Guzmán Burgos | Oct 13, 2015 | Insight for DBAs
Query analysis is a fantastic path in the pursuit to achieve high performance. It’s also probably the most repeated part of a DBA’s daily adventure. For most of us, the weapon of choice is definitely pt-query-digest, which is one of the best tools for slow... by Daniel Guzmán Burgos | Oct 1, 2015 | Insight for DBAs, MySQL
Capturing data is a critical part of performing a query analysis, or even just to have an idea of what’s going on inside the database.There are several known ways to achieve this. For example: Enable the General Log Use the Slow Log with long_query_time = 0... by Daniel Guzmán Burgos | Sep 16, 2015 | Insight for DBAs, MySQL, Webinars
Thanks to all who attended my webinar Introduction to MySQL SYS Schema. This blog is for me to address the extra questions I didn’t have time to answer on the stream. Can i have the performance_schema enabled in 5.6 and then install the sys schema? Or they are... by Daniel Guzmán Burgos | Dec 10, 2014 | Insight for DBAs, MySQL
Disclaimer: Reset the MySQL root password at your own risk! It doesn’t apply if you’re using Pluggable authentication and certainly won’t be usable if/when MySQL system tables are stored on InnoDBWhat is the situation? The situation is the... by Daniel Guzmán Burgos | Nov 12, 2014 | Insight for DBAs, MariaDB, MySQL, Percona Software
Did your logging stop working after you set up logrotate? Then this post might be for you.Some time ago, Peter Boros wrote about Rotating MySQL Slow Logs safely, explaining the steps of a “best practice” log rotate/archive. This post will add more info...