List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 10 2003 11:16pm
Subject:Re[2]: How disable query log?
View as plain text  
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

Thread
How disable query log?Andrey V. Ignatov10 Jan
  • Re: How disable query log?Paul DuBois10 Jan
Re[2]: How disable query log?Andrey V. Ignatov10 Jan
  • Re[2]: How disable query log?Paul DuBois11 Jan
Re[3]: How disable query log?Andrey V. Ignatov11 Jan