Re: How to delete log files? Was: RE: Where did my disk space go?

- From: David Logan [mailto:[EMAIL PROTECTED] Sent: Thursday, August 04, 2005 3:33 PM To: Siegfried Heintze Cc: mysql@lists.mysql.com Subject: RE: Where did my disk space go? Hi Siegfried, In the mysql data directory, -rw-rw1 mysqlmysql 358975 Mar 10 14

RE: Where did my disk space go?

- 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

RE: Where did my disk space go?

I did the following from the Cygwin bash prompt on WinXP Pro. cd /c/mysql find . -size -10M | xargs ls -l I only found one file greater than 10 megabytes. I'm looking for several hundred megabytes. Thanks, Siegfried -- MySQL General Mailing List For list archives:

RE: Where did my disk space go?

, 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

How to delete log files? Was: RE: Where did my disk space go?

] Sent: Thursday, August 04, 2005 3:33 PM To: Siegfried Heintze Cc: mysql@lists.mysql.com Subject: RE: Where did my disk space go? Hi Siegfried, In the mysql data directory, -rw-rw1 mysqlmysql 358975 Mar 10 14:28 aaudbasa01.log -rw-rw1 mysqlmysql 25088 Feb 15 08

RE: How to delete log files? Was: RE: Where did my disk space go?

: Friday, 5 August 2005 8:46 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: How to delete log files? Was: RE: Where did my disk space go? David (and anyone else): Here is the directory of my data directory. I don't see hundreds of mega bytes here, but deleting ib_logfile* and ibdata1 would

RE: How to delete log files? Was: RE: Where did my disk space go?

Subject RE: How to delete log files? Was: RE: Where did my disk space go

Re: Where did my disk space go?

you checked your log sizes? Siegfried Heintze wrote: 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

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 -