Hi Siegfried,

I would check your transaction logs. Are you doing this as one giant
transaction? The system may be filling up the logs just in case you need
to rollback.

Regards

David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax


-----Original Message-----
From: Siegfried Heintze [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 August 2005 10:00 AM
To: mysql@lists.mysql.com
Subject: Where did my disk space go?

I've been using Perl 8.4+ (ActiveState) on WinXP. My program runs for
many
(> 20) hours issuing SQL UPDATE and DELETE commands. The update commands
should not be increasing the storage requirements, I'm just updating
integer
values.

I've noticed several times now that I run out of disk space. I started
with
a gigabyte free. Last time, I aborted the program, compressed my disk,
retrieved much lost disk space and started again.

Now I tried that again: no luck. I rebooted and recompressed again. I'm
still out of disk space.

It seems that MySQL just keeps using more and more disk space.

How can I retrieve my lost disks pace?

Thanks,
Siegfried


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to