List:General Discussion« Previous MessageNext Message »
From:David (SST - Adelaide) Logan Date:August 4 2005 11:29pm
Subject:RE: How to delete log files? Was: RE: Where did my disk space go?
View as plain text  
Hi Siegfried,

There is a section on each of the log files. I wouldn't go deleting the
log files without understanding exactly what you are trying to do. Have
a read of the section I mentioned. The logfiles that you are showing in
your directory are only 5Mb each and won't be taking anything if you
have > 1Gb free. The files you are showing are for the InnoDB engine and
I can't tell if you are using it. The only databases I can see are
mysql, test and hotjobs. All the other files are well within the usual
sizes that I would expect.

The my.cnf file enables you to customise your installation to ensure
best performance for your application. We use replication a lot here at
work and have custom requirements for the servers so end up doing many
mods from the defaults. I don't use replication at home and so don't
have to modify much at all.

The .cnf files you mentioned are example files. Mysql does not require a
my.cnf file as it makes a number of default assumptions if it is not
there. 

The documentation at http://dev.mysql.com/doc/mysql/en/index.html goes
over all the different options that are available within the option
files. There are versions of the manual in other languages at
http://dev.mysql.com/doc/ HTH

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: Friday, 5 August 2005 8:46 AM
To: david@stripped
Cc: mysql@stripped
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 sure help.

Which of these files I can delete without loosing any data from my
database?

drwxr-xr-x  1 Administrator mkpasswd        0 Jul 30 23:07 hotjobs
-rw-r--r--  1 Administrator mkpasswd    25,088 Mar  4 18:05
ib_arch_log_0000000000
-rw-r--r--  1 Administrator mkpasswd  5,242,880 Aug  3 17:52 ib_logfile0
-rw-r--r--  1 Administrator mkpasswd  5,242,880 Mar  4 18:05 ib_logfile1
-rw-r--r--  1 Administrator mkpasswd 10,485,760 May  3 15:47 ibdata1
drwxr-xr-x  1 Administrator mkpasswd        0 Mar  4 18:02 mysql
-rw-r--r--  1 Administrator mkpasswd    53,127 Aug  3 17:52 sales.err
drwxr-xr-x  1 Administrator mkpasswd        0 Mar  4 18:02 test

Now what about this my.cnf file? As I recall, this file lives in the top
level directory. I have no such file. I found these files in the mysql
directory:

my-huge.cnf 
my-innodb-heavy-4G.cnf
my-large.cnf
my-medium.cnf
my-small.cnf

I don't recall editing any of these. Should I be editing them?


Thanks,

Siegfried

-----Original Message-----
From: David Logan [mailto:david@stripped] 
Sent: Thursday, August 04, 2005 3:33 PM
To: Siegfried Heintze
Cc: mysql@stripped
Subject: RE: Where did my disk space go?

Hi Siegfried,

In the mysql data directory,

-rw-rw----    1 mysql    mysql      358975 Mar 10 14:28 aaudbasa01.log
-rw-rw----    1 mysql    mysql       25088 Feb 15 08:08
ib_arch_log_0000000000
-rw-rw----    1 mysql    mysql     5242880 Jun 22 11:20 ib_logfile0
-rw-rw----    1 mysql    mysql     5242880 Feb 15 08:08 ib_logfile1

The above files maybe in slightly different places, it depends on
whether
you are using the InnoDB engine or the MyISAM one. The InnoDB logging
files are the ib_logfiles. You could also check the my.cnf for any form
of
logging being switched on, in particular binary logging.

You could check for this as well. This will be in your my.cnf file as

# Replication Master Server (default)
# binary logging is required for replication
log_bin

If so, you could be filling up your disk quite easily

Regards

> 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
David Logan
South Australia

when in trouble, or in doubt
run in circles, scream and shout


-- 
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