Advertisement:

Author Topic: What activates "CHECK TABLE smf_messages EXTENDED"  (Read 880 times)

Offline Biology Forums

  • SMF Hero
  • ******
  • Posts: 3,746
    • StudyForcePS on Facebook
    • @studyforceps on Twitter
What activates "CHECK TABLE smf_messages EXTENDED"
« on: September 07, 2019, 11:06:17 AM »
When this is running, suddenly, it slows everything down. What activates this query and what does it do?

Code: [Select]
CHECK TABLE smf_messages EXTENDED

Offline d3vcho();

  • Sempiterno
  • Lead Localizer
  • SMF Hero
  • *
  • Posts: 3,856
  • Gender: Male
    • frandominguez03 on GitHub
Re: What activates "CHECK TABLE smf_messages EXTENDED"
« Reply #1 on: September 07, 2019, 11:40:58 AM »
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."

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,598
    • StoryBB/StoryBB on GitHub
Re: What activates "CHECK TABLE smf_messages EXTENDED"
« Reply #2 on: September 07, 2019, 11:49:59 AM »
I cannot find the string 'check table' in any unmodified 1.1 or 2.0 installation.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline d3vcho();

  • Sempiterno
  • Lead Localizer
  • SMF Hero
  • *
  • Posts: 3,856
  • Gender: Male
    • frandominguez03 on GitHub
Re: What activates "CHECK TABLE smf_messages EXTENDED"
« Reply #3 on: September 07, 2019, 11:51:04 AM »
I couldn't either. Not even for 2.1.

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

Offline Biology Forums

  • SMF Hero
  • ******
  • Posts: 3,746
    • StudyForcePS on Facebook
    • @studyforceps on Twitter
Re: What activates "CHECK TABLE smf_messages EXTENDED"
« Reply #4 on: September 07, 2019, 01:14:16 PM »
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.