With the release of MySQL 8 I wanted to paste my tuned my.cnf (MySQL configuration file) for discussion, suggestions, and questions. To get the most out of your MySQL 8 installation, you will need to configure it correctly and tune the settings for your specific use case. In this blog post, we will discuss my […]
MySQL Database Performance: Avoid this common mistake
One frequent topic of support request emails I receive is MySQL database performance. Clients complain about MySQL using too much server memory, too many MySQL slow queries, the famous Mysql server has gone away errors, and many other MySQL performance-related issues. As such, I wanted to share solutions to some common MySQL configuration mistakes. If […]
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 […]
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 […]