Search results: mysql

“MySQL server has gone away” error – Solution(s)

MySQL server has gone away error means that MySQL server (mysqld) timed out and closed the connection. By default, MySQL will close connections after eight hours (28800 seconds) if nothing happens. However, in some cases your web host, DBA or app developer may have decreased this timeout setting, discussed below. MySQL server has gone away, can be […]

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

Caution: Don’t overwrite my.cnf all at once. Backup data and config, make one or two changes per restart, test extensively. 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. MariaDB is an enhanced drop-in replacement […]

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

MySQL Performance: Stop hoarding. Drop unused MySQL databases

Last year, I was assisting a new client in addressing MySQL performance issues. There were several areas where MySQL performance issues were addressed. One issue overlooked for several years prior to our communications, was that of keeping around unused databases. Over 15GB of unused MySQL data – a mix of MyISAM and Innodb tables – […]

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

Download LEMP for Raspberry Pi: Nginx + MariaDB (MySQL) + PHP

Download latest image: https://sourceforge.net/projects/lemp-raspberry-pi/files/latest/download Change log 07-16-2014 – After today’s changes RAM usage on first boot is down to <100mb. 07-16-2014 – Set most logs to save to memory instead of SD card. (up to 10M or 1 day max) 07-16-2014 – Reduced system log level from “info” to “warning”. Reduce SD contention. 07-16-2014 – Uninstalled ntpd daemon. Replaced […]

Free Nginx AMI (LEMP) – CentOS, Nginx, MySQL & PHP-FPM

Note: This Free Nginx AMI has been merged into Nginx’s official AMI. This Amazon EC2 AMI includes the latest Amazon Linux (Centos), Nginx 1.0.15, MySQL 5.1 & PHP 5.4 (PHP-FPM) custom installed and tuned for stability and speed. Screenshot of top stats. This free Nginx AMI is optimized and runs fast even on t1.micro. To […]

100 Top Server Monitoring & Application Performance Monitoring Solutions

Last Updated: July 19th 2019. November 29th 2018 – Site24x7 replaces Coscale. Coscale was recently acquired by New Relic.  Oct 11th 2018 update: 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 […]

Pruning Magento Cache & Sessions Using Cron

Note: Magento 1.x only. Over the weekend a client contacted me because they had serious performance issues with their Magento based store. The three main issues were: Checkout taking more than 30 seconds to complete after clicking to submit payment. (Causing double orders/payments and users just leaving the store) Login to the front or back end […]