2 messages in com.mysql.lists.mysqlRe: Disk Space Full| From | Sent On | Attachments |
|---|---|---|
| Nishant Gupta | 30 Jan 2007 01:29 | |
| Pet...@ MySQL | 30 Jan 2007 18:18 |
| Subject: | Re: Disk Space Full |
|---|---|
| From: | Pet...@ MySQL (mys...@ourvirtualhome.com) |
| Date: | 01/30/2007 06:18:36 PM |
| List: | com.mysql.lists.mysql |
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!