Search results: mysql

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

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

LEMP Raspberry Pi 2 Web Server – Arch Linux, Nginx, MariaDB (MySQL) & PHP

Download the Latest LEMP Raspberry Pi 2 Web Server Image To Do: – Update my.cnf for RPi2 (1G of memory) and enable InnoDB by default. – Fix broken PHP modules. (gd, imap and mcrypt) Change log 09-16-2015 – Fixed sshd root access and enabled autostart of sshd on boot. 09-12-2015 – Tested image on 3 different Raspberry […]

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 (LEMP) AMI – CentOS, Nginx, MySQL & PHP-FPM

NOTE: I’ve moved all of my web sites from AWS. Also, this Free Nginx AMI is no longer supported and has been merged into Nginx’s official AMI. For most, there are better hosting options available in terms of performance & cost. Ask me about StackLinux SSD hosting. This Amazon EC2 AMI includes the latest Amazon Linux (Centos), […]

htop: Here’s how to customize it

htop is an interactive system-monitor, but also a process-viewer, process-manager, strace tool and more. Sysadmins may opt to use htop in cases where Unix top does not provide enough information about system processes. htop uses a cursor-controlled interface for sending signals to processes. Just one example where this comes in handy: you don’t have to type […]

100+ Server Monitoring & Application Performance Monitoring Solutions

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