At 23:45 +0300 1/10/03, Andrey V. Ignatov wrote:
It's *nothing* about query logging in configuration files!
# mysqld --print-defaults
mysqld would have been started with the following arguments:
--port=3306
--socket=/var/run/mysqld/mysqld.sock
--skip-locking
--set-variable=max_connect_errors=1000
--set-variable=max_connections=600
--default-character-set=win1251
--set-variable=key_buffer=128M
--set-variable=max_allowed_packet=1M
--set-variable=table_cache=512
--set-variable=sort_buffer=2M
--set-variable=record_buffer=2M
--set-variable=thread_cache=12
--set-variable=thread_concurrency=6
--set-variable=myisam_sort_buffer_size=64M
--set-variable=query_cache_size=64M
--set-variable=query_cache_limit=1M
--set-variable=query_cache_type=1
--innodb_data_home_dir=/var/lib/mysql/
--innodb_data_file_path=ibdata1:1500M;ibdata2:1500M;ibdata3:1500M;ibdata4:1500M;ibdata5:1500M:autoextend
--innodb_log_group_home_dir=/var/lib/mysql/
--innodb_log_arch_dir=/var/lib/mysql/
--set-variable=innodb_buffer_pool_size=256M
--set-variable=innodb_additional_mem_pool_size=20M
--set-variable=innodb_log_file_size=128M
--set-variable=innodb_log_buffer_size=8M
--innodb_flush_log_at_trx_commit=0
--set-variable=innodb_lock_wait_timeout=20
--set-variable=innodb_thread_concurrency=6
Okay, that's strange. Next step:
- What's the name of the log file that the server is logging to?
- Does logging occur if you shut down the server (with mysql.server stop,
for example), and then start mysqld manually?
Friday, January 10, 2003, 10:25:00 PM, you wrote:
PD At 18:59 +0300 1/10/03, Andrey V. Ignatov wrote:
Hi, all!
I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about
logging in mysql.server startup script and in my.cnf, but mysqld
create log file and write a lot of queries to it. How i can disable
this?
My configure options:
./configure --without-berkley-db
--with-named-curses-libs=/opt/ncurses-5.3/lib/libncurses.a
--build=powerpc64-linux --prefix=/usr/local/mysql
--localstatedir=/var/lib/mysql --sysconfdir=/etc/mysql
--sbindir=/usr/local/mysql/bin --libexecdir=/usr/local/mysql/bin
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --without-debug
--without-isam
--with-extra-charsets=complex
PD The log isn't enabled by default, so it must be getting turned on
PD *somewhere* at startup time. Check all your option files, not just
PD one. Run this command to check what options are getting passed to
PD it from option files:
PD mysqld --print-defaults
-
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