Web lists-archives.com

Re: Slow Query




Hi Franky,

I will let people more experienced than me confirm the following but I see
a repeated variable (slow-query-log) that is written using the dash (-)
rather than the underscore (_).

I would expect to have something like:

long_query_time = {{number}}
slow_query_log = 1
slow_query_log_file = /path/to/your/file.log


Regards,
Walter

On 10 April 2015 at 08:39, battossai <battossai@xxxxxxxxx> wrote:

> Hi,
>
>
> I have weird issue about slow query log on mysql server version 5.1.73-log.
> I use for freeradius backend, from freeradius milist say that my problem
> related to slow query on mysql.
> I try to know what kind of slow query that caused my issue with following
> options on my.cnf :
>
>
>
> *slow-query-log=/var/log/mysqld-query.logslow-query-log=1long_query_time=1*
>
>
> But no query appears on that log at all.
> Is there any missing configuration that i missed ?
> This is what i got with mytop :
>
> MySQL on localhost (5.1.73-log)
>
>   up 0+04:52:06 [14:38:15]
>
>  Queries: 95.9k  qps:    6 Slow:   348.0         Se/In/Up/De(%):
> 37/00/19/00
>
>              qps now:    4 Slow qps: 0.0  Threads:   21 (   1/   0)
> 68/00/05/00
>
>  Cache Hits: 25.2k Hits/s:  1.5 Hits now:   1.8  Ratio: 70.0% Ratio now:
> 73.3%
>
>  Key Efficiency: 100.0%  Bps in/out: 697.3/ 1.3k   Now in/out: 482.9/ 2.6k
>
>
> Thank you in advanced
>
>
> Regards,
>
> Franky Yu
>



-- 

walter dolce | software engineer (Zend Certified Engineer PHP5)
twitter @walterdolce <https://twitter.com/WalterDolce>
skype walter.dolce
tel +44 (or 0) 7873 527127