Advertisement:

Author Topic: Linux: automatic monitoring for table crashes ?  (Read 2277 times)

Offline aegersz

  • SMF Hero
  • ******
  • Posts: 1,462
  • Gender: Male
  • "mods" junkie
    • dopetalk
Linux: automatic monitoring for table crashes ?
« on: August 29, 2017, 10:38:31 PM »
I was wondering how best to do this in Linux, I came up with this:

curl of the website and grep for crash and table.

send email to my phone.

any better suggestions ?
The configuration of my Linux VPS (SMF 2.0 with 140+ mods) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,644
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Linux: automatic monitoring for table crashes ?
« Reply #1 on: August 30, 2017, 08:37:07 AM »
Check the mysql error log with a cron script.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 69,629
    • StoryBB/StoryBB on GitHub
Re: Linux: automatic monitoring for table crashes ?
« Reply #2 on: August 30, 2017, 01:52:02 PM »
Switch to InnoDB tables, problem goes away... ;)
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 aegersz

  • SMF Hero
  • ******
  • Posts: 1,462
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: Linux: automatic monitoring for table crashes ?
« Reply #3 on: August 31, 2017, 09:01:23 AM »
@vbgamer45, that is a much better idea ... and i didn't even have logging activated ! thanks.

@Arantor, in progress ... a great idea also. thanks, also.
The configuration of my Linux VPS (SMF 2.0 with 140+ mods) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum)