I don't really know what might have caused the slowdown. I'll ask around to see if any ideas come up.

I know this might be a bit tedious for you, but can you try with the latest MariaDB 5.5 and see if you get the same bad performance? You'll probably have to set-up a new datadir from the MySQL deployment.

MariaDB 5.5 should be very similar to MySQL 5.5. If we can narrow it down to a particular major version upgrade, it will be easier to track down where the slowdown happened. Probably analyzing performance logs could also hint towards a solution, but I have limited experience handling those.

Vicențiu

On Tue, 2 Jun 2020 at 14:12, Ling, Andy <Andy.Ling@grassvalley.com> wrote:

MariaDB is 10.4.12

 

MySQL is 5.5.34 – pretty old I know.

 

Regards

 

Andy Ling