I don't think any other than > show full processlist. In which state query
is locked or not.
I/O related things you check at OS level.
On Thu, Sep 22, 2011 at 11:07 PM, jiangwen jiang <jiangwen127@stripped>wrote:
> Is there any performance toolds about UPDATE/INSERT querys?
> I want to monitor the UPDATE/INSERT performance, check out if there's any
> performance bottleneck, for example:
> slow INSERT/UPDATE
> more I/O where execute INSERT
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat