Tag Archives: mysql

100+ Top Server Monitoring & Application Monitoring Tools

Last Update: May 16th 2018, 100+ December 1st 2017 update: 70 100 Top Server Monitoring & Application Monitoring Tools. August 6th 2017 update: 50 70 Top Server Monitoring & Application Monitoring Tools. Back in 2014, I compiled a list of the top 20 server performance monitoring solutions. Largely because I already had a list saved locally for my own reference. Sharing that […]

Avoid This When Tuning MySQL Query Cache for Performance

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 to be that more is better. Since the server has free RAM available, setting MySQL Query Cache […]

MySQL Performance: Stop hoarding. Drop unused MySQL databases

Last week I was assisting a new client in addressing MySQL performance issues. Although there were several areas where MySQL performance and throughput were increased, one issue overlooked for years and throughout several migrations was that of keeping around unused databases. In this case, with 64GB of RAM there was over 15GB of unused MySQL […]

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 […]

Linux server performance: Is disk I/O slowing your application?

If your Linux server is bogged down, your first step is often to use the TOP command in terminal to check load averages and wisely so. However, there are times when TOP shows very high load averages even with low cpu ‘us’ (user) and high cpu ‘id’ (idle) percentages. This is the case in the video below, load averages […]

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 […]

Memcache PHP Extensions for Memcached Caching Daemon

Memcached (Memcache Daemon) is a caching daemon designed especially for dynamic web applications to decrease database load by storing objects in memory. It is commonly used to speed up dynamic database-driven websites by caching data and objects in server memory to reduce the number of times the data source must be read. Memcached is free and open-source software, […]

20 Top Server Monitoring & Application Performance Monitoring (APM) Solutions

UPDATE: 50 Top Server Monitoring & Application Performance Monitoring (APM) Solutions Back in September I wrote about an article than touched on the subject of server performance monitoring.  Then just last month a LinkedIn connection asked: “I am using New Relic to monitor my cloud servers but need an alternative. Any suggestions?” I wanted to share and […]

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 […]