List:General Discussion« Previous MessageNext Message »
From:Siegfried Heintze Date:August 4 2005 2:57pm
Subject:RE: Where did my disk space go?
View as plain text  
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:David.Logan@stripped] 
Sent: Wednesday, August 03, 2005 8:10 PM
To: Siegfried Heintze; mysql@stripped
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:siegfried@stripped] 
Sent: Thursday, 4 August 2005 10:00 AM
To: mysql@stripped
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/mysql?unsub=1


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12aJason Pyeron4 Jul
  • Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12aGleb Paharenko4 Jul
    • Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12aJason Pyeron4 Jul
      • Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12aGleb Paharenko5 Jul
        • Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12aJason Pyeron5 Jul
        • Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12aJason Pyeron5 Jul
      • Documentation on Like clauseSiegfried Heintze22 Jul
        • Re: Documentation on Like clausePaul DuBois23 Jul
          • How to use Like Clause in Perl? Works fine in MySQL control center!Siegfried Heintze23 Jul
            • Re: How to use Like Clause in Perl? Works fine in MySQLcontrol center!Frank Bax23 Jul
              • Alternatives to performing join on normalized joins?Siegfried Heintze24 Jul
                • Re: Alternatives to performing join on normalized joins?SGreen25 Jul
                  • RE: Alternatives to performing join on normalized joins?Siegfried Heintze26 Jul
                    • How to select first 1000 records like MySQL Control Center 0.9?Siegfried Heintze26 Jul
                      • Re: How to select first 1000 records like MySQL Control Center 0.9?Peter Brawley26 Jul
            • Re: How to use Like Clause in Perl? Works fine in MySQL control center!Jeremiah Gowdy25 Jul
RE: How to use Like Clause in Perl? Works fine in MySQL control center!John Trammell25 Jul
  • Where did my disk space go?Siegfried Heintze4 Aug
    • Re: Where did my disk space go?Sebastian4 Aug
      • RE: Where did my disk space go?Siegfried Heintze4 Aug
  • Re: How to use Like Clause in Perl? Works fine in MySQL control center!Nuno Pereira8 Aug
RE: Where did my disk space go?SST - Adelaide)4 Aug
  • RE: Where did my disk space go?Siegfried Heintze4 Aug
    • RE: Where did my disk space go?David Logan4 Aug
      • How to delete log files? Was: RE: Where did my disk space go?Siegfried Heintze5 Aug
        • Re: How to delete log files? Was: RE: Where did my disk space go?Gleb Paharenko5 Aug
RE: How to delete log files? Was: RE: Where did my disk space go?SST - Adelaide)5 Aug
  • RE: How to delete log files? Was: RE: Where did my disk space go?Ron Thomas5 Aug
RE: How to use Like Clause in Perl? Works fine in MySQL control center!John Trammell8 Aug