Topic: Database locks up (mariadb)
iRedMail version: 1.6.2 MARIADB edition, deployed with downloadable installer. Running ubuntu 22.04, Nginx.
Can't seem to figure out how often this happens, but occaisionally the database will lock up. I can only show a process list, which has about 80-100 processes, all stuck on a query. The result is that the web interfaces don't load and no IMAP connections can be made - not great for an email server. I can't think of why this is happening and some ideas would be appreciated. Happy to provide whatever logs may be needed
----Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.