• Welcome to Simple Machines Community Forum. Please login or sign up.
September 27, 2021, 12:37:12 PM


SMF 2.0.18 has been released! Please update. Read more.

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?



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"


I cannot find the string 'check table' in any unmodified 1.1 or 2.0 installation.
No good deed goes unpunished
All helpful urges should be circumvented


"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.