| View previous topic :: View next topic |
| Author |
Message |
jmarcus
Apprentice
Joined: 12 Jun 2004
Posts: 197
|
 Posted: Thu Feb 16, 2006 1:22 am Post subject: mySQL bin-log |
 |
|
I'm hoping that someone here knows how to deal with this, I have read through a bunch of docs on the mysql site and posted on a mysql BB.
Does anyone know howto disable the bin logs? I have tried a number of ways to do it without success. I have a small Gentoo box running Nagios and it can fill the disk in one day.
thanks,
James |
|
| Back to top |
|
 |
steveb
Advocate
Joined: 18 Sep 2002
Posts: 4564
|
| Posted: Thu Feb 16, 2006 2:09 am Post subject: |
|
|
I think if you disable the "cluster" USE flag, then the log stuff will go away.
Beside that, doing a "master reset;" in SQL will flush the log.
cheers
SteveB |
|
| Back to top |
|
|
jmarcus
Apprentice
Joined: 12 Jun 2004
Posts: 197
|
| Posted: Thu Feb 16, 2006 2:48 am Post subject: |
|
|
I don't think I emerged it with use flag cluster, am I reading this correctly
| Code: |
calpurnia libexec # equery uses mysql
[ Searching for packages matching mysql... ]
[ Colour Code : set unset ]
[ Legend : Left column (U) - USE flags from make.conf ]
[ : Right column (I) - USE flags packages was installed with ]
[ Found these USE variables for dev-db/mysql-4.1.14 ]
U I
- - berkdb : Adds support for sys-libs/db (Berkeley DB for MySQL)
- - big-tables : Make tables contain up to 1.844E+19 rows
- - cluster : Add support for NDB clustering.
- - debug : Tells configure and the makefiles to build for debugging. Effects vary across packages, but generally it will at least add -g to CFLAGS. Remember to set FEATURES=nostrip too
+ + doc : Adds extra documentation (API, Javadoc, etc)
- - extraengine : Add support for alternative storage engines.
- - geometry : Add support for geometry data.
- - minimal : Install a very minimal build (disables, for example, plugins, fonts, most drivers, non-critical features)
+ + perl : Adds support/bindings for the Perl language.
- - readline : enables support for libreadline, a GNU line-editing library that most everyone wants.
- - selinux : !!internal use only!! Security Enhanced Linux support, this must be set by the selinux profile or breakage will occur
+ + ssl : Adds support for Secure Socket Layer connections
- - static : !!do not set this during bootstrap!! Causes binaries to be statically linked instead of dynamically
+ + tcpd : Adds support for TCP wrappers
- - utf8 : Use UTF8 encoding instead of LATIN1.
|
|
|
| Back to top |
|
|
steveb
Advocate
Joined: 18 Sep 2002
Posts: 4564
|
|
| Back to top |
|
|
jmarcus
Apprentice
Joined: 12 Jun 2004
Posts: 197
|
| Posted: Thu Feb 16, 2006 12:05 pm Post subject: |
|
|
I did limit the log size, and now I have, well at last count 26 logs. Probably a lot more by this morning. I'm surprised that no one at the mySQL site didn't reply. |
|
| Back to top |
|
|
steveb
Advocate
Joined: 18 Sep 2002
Posts: 4564
|
| Posted: Thu Feb 16, 2006 6:05 pm Post subject: |
|
|
| jmarcus wrote: |
I did limit the log size, and now I have, well at last count 26 logs. Probably a lot more by this morning. I'm surprised that no one at the mySQL site didn't reply. |
<joke>They are not runing Gentoo Linux! With Gentoo Linux they would have done their job faster and be able to respond. </joke>
cheers
SteveB |
|
| Back to top |
|
|
tomk
Bodhisattva
Joined: 23 Sep 2003
Posts: 7221
Location: Sat in front of my computer
|
|
| Back to top |
|
|
steveb
Advocate
Joined: 18 Sep 2002
Posts: 4564
|
| Posted: Thu Feb 16, 2006 8:55 pm Post subject: |
|
|
| tomk wrote: | Found this in my.cnf:
|
This is only for the user's connection. SQL_LOG_BIN is a session varable and only valiable if the user has super privileges. Otherwise it is completly ignored.
cheers
SteveB |
|
| Back to top |
|
|
fikiz
Apprentice
Joined: 07 Mar 2005
Posts: 282
Location: Italy
|
| Posted: Fri Feb 17, 2006 10:12 am Post subject: |
|
|
remove the 'bin-log' or 'bin_log' line from my.cnf and restart mysql server.
ciao! |
|
| Back to top |
|
|
Gentoo Server
Apprentice
Joined: 21 Jul 2003
Posts: 279
|
| Posted: Mon Jul 03, 2006 11:08 am Post subject: |
|
|
#log-bin
disable log-bin
then after restart you can delete the binary logs |
|
| Back to top |
|
|
|
Other Things Gentoo
