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 mysqlmysql
-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 bet
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 file
-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
-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 wit
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 wil
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 Dykma