Re: 'commit' in slow query log?

[Quoted] On Friday, May 20, 2016 at 6:26:49 AM UTC+3, Jerry Stuckle wrote:
> On 5/19/2016 10:45 PM, gb.oldgarey_at_gmail.com wrote:
> > On Wednesday, 24 December 2008 15:38:59 UTC+8, flycondor wrote:
> >> I found many 'commit' in my slow query log
> >> does anyone know what's matter?
> >>
> >> example :
> >>
> >> # Time: 081223 23:40:49
> >> # User_at_Host: [user] @ appserver [192.168.1.5]
> >> # Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
> >> commit;
> >
> > i m facing the same issue, anybody have idea? thx
> >
>
> The same problem as someone had over seven years ago? Unless you're
> running a very old version of MySQL, I highly doubt it.
>
> But if you are running that old of a version, you need to update it.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> jstucklex_at_attglobal.net
> ==================

[Quoted] No. Problem is that he just gets "COMMIT" in slow query log. You can see that there is big transaction going on, but you don't know what that transaction contained. Received on Tue Feb 14 2017 - 15:51:40 CET