- 论坛徽章:
- 0
|
show processlist中很多状态都是locked,程序不是自己做的,估计是程序对mysql调用的优化不够导致,在早上人很多访问时会非常慢,甚至打不开,到了下午人比较少时就恢复正常了,程序是没办法改了,各位还有没有什么高招帮忙针对mysql优化下,谢谢,啊.
- 5412131 | mail | localhost | NULL | Query | 56 | Locked | select mail_uid
- 5412132 | mail | localhost | NULL | Query | 57 | Locked | select mail_uid
- 5412133 | mail | localhost | NULL | Query | 56 | Locked | select mail_uid
- 5412134 | mail | localhost | NULL | Query | 56 | Locked | select mail_uid
- 5412135 | mail | localhost | NULL | Query | 56 | Locked | select mail_uid
- 5412136 | mail | localhost | NULL | Query | 56 | Locked | select mail_uid
- 5412137 | mail | localhost | NULL | Query | 56 | Locked | select mail_uid
- 5412155 | mail | localhost | NULL | Query | 56 | Locked | select mail_uid
-
- 5412159 | mail | localhost | NULL | Query | 16 | Locked | select count(*) a
- 5412162 | mail | localhost | NULL | Query | 28 | Locked | select count(*) cnt
- 5412163 | mail | localhost | NULL | Query | 54 | Locked
复制代码
[ 本帖最后由 xmbbx 于 2007-3-6 13:41 编辑 ] |
|