Mysql slow query logging ( commit takes time )

[veerasamy kaunder]

Hello,

I see a lot of below entries in slow query logs.

# Query_time: 2.129828 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1352111031;
commit;

how do i trace which query has consumed time or other way, why commit is taking 2 seconds of time.

Also, FYI, the queries in the transcation set before the commit operation are not visible in slow query log.

Need your expert advice please.

Thanks & Regards,
Veerasamy Kaunder