Setting up a basic monitoring system can be used to alert for certain thresholds, like 95% full volumes for example. WIth some simple shell scripting it can alert for InnoDB tablespace getting full as well.
Examples of monitoring systems: Nagios (Freeware), Argus (Freeware), HP Openview (Lots of money, maybe overkill but I mention it as you seem to run HPUX) Hope it helps Peter On Tue, 2007-01-30 at 14:59 +0530, Nishant Gupta wrote: > Hello All > > While my mysql code was running, the disk where the database was present got > full and wht happened was tht the process hanged. It would not return from > the query. N in the log file it was showing > 070130 10:22:47 [ERROR] > /usr/local/mysql-max-5.0.27-hpux11.11-hppa2.0w-64bit/bin/mysqld: > Disk is full writing './diameter/audit_table.MYD' (Errcode: 28). Waiting for > someone to free space... Retry in 60 secs > So my ques is/are: > Is there any alternative that I can come to know beforehand that the disk is > full so that i don't fire a query? > At the time of connection or creating a table can I tell the server to stop > accepting queries once the DB reaches a threshold (in terms of size/queries) > > Or any other alternative so that the at least the control returns to my code > where i can handle this situation! > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
