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?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With