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 correct answer is B. You use the InnoDB storage engine and statements wait while data is inserted. https://severalnines.com/database-blog/how-fix-lock-wait-timeout-exceeded-error-mysql

Monitoring

Question

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?

Exhibit

Options

AYou use the MyISAM storage engine for most common tables.
BYou use the InnoDB storage engine and statements wait while data is inserted.
CThe Innodb Buffer pool is full.
DYour table accesses wait for the operating system level flush.

How the community answered

(48 responses)

A
15% (7)
B
73% (35)
C
8% (4)
D
4% (2)

Explanation

https://severalnines.com/database-blog/how-fix-lock-wait-timeout-exceeded-error-mysql

Topics

#InnoDB lock waits#row locking#concurrent writes#performance diagnosis

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice