Enable slow query log without restarting MySQL / MariaDB server
We noticed load on one of our production servers recently and had to enable slow…
We used the following command to dump the databases into a single dump file:
We looked around and found a reference on Stack Overflow. The answer suggests this database is scheduled to be used in MariaDB 10.5 and shouldn’t be on hosts with lower versions, the solution is as simple as dropping the database “sys”.
You are about to delete a database from your server, make sure you have backups of your important databases before you proceed.
Login to MySQL and issue the following command: