Examine the mysqldumpslow output:

Which two options could explain the slow query?
A. There is network congestion between client and server.
B. No index has been defined on the filtered column.
C. There are 108 queries still being executed.
D. A table lock is causing delays.
E. A full table scan is being used.
Answer: B,E
Mysqldumpslow输出如下：
哪两个原因能够解释上述输出？
A．客户端与服务器之间的网络存在阻塞
B．筛选字段上没有索引
C．还有108个Query正在执行
D．表锁引起的查询缓慢
E．全表扫描http://www.cndba.cn/hbhe0316/article/22788

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL