• Welcome to Simple Machines Community Forum. Please login or sign up.
September 22, 2021, 02:29:24 PM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) 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?

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.
No good deed goes unpunished
All helpful urges should be circumvented

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: