MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:raid fifa Date:September 12 2010 3:07pm
Subject:Re: statistics statement in general log
View as plain text  
thank you Baron, yes, it's check-alive code from our application gateways which was
confirmed by our developers.
But, how can it impact slave sql thread executing transaction extracted from binary log ?
thanks!

Liu Xian

*^_^*

--- 10年9月11日,周六, Baron Schwartz <baron@stripped> 写道:

发件人: Baron Schwartz <baron@stripped>
主题: Re: statistics statement in general log
收件人: mysql@stripped
日期: 2010年9月11日,周六,上午1:56

Those are from a 'status' API call.  Many ORMs use such calls to check
that the database connection is alive.

On Thu, Sep 9, 2010 at 2:14 AM, raid fifa <raid_fifa@stripped> wrote:
> Hi guys,
> anyone knows what's the meaning of "statistics" in general log ? thanks.
> ...
> 100908  9:40:11 21513 Statistics
> 100908  9:40:14 21518 Statistics
> 100908  9:40:19 21518 Statistics
> 100908  9:40:21 21513 Statistics
> 100908  9:40:24 21518 Statistics
> 100908  9:40:29 21518 Statistics
> 100908  9:40:31 21513 Statistics
> 100908  9:40:34 21518 Statistics
> 100908  9:40:39 21518 Statistics
> 100908  9:40:41 21513 Statistics
> 100908  9:40:44 21518 Statistics
> 100908  9:40:49 21518 Statistics
> 100908  9:40:51 21513 Statistics
> ...
>
> this general log is on my slave server. those "Statistics" blocked slave SQL thread,
> results in some transactions "Lock wait timeout exceeded; try restarting transaction"
> errors.
> Actually, these transactions run fast on my master.
>
> *^_^*
>
>
>



-- 
Baron Schwartz
Percona Inc <http://www.percona.com/>
Consulting, Training, Support & Services for MySQL

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




      
Thread
statistics statement in general lograid fifa9 Sep
  • Re: statistics statement in general logBaron Schwartz10 Sep
    • Re: statistics statement in general lograid fifa12 Sep