server options

I added |log-slow-queries |to my my.ini file.
So now it says

#
[client]

port=3306

[mysql]

default-character-set=latin1
log-slow-queries

#
when I try to log into the server I get this:
C:>mysql -u myUserName -p
mysql: unknown option '--log-slow-queries'

I thought this was what the documentation said to do, but it was rather
hard to understand (or, maybe I'm just braindead right now. That's
possible.)


||Thanks for any help.
Joelle


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: server options

Try:

log-slow-queries=ON

You will probably want to set a value for "slow query log" as well.

Randy Clamons
Systems Programming
randy@novaspace.com


Joelle Tegwen wrote:
> I added |log-slow-queries |to my my.ini file.
> So now it says
>
> #
> [client]
>
> port=3306
>
> [mysql]
>
> default-character-set=latin1
> log-slow-queries
>
> #
> when I try to log into the server I get this:
> C:>mysql -u myUserName -p
> mysql: unknown option '--log-slow-queries'
>
> I thought this was what the documentation said to do, but it was rather
> hard to understand (or, maybe I'm just braindead right now. That's
> possible.)
>
>
> ||Thanks for any help.
> Joelle
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: server options

That option is for mysqld not mysql. I think that may be your problem.
Include it in your options file under [mysqld] not [mysql]. I think you
will need to restart your server for this to take effect.

John B.

-----Original Message-----
From: Joelle Tegwen [mailto:tegwe002@umn.edu]=20
Sent: Thursday, 9 March 2006 8:47 AM
To: MySQL - Win32
Subject: server options

I added |log-slow-queries |to my my.ini file.
So now it says

#
[client]

port=3D3306

[mysql]

default-character-set=3Dlatin1
log-slow-queries

#
when I try to log into the server I get this:
C:>mysql -u myUserName -p
mysql: unknown option '--log-slow-queries'

I thought this was what the documentation said to do, but it was rather=20
hard to understand (or, maybe I'm just braindead right now. That's=20
possible.)


||Thanks for any help.
Joelle



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: server options

Without being 100% sure I think, that the section [mysql] should be =
renamed to [mysqld]

also you might want to set the variable "long_query_time =3D seconds>"

/jesper

-----Original Message-----
From: Joelle Tegwen [mailto:tegwe002@umn.edu]
Sent: 8. marts 2006 23:17
To: MySQL - Win32
Subject: server options


I added |log-slow-queries |to my my.ini file.
So now it says

#
[client]

port=3D3306

[mysql]

default-character-set=3Dlatin1
log-slow-queries

#
when I try to log into the server I get this:
C:>mysql -u myUserName -p
mysql: unknown option '--log-slow-queries'

I thought this was what the documentation said to do, but it was rather=20
hard to understand (or, maybe I'm just braindead right now. That's=20
possible.)


||Thanks for any help.
Joelle


--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Djhn@rtx.dk


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: server options

I've seen reference to this, but I really have no idea how long a query
should take to run. What is a reasonable time?
Joelle <-- totally new and clueless about all of this stuff.

Jesper Hørup wrote:
> Without being 100% sure I think, that the section [mysql] should be renamed to [mysqld]
>
> also you might want to set the variable "long_query_time = "
>
> /jesper
>
> -----Original Message-----
> From: Joelle Tegwen [mailto:tegwe002@umn.edu]
> Sent: 8. marts 2006 23:17
> To: MySQL - Win32
> Subject: server options
>
>
> I added |log-slow-queries |to my my.ini file.
> So now it says
>
> #
> [client]
>
> port=3306
>
> [mysql]
>
> default-character-set=latin1
> log-slow-queries
>
> #
> when I try to log into the server I get this:
> C:>mysql -u myUserName -p
> mysql: unknown option '--log-slow-queries'
>
> I thought this was what the documentation said to do, but it was rather
> hard to understand (or, maybe I'm just braindead right now. That's
> possible.)
>
>
> ||Thanks for any help.
> Joelle
>
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org