Thank you David and Sebastion, I am not doing this in a transaction (at least, I did not do anything special to start a transaction) and I have no need for a transaction.
How do I check the log files you two suggest? Thanks, Siegfried -----Original Message----- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 8:10 PM To: Siegfried Heintze; mysql@lists.mysql.com Subject: RE: Where did my disk space go? 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
