MariaDB expert

This is the metadata lock. Before you waste your money, try raising wait_timeout and interactive_timeout variables, it's possible they are frequently timing out especially in multisite databases, thus causing the crashes. We can also create a cron task to kill old idle non-active connections Proposal: This is the metadata lock. Before you waste your money, try raising wait_timeout and interactive_timeout variables, it's possible they are frequently timing out especially in multisite databases, thus causing the crashes. We can also create a cron task to kill old idle non-active connections that sometimes keep the lock closed. The exact error is "Waiting for table metadata lock". If you still experience issues after raising these mariadb settings, feel free to contact me here or on chat and I will be more than happy to debug and get it fixed up.

Mention the list of steps you will follow to fix issue Issue : Table is being locked ,which means some / all table are MyISAM tables. If it is MyISAM , i would try to move it to InnoDB to avoid table locks. If the tables are not InnoDB, the tables are highly fragmented , i will need to extract the stats and fragmentation level and optimize them. Proposal: I have close to 14 years of experience in database technology and 5 years in MySQL / MariaDB. I have clients in Europe and in US who use my service to optimize MariaDB and MariaDB on Galera cluster. I have deep knowledge in optimizing MariaDB solution and i do bid only on interesting project such as this. In simple i would be glad to help you and if i am successful , i would send you invoice , if not this will be for free. Additionally i can provide architectural suggestion for NoSQL solutions too . Cheers

Mention the list of steps you will follow to fix issue Check indexes Check index locking Database performance testing Database tuning Proposal: I have experience with almost any open source database engines including Maria DB. Problem that you have described usually is caused by bad indexing in the database. Thats the first thing that should be checked. Also performance testing and tuning should be made