News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

What activates "CHECK TABLE smf_messages EXTENDED"

Started by Biology Forums, September 07, 2019, 11:06:17 AM

Previous topic - Next topic

Biology Forums

When this is running, suddenly, it slows everything down. What activates this query and what does it do?

CHECK TABLE smf_messages EXTENDED

d3vcho

It basically checks that table for errors. As it's using the EXTENDED clause, it will run (much) slower since it performs the check for each key in each row. I can't recall where that sentence is called from. Maybe some maintenance task.
"Greeting Death as an old friend, they departed this life as equals"

Arantor

I cannot find the string 'check table' in any unmodified 1.1 or 2.0 installation.

d3vcho

"Greeting Death as an old friend, they departed this life as equals"

Biology Forums

Thanks Fellas. I'm embarrassed to tell you that it was an ancient script I made that ran every 30 minutes as a CRON job that check to see any corruptions in the table. I've turned it off, thank you for your help.

Advertisement: