Hello.
About deleting the InnoDB log files see: http://dev.mysql.com/doc/mysql/en/adding-and-removing.html > Now what about this my.cnf file? As I recall, this file lives in the top Program options could be passed in different ways. You can add your specific options (for example InnoDB parameters) in configuration file. Create it from one of the templates if it doesn't exist. See: http://dev.mysql.com/doc/mysql/en/program-options.html http://dev.mysql.com/doc/mysql/en/option-files.html "Siegfried Heintze" <[EMAIL PROTECTED]> wrote: > 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:[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-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:[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] >> >> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
