>From you're info below, mysql *shouldn't* be turning on the binary log. An
easy way to test is just to run the 'ps' command and see if '--log-bin' is
being added to the command line. If you have a long command line for the
mysql process, you may need to use 'ps awx' or 'ps awwx' -- these work on
Linux, but you may need to use something different for FreeBSD. Have you, or
anyone else, edited the safe_mysqld script, possibly adding '--log-bin'
there?
--jeff
----- Original Message -----
From: "Dmitry Sukhodoev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 09, 2003 4:10 AM
Subject: how turn off binary update log?
> hello, mysql.
>
> i have installed mysql-server 3.23.55 from ports under FreeBSD 4.7-STABLE.
> databases place is /var/db/mysql. and in this dir creates binary log of
updated
> databases in /var/db/mysql/bingo-bin.001, 002, etc. i do not turn on this
in
> configs and startup files, but it don't care appear and grows and grows
and
> grows until free space on hdd disappear :-(
>
> how i can turn off this logs? please help me. i do not need replication, i
use
> only myisam types databases.
>
> this is my.cnf:
> === cut ===
> [client]
> port = 3306
> socket = /tmp/mysql.sock
>
> [mysqld]
> port = 3306
> socket = /tmp/mysql.sock
> skip-locking
> set-variable = key_buffer=16M
> set-variable = max_allowed_packet=1M
> set-variable = table_cache=64
> set-variable = sort_buffer=512K
> set-variable = net_buffer_length=8K
> set-variable = myisam_sort_buffer_size=8M
> server-id = 1
> tmpdir = /var/tmp/
> skip-innodb
>
> [mysqldump]
> quick
> set-variable = max_allowed_packet=16M
>
> [mysql]
> no-auto-rehash
>
> [isamchk]
> set-variable = key_buffer=20M
> set-variable = sort_buffer=20M
> set-variable = read_buffer=2M
> set-variable = write_buffer=2M
>
> [myisamchk]
> set-variable = key_buffer=20M
> set-variable = sort_buffer=20M
> set-variable = read_buffer=2M
> set-variable = write_buffer=2M
>
> [mysqlhotcopy]
> interactive-timeout
> === cut ===
>
> this is my startup file (/usr/local/etc/rc.d/mysql-server.sh):
> === cut ===
> #!/bin/sh
>
> DB_DIR=/var/db/mysql
> PIDFILE=${DB_DIR}/`/bin/hostname -s`.pid
>
> case "$1" in
> start)
> if [ -x /usr/local/bin/safe_mysqld ]; then
> /usr/bin/limits -U mysql \
>
/usr/local/bin/safe_mysqld --user=mysql --datadir=${DB_DIR} --pid-file=${PID
FILE} > /dev/null &
> echo -n ' mysqld'
> fi
> ;;
> stop)
> if [ -f ${PIDFILE} ]; then
> /bin/kill `cat ${PIDFILE}` > /dev/null 2>&1 &&
echo -n ' mysqld'
> else
> echo "mysql-server isn't running"
> fi
> ;;
> *)
> echo ""
> echo "Usage: `basename $0` { start | stop }"
> echo ""
> exit 64
> ;;
> esac
> === cut ===
>
> --
> Dmitry Sukhodoev, network administrator of bingo.ru, icq#550315
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
