MySQL Troubleshooting with pt-stalk: Part 2
In our last post, we showed you how to use pt-stalk to help gather a bunch of data that can be used for troubleshooting. But what type of data does it collect? How do we...
MySQL Troubleshooting with pt-stalk: Part 1
In our previous posts, we have covered different log files and how to use them to troubleshoot MySQL, but that is not all that MySQL has to offer. But what do you do when the...
Webinar Replay: Performing Live Database Upgrades in Replication & Clustered Setups
Thanks to everyone who joined us for our recent live webinar on performing live database upgrades for MySQL Replication & Galera, led by Krzysztof Książek. The replay and slides to the webinar are now available...
A Guide to Max Open Files for MySQL
Requires ClusterControl 1.2.11 or later. Applies to MySQL single instances, replications and Galera clusters. You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a...
Understanding the MySQL Galera Cluster and MariaDB Cluster Diagnostic Logs
In a previous post, we discussed the error log as a source of diagnostic information for MySQL. We’ve shown examples of problems where the error log can help you diagnose issues with MySQL. This post...
Webinar Replay: Deploying MongoDB, MySQL, PostgreSQL & MariaDB’s MaxScale in 40min
Live demo recording of ClusterControl 1.2.11 and its new features Thanks to everyone who joined us for our recent live webinar on ‘ClusterControl 1.2.11 - new release’ led by Art van Scheppingen , Senior Support...
Understanding the MySQL Error Log
We are yet to see a software that runs perfectly, without any issues. MySQL is no exception there. It’s not the software’s fault - we need to be clear about that. We use MySQL in...
A Guide to MySQL User Management
Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. In this example we will look at how you can use ClusterControl to create a user and assign privileges to the user. We will create...
Updating Your MySQL Configuration
Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. From time to time it is necessary to tune and update your configuration. Here we will show you how you can change/update individual parameters using the...
Optimizer Hints for Faster MySQL Query Execution
MySQL uses a cost-based optimizer to determine the best way to execute a query. It usually does a great job, but not all the time. There are different reasons for that. In some cases, it...
Using Explain to Improve SQL Query Performance
When it comes to the query tuning, EXPLAIN is one the most important tool in the DBA’s arsenal. Why is a given query slow, what does the execution plan look like, how will JOINs be...
Webinar Replay: Replication Topology Changes for MySQL
Thanks to everyone who joined us for our recent live webinar on ‘Replication Topology Changes for MySQL and MariaDB’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar...