[PHP3] Re: log-slow-queries help From: Mark Maggelet (maggelet <email protected>)
Date: 04/30/00

Hello, that doesn't work for me. I'm using 3.23.14a

here's my my.cnf:

[mysqld]
set-variable = table_cache=200
set-variable = key_buffer=350M
set-variable = back_log=25
set-variable = join_buffer=16M
set-variable = delayed_insert_limit=30
set-variable = delayed_insert_timeout=30000
set-variable = tmp_table_size=16M
--log-slow-queries=/home/educationplanet/slowqueries.log

mysql chokes on it.
Also, mysql gets run from the mysql.server script, so I cannot
pass options to it on the command line unless you know
of a workaround.

thanks for your time,
- Mark

***********************************************

On 4/30/00 at 4:26 PM Thimble Smith wrote:

>On Sun, Apr 30, 2000 at 12:49:31PM -0700, Mark Maggelet wrote:
>> what do I put into my.cnf to set log-slow-queries?
>> It's not in the docs and I've tried everything I can think of.
>
>Yes, it's missing from mysqld --help, and it's missing from the
>manual (well, it's in the Changelog section...). I'll try to fix
>that today.
>
>You should be able to use "--log-slow-queries"; you can add on
>"=filename" or "=/path/to/filename" if you want to name it something
>other that `hostname -p`-slow.log.
>
>Note: this is only available in recent versions of MySQL 3.23!
>
>Tim
>--
>Tim Smith < tim <email protected> > :MySQL Development Team: Boone, NC USA. 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>