Results 1 to 6 of 6
Thread: Alert for mysql table issues?
-
07-18-2012, 05:22 PM #1Web Hosting Evangelist
- 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
-
07-18-2012, 07:25 PM #2WHT Addict
- 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.
-
07-19-2012, 04:45 AM #3(formerly WhichGunDotCom)
- 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.
-
07-19-2012, 09:11 AM #4WHT Addict
- Join Date
- Feb 2002
- Posts
- 121
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
-
07-19-2012, 11:49 AM #5Web Hosting Master
- Join Date
- Mar 2003
- Location
- Jaipur, India
- Posts
- 643
Hi,
try to use this :-
innodb_force_recovery = 5
service mysqld restartRackNap
Business Automation Platform for Web Hosting and Cloud Solution Providers
-
07-19-2012, 12:23 PM #6Web Hosting Master
- 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
-
Need Help: Displaying 3 Mysql Table into 1 Multidimensional HTML Table
By WitchSoft in forum Programming DiscussionReplies: 20Last Post: 08-22-2011, 08:05 PM -
MySQL: Copy specific fields from Table A into Table B
By damainman in forum Programming DiscussionReplies: 4Last Post: 09-28-2010, 05:19 PM -
Sorting a table by the results of another table (MySQL/PHP)
By jon31 in forum Programming DiscussionReplies: 4Last Post: 07-10-2007, 07:51 PM -
Synchronize MSSQL Table (DB) with a MySQL Table (DB)
By kalinga in forum Hosting Security and TechnologyReplies: 0Last Post: 03-26-2006, 12:58 AM -
Please help with table issues
By donxyz in forum Web Site ReviewsReplies: 8Last Post: 01-30-2003, 10:29 AM