MySQL Query Cache for Performance, Avoid This When Tuning

Update: MySQL query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. – mysql.com One of the most misconfigured MySQL performance features, is MySQL query_cache_size. This post references a web server with 32 gigabytes of RAM where the existing config had MySQL’s query cache size set incorrectly to 4 gigabytes. The thought behind it seemed […]

100 Server and Application Performance Monitoring Tools

Last Updated: Oct 11th 2018, 100+ – Fixed 11 broken links. (including defunct, mergers, acquisitions, or changed links) December 1st 2017 update: 70 100 Top Server Monitoring & Application Performance Monitoring Tools. August 6th 2017 update: 50 70 Top Server Monitoring & Application Performance Monitoring Tools. Back in 2014, I compiled a list of the top 20 server performance monitoring solutions. Largely because I […]

MySQL Performance Tuning: Tips, Scripts and Tools

With MySQL, common configuration mistakes can cause serious performance problems. In fact, if you mis-configure just one of the many config parameters, it can cripple performance! (see examples) Of course, the performance of MySQL is often tied greatly to the efficiency of your MySQL queries. It’s important to ensure that your performance issues are not […]

Tuning MySQL: my.cnf, avoid this common pitfall!

Caution: Don’t overwrite your entire my.cnf at once when tuning MySQL. One or two changes per restart, benchmark, then continue. Take backups first and be careful! It took me some time to decide the title for this article. MariaDB has been fast replacing MySQL as a growing number of Linux distributions now default to MariaDB over MySQL. In […]

cPanel to add MariaDB support. PHP-FPM?

This is just a quick note. This morning I received an email alert from cPanel as follows: “The status of the feature request: you were watching has changed to In Progress.“ This was in regards to the feature request for MariaDB support. It will be interesting to see how long this takes to be implemented.  Its […]