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 = <num seconds>"
>
> /jesper
>
> -----Original Message-----
> From: Joelle Tegwen [mailto:tegwe002@stripped]
> 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
>
>
>