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=${PIDFILE} > /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
