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 <jiangwen...@gmail.com>wrote: > Hi, > > 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 > > Regards > > Thanks > J.W > -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
