Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2008
    Posts
    456

    Alert for mysql table issues?

    I'm looking for a monitoring solution that will check mysql tables for corruption and send an alert if anything is detected.

    I'm currently using monit / mmonit but what I probably need is a mysql integrity check script I can run on a cron schedule w/ an email notification.

    Any ideas or known solutions?
    Server Administration and Management

  2. #2
    Join Date
    Apr 2009
    Location
    Islamabad , pakistan
    Posts
    128
    No such scripts/utilities are available yet. All you can do is write a custom script to check the integrity of tables. Surely, it might extensive scripting knowledge.
    Aun Muhammad Raza
    Linux System Administrator
    Personal Web: http://linuxpitstop.com

  3. #3
    Join Date
    Jun 2011
    Location
    Woodbridge, NJ
    Posts
    840
    MySQL should not be frequently corrupting tables. If it happens so often that you want to set up monitoring for data corruption, there are most likely bigger problems that need to be addressed.

  4. #4
    You could use simple Python script for instance, and run CHECK TABLE on each table in a cycle. But note that during check the tables will be locked. So if there're big tables you won't be able to write there. It's just for MyISAM tables. InnoDB does not crash often and it's quite hard not to be aware of InnoDB tables issues. MySQL may not even start.
    supportex.net: Linux server management services
    setup, optimization, monitoring

  5. #5
    Join Date
    Mar 2003
    Location
    Jaipur, India
    Posts
    643
    Hi,

    try to use this :-

    innodb_force_recovery = 5

    service mysqld restart
    RackNap
    Business Automation Platform for Web Hosting and Cloud Solution Providers

  6. #6
    Join Date
    Apr 2004
    Location
    Pacific Palisades, CA
    Posts
    3,641
    What about using "myisamchk," which ship with MySQL? This tool can scan your databases, identify problems, optimize tables for faster lookup, and optionally repair corrupted tables.
    Collabora Hosting - Unlimited Windows and Linux Hosting
    Web Security - VPS - Dedicated Servers
    Cloud and Managed WordPress Hosting
    Read how we do Unlimited Hosting at the Unlimited FAQ

Similar Threads

  1. Need Help: Displaying 3 Mysql Table into 1 Multidimensional HTML Table
    By WitchSoft in forum Programming Discussion
    Replies: 20
    Last Post: 08-22-2011, 08:05 PM
  2. MySQL: Copy specific fields from Table A into Table B
    By damainman in forum Programming Discussion
    Replies: 4
    Last Post: 09-28-2010, 05:19 PM
  3. Sorting a table by the results of another table (MySQL/PHP)
    By jon31 in forum Programming Discussion
    Replies: 4
    Last Post: 07-10-2007, 07:51 PM
  4. Synchronize MSSQL Table (DB) with a MySQL Table (DB)
    By kalinga in forum Hosting Security and Technology
    Replies: 0
    Last Post: 03-26-2006, 12:58 AM
  5. Please help with table issues
    By donxyz in forum Web Site Reviews
    Replies: 8
    Last Post: 01-30-2003, 10:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •