1Z0-908: MySQL 8.0 Database AdministratorDemo

Question

A colleague reports slow response times on your website. Examine this query output:

Question Image

What is the most likely reason for the large number of lock waits?

A You use the MyISAM storage engine for most common tables.
B You use the InnoDB storage engine and statements wait while data is inserted.
C The Innodb Buffer pool is full.
D Your table accesses wait for the operating system level flush.

Explanation

Table_locks_waited records table-lock requests that required waiting. MyISAM uses table-level locking, so concurrent reads and writes against frequently used MyISAM tables can create substantial table-lock contention and slow responses. MySQL Reference Manual: Internal Locking Methods

Learn more

MySQL Reference Manual: Internal Locking Methods

1Z0-908: MySQL 8.0 Database AdministratorDemo

AstroTutor

Notes

Readiness

QuestionQ110

Community Discussion