Reputation: 140012
by Show innodb status
I can see information about deadlock and so on,
but I don't know is there an equivalent version for MYISAM-engine tables?
Upvotes: 7
Views: 4849
Reputation: 48446
show open tables
and show table status
, though neither is myisam-exclusive, though show table status has more info for myisam tables.
Myisam has only table-level locking and no transactions, so the state of its tables is much simpler.
Upvotes: 10