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.
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
marklv
4 months, 1 week agoalemdba
2 months agoalemdba
2 months ago