Re: How to delete log files? Was: RE: Where did my disk space go?
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 mkpasswd0 Jul 30 23:07 hotjobs -rw-r--r-- 1 Administrator mkpasswd25,088 Mar 4 18:05 ib_arch_log_00 -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 mkpasswd0 Mar 4 18:02 mysql -rw-r--r-- 1 Administrator mkpasswd53,127 Aug 3 17:52 sales.err drwxr-xr-x 1 Administrator mkpasswd0 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-rw1 mysqlmysql 358975 Mar 10 14:28 aaudbasa01.log -rw-rw1 mysqlmysql 25088 Feb 15 08:08 ib_arch_log_00 -rw-rw1 mysqlmysql 5242880 Jun 22 11:20 ib_logfile0 -rw-rw1 mysqlmysql 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:
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 mkpasswd0 Jul 30 23:07 hotjobs -rw-r--r-- 1 Administrator mkpasswd25,088 Mar 4 18:05 ib_arch_log_00 -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 mkpasswd0 Mar 4 18:02 mysql -rw-r--r-- 1 Administrator mkpasswd53,127 Aug 3 17:52 sales.err drwxr-xr-x 1 Administrator mkpasswd0 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-rw1 mysqlmysql 358975 Mar 10 14:28 aaudbasa01.log -rw-rw1 mysqlmysql 25088 Feb 15 08:08 ib_arch_log_00 -rw-rw1 mysqlmysql 5242880 Jun 22 11:20 ib_logfile0 -rw-rw1 mysqlmysql 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] -- 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to delete log files? Was: RE: Where did my disk space go?
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:[EMAIL PROTECTED] Sent: 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 sure help. Which of these files I can delete without loosing any data from my database? drwxr-xr-x 1 Administrator mkpasswd0 Jul 30 23:07 hotjobs -rw-r--r-- 1 Administrator mkpasswd25,088 Mar 4 18:05 ib_arch_log_00 -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 mkpasswd0 Mar 4 18:02 mysql -rw-r--r-- 1 Administrator mkpasswd53,127 Aug 3 17:52 sales.err drwxr-xr-x 1 Administrator mkpasswd0 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-rw1 mysqlmysql 358975 Mar 10 14:28 aaudbasa01.log -rw-rw1 mysqlmysql 25088 Feb 15 08:08 ib_arch_log_00 -rw-rw1 mysqlmysql 5242880 Jun 22 11:20 ib_logfile0 -rw-rw1 mysqlmysql 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
RE: How to delete log files? Was: RE: Where did my disk space go?
One thing to remember about *nix, is that disk space is not released until all processes that had a file open have closed it. For example, if a process has a 2Gb file open, and another process rm's the file, an ls will show that file as gone but the disk space is not released until the first process has closed the file. Been bit by this a few times. Could this be the case here? Thanks, Ron. The software said to install Windows 98 or better... So I installed linux. Friends don't let friends use IE [EMAIL PROTECTED] 08/04/05 04:29 PM To [EMAIL PROTECTED], [EMAIL PROTECTED] cc mysql@lists.mysql.com Subject RE: How to delete log files? Was: RE: Where did my disk space go? 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:[EMAIL PROTECTED] Sent: 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 sure help. Which of these files I can delete without loosing any data from my database? drwxr-xr-x 1 Administrator mkpasswd0 Jul 30 23:07 hotjobs -rw-r--r-- 1 Administrator mkpasswd25,088 Mar 4 18:05 ib_arch_log_00 -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 mkpasswd0 Mar 4 18:02 mysql -rw-r--r-- 1 Administrator mkpasswd53,127 Aug 3 17:52 sales.err drwxr-xr-x 1 Administrator mkpasswd0 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
