Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx

Links

XODOX
Impressum

#1: [question]any performance tools about UPDATE

Posted on 2011-09-23 08:07:49 by jiangwen jiang

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

Report this message

#2: Re: [question]any performance tools about UPDATE

Posted on 2011-09-24 00:05:48 by prabhat kumar

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

--00151773ea800762ab04ada3032b--

Report this message