Thank You Like - Recount very slow

[Laird]

"Curiouser and curiouser!" cried Alice.

What about if you run the sixth query immediately after that one (again, replacing the table prefix)?

SET @query = IF(@exist <= 0,
                "
                 ALTER TABLE YOURPREFIX_threads
                 ADD         tyl_tnumtyls int(100) NOT NULL default '0'
                ",
                "SET @dummy1 = 1"
               );