A colleague complains about slow response time on your website.
Examine this query and output:
What is the most likely cause for the high number of lock waits?
A colleague complains about slow response time on your website.
Examine this query and output:
What is the most likely cause for the high number of lock waits?
The high number of table lock waits is most likely due to the use of the MyISAM storage engine. MyISAM uses table-level locking, which can lead to a high number of lock waits when there are frequent write operations occurring on the tables. This is indicated by the high 'Table_locks_waited' value in the provided output. In contrast, InnoDB uses row-level locking and is generally better at handling concurrent operations without causing a high number of lock waits.
those fields are for MyISAM, so A. There aren't many tables locks with innodb.
There are not locks In MyISAM, because the engine is not supported ACID Only in Innodb can be locks
I made a mistake. Answer is A