Re: Would you please tell me more about performance tool ?

There is no access to the raw mysql protocol so you cannot use the mysqladmin tool. Note that the InnoDB tables from INFORMATION_SCHEMA [1] are available and should allow you to find which query is holding locks.

[1] http://dev.mysql.com/doc/refman/5.5/en/innodb-information-schema.html

-- Razvan ME

On Sat, Sep 1, 2012 at 9:17 PM, Rast Rastapana <tung_suplex@hotmail.com> wrote:

           Do you support "mysqladmin debug" ( the debug command in MySQL ) ?

 now that  i use some commands to show the performance to check row locking  -  SHOW PROCESSLIST ,SHOW ENGINE INNODB STATUS

 but they can't show which thread holds the table locks that are blocking your query at all.

Thank you in advance!