Thank You Like - Recount very slow

[lost puppy]

Oh, it's MariaDB rather than MySQL. Unfortunately, I can't find any MariaDB-specific documentation about access rights on the INFORMATION_SCHEMA database.

Let's check whether you can at least alter the YOURPREFIX_threads table to add the tyl_tnumtyls column, since we already know it doesn't exist yet. Does this query complete successfully with YOURPREFIX replaced again?

ALTER TABLE YOURPREFIX_threads ADD tyl_tnumtyls int(100) NOT NULL default '0';

Yes my friend .... worked perfectly and the column is now in the threads table