Re: how to switch off logging?

Michael Dykman Thu, 15 Jul 2004 08:58:45 -0700

Those logs are not the kind of logs you are thinking of.. these are DB logs which maintaining a running record of each insert/update transaction for internal use by the DB.. The size can be changed in my.cnf, but they are critical to the proper functioning of the database and resizing them will affect mysql performance.

 - michael dykman
 - [EMAIL PROTECTED]

J S wrote:

Hi,
I would like to switch off the logging that creates the large files below (in the mysql data directory) Could someone tell me how to do this please?
Thanks,
js.
# ls -l total 5418648 -rw-rw---- 1 mysql mysql 25088 Jun 28 14:27 ib_arch_log_0000000000 -rw-rw---- 1 mysql mysql 5242880 Jun 29 11:47 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Jun 28 14:27 ib_logfile1 -rw-rw---- 1 mysql mysql 10485760 Jun 29 11:47 ibdata1 -rw-rw---- 1 mysql mysql 2345 Jun 30 17:28 innodb.status.21716 -rw-rw---- 1 mysql mysql 2345 Jun 28 15:37 innodb.status.4980 -rw-rw---- 1 mysql mysql 2345 Jun 28 20:32 innodb.status.5022 -rw-rw---- 1 mysql mysql 2345 Jun 28 21:49 innodb.status.58892 drwxr-s--- 2 mysql mysql 512 Jun 28 14:24 mysql drwx--S--- 2 mysql mysql 1024 Jun 30 13:50 proxy_logs -rw-rw---- 1 mysql mysql 1074696691 Jun 30 15:09 rsl156-bin.001 -rw-rw---- 1 mysql mysql 1073819496 Jun 30 17:22 rsl156-bin.002 -rw-rw---- 1 mysql mysql 604547777 Jun 30 17:27 rsl156-bin.003 -rw-rw---- 1 mysql mysql 51 Jun 30 17:22 rsl156-bin.index -rw-rw---- 1 mysql mysql 8596 Jun 30 14:03 rsl156.err -rw-rw---- 1 mysql mysql 6 Jun 29 11:46 rsl156.pid drwxr-s--- 2 mysql mysql 512 May 14 10:54 test # pwd /proxydb/mysql/data

_________________________________________________________________ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to switch off logging?

Reply via email to