Especially if all queries are unacceptably slow under heavy load, your DB is probably under-resourced. Is it a shared or dedicated server? How much RAM? If you are mainly using innodb, what is innodb_buffer_pool_size? Have you looked at the result of Show Eingine InnoDB Status when the system is slow?
You could try running some of the metrics under "optimisation cheatsheet" at https://www.artfulsoftware.com/infotree/mysqltips.php
, esp. the measures of load,
query inefficiency, and InnoDB efficiency, and post those results here.
But there are many incompatibilities between MariaDB 10.4 and the most similar MySQL version (8.0, https://mariadb.com/kb/en/incompatibilities-and-feature-differences-between-mariadb-104-and-mysql-80/
). Performance metrics designed for MySQL may be less useful on MariaDB. so I think you're best off asking on the MariaDB site.
Edited 1 time(s). Last edit at 06/02/2022 09:54AM by Peter Brawley.