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
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
