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!
No comments:
Post a Comment