I have a small innodb table ~ 2k rows in Mysql 5.5.31-log version. Dont understand why sometimes in a day , one update on that table is taking around 1 minute to complete.
DBName Table Name Data Data Free
| test | users | 0.48MB | 0.00MB |
Is dere any way to understand locking hierarchy on that table in a day so that we came to know at that particular time who is taking lock on users table due to which update is taking time to finish.
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!