With MySQL, common configuration mistakes can create severe performance problems. If you misconfigure just one of the many config parameters, it can cripple performance. Of course, the performance of MySQL is often tied to the efficiency of your MySQL queries. It’s essential to ensure that your performance issues are not due to poorly written MySQL […]
Tuning MySQL my.cnf? Avoid this common pitfall!
It took me some time to decide on the title of this article. MariaDB has been fast replacing MySQL as many Linux distributions now default to MariaDB over MySQL. MariaDB is an enhanced drop-in replacement for MySQL. Therein lies my predominantly self-made conundrum, MySQL or MariaDB? The MySQL tuning advice below applies to MySQL, MariaDB […]
“MySQL server has gone away” error – Solution(s)
The MySQL server has gone away error, which means that the 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, as discussed below. MySQL […]
MySQL Performance Schema
When it comes to database performance monitoring and optimization, MySQL offers a powerful tool called Performance Schema. This versatile instrument provides invaluable insights into the inner workings of your MySQL database, enabling you to fine-tune its performance for optimal efficiency. In this installment of our series on MySQL database performance optimization, we delve into the […]
Could not increase number of max_open_files to more than… (Solution)
A quick solution to the warning “Could not increase number of max_open_files to more than” when starting MySQL or MariaDB. For some background, read How MySQL Opens and Closes Tables. Here’s an excerpt: “The table_open_cache and max_connections system variables affect the maximum number of files the server keeps open. If you increase one or both of […]
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 […]