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 <ba...@xaprb.com> 写道: 发件人: Baron Schwartz <ba...@xaprb.com> 主题: Re: statistics statement in general log 收件人: mysql@lists.mysql.com 日期: 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_f...@yahoo.com.cn> 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=raid_f...@yahoo.com.cn