Re: how to switch off logging?
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 mysqlmysql 25088 Jun 28 14:27 ib_arch_log_00 -rw-rw 1 mysqlmysql5242880 Jun 29 11:47 ib_logfile0 -rw-rw 1 mysqlmysql5242880 Jun 28 14:27 ib_logfile1 -rw-rw 1 mysqlmysql10485760 Jun 29 11:47 ibdata1 -rw-rw 1 mysqlmysql 2345 Jun 30 17:28 innodb.status.21716 -rw-rw 1 mysqlmysql 2345 Jun 28 15:37 innodb.status.4980 -rw-rw 1 mysqlmysql 2345 Jun 28 20:32 innodb.status.5022 -rw-rw 1 mysqlmysql 2345 Jun 28 21:49 innodb.status.58892 drwxr-s--- 2 mysqlmysql512 Jun 28 14:24 mysql drwx--S--- 2 mysqlmysql 1024 Jun 30 13:50 proxy_logs -rw-rw 1 mysqlmysql1074696691 Jun 30 15:09 rsl156-bin.001 -rw-rw 1 mysqlmysql1073819496 Jun 30 17:22 rsl156-bin.002 -rw-rw 1 mysqlmysql60454 Jun 30 17:27 rsl156-bin.003 -rw-rw 1 mysqlmysql 51 Jun 30 17:22 rsl156-bin.index -rw-rw 1 mysqlmysql 8596 Jun 30 14:03 rsl156.err -rw-rw 1 mysqlmysql 6 Jun 29 11:46 rsl156.pid drwxr-s--- 2 mysqlmysql512 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?
You can stop creating the logs like rsl156-bin.00[123] (the bin logs) by commenting out the log-bin line in your my.cnf, and restarting mysql. You need them, though, if your server is a replication master. More on the logs here: http://dev.mysql.com/doc/mysql/en/Log_Files.html Jim Michael Dykman wrote: 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 mysqlmysql 25088 Jun 28 14:27 ib_arch_log_00 -rw-rw 1 mysqlmysql5242880 Jun 29 11:47 ib_logfile0 -rw-rw 1 mysqlmysql5242880 Jun 28 14:27 ib_logfile1 -rw-rw 1 mysqlmysql10485760 Jun 29 11:47 ibdata1 -rw-rw 1 mysqlmysql 2345 Jun 30 17:28 innodb.status.21716 -rw-rw 1 mysqlmysql 2345 Jun 28 15:37 innodb.status.4980 -rw-rw 1 mysqlmysql 2345 Jun 28 20:32 innodb.status.5022 -rw-rw 1 mysqlmysql 2345 Jun 28 21:49 innodb.status.58892 drwxr-s--- 2 mysqlmysql512 Jun 28 14:24 mysql drwx--S--- 2 mysqlmysql 1024 Jun 30 13:50 proxy_logs -rw-rw 1 mysqlmysql1074696691 Jun 30 15:09 rsl156-bin.001 -rw-rw 1 mysqlmysql1073819496 Jun 30 17:22 rsl156-bin.002 -rw-rw 1 mysqlmysql60454 Jun 30 17:27 rsl156-bin.003 -rw-rw 1 mysqlmysql 51 Jun 30 17:22 rsl156-bin.index -rw-rw 1 mysqlmysql 8596 Jun 30 14:03 rsl156.err -rw-rw 1 mysqlmysql 6 Jun 29 11:46 rsl156.pid drwxr-s--- 2 mysqlmysql512 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]
how to switch off logging?
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 mysqlmysql 25088 Jun 28 14:27 ib_arch_log_00 -rw-rw 1 mysqlmysql5242880 Jun 29 11:47 ib_logfile0 -rw-rw 1 mysqlmysql5242880 Jun 28 14:27 ib_logfile1 -rw-rw 1 mysqlmysql10485760 Jun 29 11:47 ibdata1 -rw-rw 1 mysqlmysql 2345 Jun 30 17:28 innodb.status.21716 -rw-rw 1 mysqlmysql 2345 Jun 28 15:37 innodb.status.4980 -rw-rw 1 mysqlmysql 2345 Jun 28 20:32 innodb.status.5022 -rw-rw 1 mysqlmysql 2345 Jun 28 21:49 innodb.status.58892 drwxr-s--- 2 mysqlmysql512 Jun 28 14:24 mysql drwx--S--- 2 mysqlmysql 1024 Jun 30 13:50 proxy_logs -rw-rw 1 mysqlmysql1074696691 Jun 30 15:09 rsl156-bin.001 -rw-rw 1 mysqlmysql1073819496 Jun 30 17:22 rsl156-bin.002 -rw-rw 1 mysqlmysql60454 Jun 30 17:27 rsl156-bin.003 -rw-rw 1 mysqlmysql 51 Jun 30 17:22 rsl156-bin.index -rw-rw 1 mysqlmysql 8596 Jun 30 14:03 rsl156.err -rw-rw 1 mysqlmysql 6 Jun 29 11:46 rsl156.pid drwxr-s--- 2 mysqlmysql512 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?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 30 June 2004 12:10 pm, 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? take out log-bin from my.cnf. But you better not have replication as that is the files used for replication. Jeff - -- === Jabber: tradergt@(smelser.org|jabber.org) Quote: Stale tagline. Go get some new ones. While you're at it, would you get me a beer? === -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA4vY1ld4MRA3gEwYRAhsaAJ926pG0lmu+B9EbzM+dY/cTm+35sgCeO72h mw7XIXyBQ1i2uo8TiIWNwVI= =0S5D -END PGP SIGNATURE- -- 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?
On Wednesday 30 June 2004 12:10 pm, 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? take out log-bin from my.cnf. But you better not have replication as that is the files used for replication. Jeff - -- Thanks for your reply. By replication do you mean do I have tables with duplicate rows? If that's the case then I do have one table with duplicate rows. _ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/ -- 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?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 30 June 2004 12:46 pm, J S wrote: Thanks for your reply. By replication do you mean do I have tables with duplicate rows? If that's the case then I do have one table with duplicate rows. No.. Replication, meaning, you have the same data being transfered from a server to another using myself. You don't seem to know what it is, so I doubt your doing it. - -- === Jabber: tradergt@(smelser.org|jabber.org) Quote: For a good time, type rm -rf ~ === -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA4wHqld4MRA3gEwYRAqbYAKCtEMNcwTc/4DAkHmxXzKlGlaqxowCdGLYA y0Oqe5/Tfeh4P/elKLw4VtI= =OGYE -END PGP SIGNATURE- -- 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?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 30 June 2004 01:09 pm, Jeff Smelser wrote: On Wednesday 30 June 2004 12:46 pm, J S wrote: Thanks for your reply. By replication do you mean do I have tables with duplicate rows? If that's the case then I do have one table with duplicate rows. No.. Replication, meaning, you have the same data being transfered from a server to another using myself. You don't seem to know what it is, so I doubt your doing it. Myself? thats mysql.. Sorry, bad typo - -- === Jabber: tradergt@(smelser.org|jabber.org) Quote: 124672900742 eye rays can't be wrong! === -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA4wdWld4MRA3gEwYRAuFTAJ4r4HHLLDv0Cz9kl84d2lnYUDykPACg2FKM VbkOsu70uTMBbNra5gbhNNM= =LrYZ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
