[question]any performance tools about UPDATE

--000e0cd5ba12f7bd6204ad95a099
Content-Type: text/plain; charset=ISO-8859-1

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

--000e0cd5ba12f7bd6204ad95a099--

Re: [question]any performance tools about UPDATE

--00151773ea800762ab04ada3032b
Content-Type: text/plain; charset=ISO-8859-1

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 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

--00151773ea800762ab04ada3032b--