How to upgrade Mariadb Ver 10.x to 11.x on Debian 12 with Virtualmin – the nightmare
Background This article started off with as “how to upgrade MariaDB 10.11.14” on a fresh Debian 12 installation that also has Virtualmin on. I use
Databases
About restoring an InnoDB MySQL Database by “just copying files across”
Restoring a database was never going to be fun. When you’re working with MySQL you need quite a bit of background before you can even
Temporary fix for row size too large > 8126 on a Laravel Forge Ubuntu 24.04 server
On a Laravel Forge Ubuntu 24.04 server, you might experience the following issue whilst restoring a database: mysql -udb_user -p db_name < backup.sql mysql: Deprecated
Where is the mysql/mariadb configuration .cnf config file kept / stored
One super annoying thing about various versions of Linux is the MySQL configuration file can be in many different locations. Not only can the file
MySQL error – Could not increase number of max_open_files to more than 10000 (request: 40000)
Looking at a MySQL error log showed some interesting new errors. Here is the log file: 2025-02-23T06:43:15.664775Z 0 [Warning] [MY-010140] [Server] Could not increase number
MySQL strict mode causing loops and havoc on WHMCS domain renewals
You might find that some emails repeat, e.g. domain deletions emails. Here is how you troubleshoot: user@server:~$ /usr/bin/php8.1 -q /home/user/public_html/modules/registrars/domainsDotCOZA/tools/domains_sync.php –poll Processing Domain Deletions: —————————-
How to handle slow query logging on MariaDB
Sometimes once you have eliminated all bottlenecks, e.g. NVME and RAM and vCPUs, then all that is left is to check the database. I like
Isolating disk write performance problems on heavy loaded shared hosting WordPress servers
Background On a heavy loaded WordPress server you might experience the following when looking at iotop. Heavy writes. Additional graphing of the disk’s writes might
MariaDB suspicious Access denied during `debian-start` and then FATAL ERROR: Upgrade failed
On a seemingly working server you may encounter the following checking out the mysql status: Jun 15 10:32:33 host systemd[1]: Starting MariaDB 10.3.39 database server…
Problems with MySQL table optimisation
Example: mysql> optimize table wp_actionscheduler_actions; +——————————————-+———-+———-+——————————————————————-+ | Table