statistics statement in general log

--0-11860114-1284012851=:19234
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi guys,
anyone knows what's the meaning of "statistics" in general log ? thanks.
....
100908=A0 9:40:11 21513 Statistics
100908=A0 9:40:14 21518 Statistics
100908=A0 9:40:19 21518 Statistics
100908=A0 9:40:21 21513 Statistics
100908=A0 9:40:24 21518 Statistics
100908=A0 9:40:29 21518 Statistics
100908=A0 9:40:31 21513 Statistics
100908=A0 9:40:34 21518 Statistics
100908=A0 9:40:39 21518 Statistics
100908=A0 9:40:41 21513 Statistics
100908=A0 9:40:44 21518 Statistics
100908=A0 9:40:49 21518 Statistics
100908=A0 9:40:51 21513 Statistics
....

this general log is on my slave server. those "Statistics" blocked slave SQ=
L thread, results in some transactions "Lock wait timeout exceeded; try res=
tarting transaction" errors.
Actually, these transactions run fast on my master.

*^_^* =0A
--0-11860114-1284012851=:19234--

Re: statistics statement in general log

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 wrote:
> Hi guys,
> anyone knows what's the meaning of "statistics" in general log ? thanks.
> ...
> 100908=A0 9:40:11 21513 Statistics
> 100908=A0 9:40:14 21518 Statistics
> 100908=A0 9:40:19 21518 Statistics
> 100908=A0 9:40:21 21513 Statistics
> 100908=A0 9:40:24 21518 Statistics
> 100908=A0 9:40:29 21518 Statistics
> 100908=A0 9:40:31 21513 Statistics
> 100908=A0 9:40:34 21518 Statistics
> 100908=A0 9:40:39 21518 Statistics
> 100908=A0 9:40:41 21513 Statistics
> 100908=A0 9:40:44 21518 Statistics
> 100908=A0 9:40:49 21518 Statistics
> 100908=A0 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 r=
estarting transaction" errors.
> Actually, these transactions run fast on my master.
>
> *^_^*
>
>
>



--=20
Baron Schwartz
Percona Inc
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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: statistics statement in general log

--0-1547486444-1284304060=:9860
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

thank you Baron, yes, it's check-alive code from our application gateways w=
hich was confirmed by our developers.
But, how can it impact slave sql thread executing transaction extracted fro=
m binary log ?
thanks!

Liu Xian

*^_^*

--- 10å¹=B49æœ=8811日，周六, Baron Schw=
artz 写道ï¼=9A

发件äº=BA: Baron Schwartz
主题: Re: statistics statement in general log
收件äº=BA: mysql@lists.mysql.com
日期: 2010å¹=B49æœ=8811æ—=A5,周六,=
上午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 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 r=
estarting transaction" errors.
> Actually, these transactions run fast on my master.
>
> *^_^*
>
>
>



--=20
Baron Schwartz
Percona Inc
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=3Draid_fifa=
@yahoo.com.cn

=0A
--0-1547486444-1284304060=:9860--