[MySQL]multiple connections, database locking up
最近關心的 mysql DB 發生了奇怪的狀況，突然就卡住不動了 QQ… 用 show processlist 觀察了一下目前的處理情況，發現一堆的 unauthenticated user… 馬上請 google 調派天兵天將去查了 unauthenticated user 是怎個回事 在官網看到 multiple connections, database locking up. 討論串 @ http://bugs.mysql.com/bug.php?id=2814 : 有很多人提到相同的狀況，有人發現與 DNS 有關係，因此建議修改 /etc/hosts 或 在 mysql 啟動時加入 skip-name-resolve ( in my.cnf) 的參數。 另外，在 http://www.debianhelp.co.uk/mysqlperformance.htm 看到了這樣的建議 : Optimize Mysql Database response time The most important part for getting a system fast is of cours e the basic design. You also need to know what kinds of things your system will be doing, and what y our bottlenecks are. The most common bottlen ecks are: Disk seeks. It takes time for the disk to find a piece of data. With moder n disks in 1999, the mean time for this is usually lower than 10ms, so we can in theory do about 100 seeks a second. This time improves slowly with new disks an d is very hard to optimise for a single table. The way to optimise this is to spread the ...