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
mariadb
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…
Kopano Server Memory Optimization Exercise
Kopano servers need memory optimization. There is an entire chapter written about it here: https://documentation.kopano.io/kopanocore_administrator_manual/performance_tuning.html Unfortunately Kopano open source is dead and they left their
Whilst restoring a MariaDB Backup from one Virtualmin server to another, MySQL create and grant errors
Background On a legacy server with an older version of MariaDB, restoring to a newer Virtualmin server that run MySQL 8 might be problematic. The
MySQL Check All Databases
Background Having a broken MySQL / MariaDB database is no fun. Broken tables can also lead to half complete backups really compounding the situation and
How to allocate more RAM to MariaDB/MySQL on a shared server and increase the connection count
Background If you have a server with sufficient RAM but you are running out of MySQL connections, you might want to look at two easy
How to upgrade for MariaDB 5.5 to 10.1 and then to 10.3
You might encounter a situation (e.g. on AWS) where you have a new CentOS 7 server, but an old version of MariaDB 5.5 on the
MySQL stops working: InnoDB: Fatal error: cannot allocate memory for the buffer pool
Background A MySQL server stop working. You’re confused as this is a new Virtualmin installation and everything went smooth. You start troubleshooting: # service mariadb
How do you rename a MySQL table?
rename table t1 to t2; Reference: https://blog.marceloaltmann.com/en-how-to-rename-table-in-mysql-pt-como-renomear-tabelas-no-mysql/
How to upgrade MariaDB from 10.1 to 10.3 Ubuntu Bionic (18.04) LTS Server
Background This article explains how to upgrade the default MariaDB 10.1 installation provided with Linux Mint 19 Tara or Tessa to MariaDB 10.3. One reason