Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Mysql Repair Cron

forums › forums › SQLyog › Using SQLyog › Mysql Repair Cron

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 7, 2006 at 10:05 am #9470
      energylevel
      Member

      There doesn't really seem to be a most appropriate forum for this question, so I am asking here hope you don't mind..

      I'd like some help with setting up a MySQL optimise and repair tools CRON on a Linux server for a database that seems to get corrupt tables every now and then

    • February 7, 2006 at 10:12 am #20469
      peterlaursen
      Participant

      You can use a SJA 'Notifications Service' Job for this.

      Just execute a statement like

      Code:
      repair  table `test`.`t1`;

      with that 'Notifications Job' and schedule that job with CRON.

      Further you can repair manually from SQLyog .. tools .. table diagnostics. When it is done like this you can copy the SQL to use with SJA from the HISTORY pane.

    • February 7, 2006 at 12:04 pm #20470
      peterlaursen
      Participant

      But maybe it was better to find the reason for that corruption and eliminate that reason? Such corruption probably is corruption of indexes. Corrupted indexes could lead to corruption of data themselves.

      Appropriate use of LOCK's, FLUSH's etc. with the scripts could be the way out …

      And you could insert a Check table tablename in the scripts and 'pick up' the server response (variable 'Msg_text'). If it is not 'OK' then you found the place where things start to go wrong.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.