大家看看数据库有什么问题，是不是表死锁了？
mysql> show processlist;
+------+------+-----------+------------+---------+------+--------+-----------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------+------------+---------+------+--------+-----------------------------------------------+
| 1816 | root | localhost | TraceRoute | Sleep | 8 | | NULL |
| 1817 | root | localhost | TraceRoute | Sleep | 25 | | NULL |
| 1818 | root | localhost | TraceRoute | Sleep | 6 | | NULL |
| 1819 | root | localhost | TraceRoute | Sleep | 13 | | NULL |
| 1820 | root | localhost | TraceRoute | Sleep | 31 | | NULL |
| 1821 | root | localhost | TraceRoute | Sleep | 13 | | NULL |
| 1822 | root | localhost | TraceRoute | Sleep | 10 | | NULL |
| 1823 | root | localhost | TraceRoute | Sleep | 22 | | NULL |
| 1824 | root | localhost | TraceRoute | Sleep | 15 | | NULL |
| 1825 | root | localhost | TraceRoute | Sleep | 31 | | NULL |
| 1826 | root | localhost | TraceRoute | Sleep | 24 | | NULL |
| 1827 | root | localhost | TraceRoute | Sleep | 28 | | NULL |
| 1828 | root | localhost | TraceRoute | Sleep | 22 | | NULL |
| 1829 | root | localhost | TraceRoute | Query | 31 | Locked | lock table landmark_traceroute_R_jw1_l6 write |
| 1830 | root | localhost | TraceRoute | Sleep | 22 | | NULL |
| 1831 | root | localhost | TraceRoute | Sleep | 13 | | NULL |
| 1832 | root | localhost | TraceRoute | Sleep | 31 | | NULL |
| 1833 | root | localhost | TraceRoute | Sleep | 31 | | NULL |
| 1834 | root | localhost | TraceRoute | Sleep | 31 | | NULL |
| 1835 | root | localhost | TraceRoute | Sleep | 24 | | NULL |
| 1836 | root | localhost | TraceRoute | Sleep | 13 | | NULL |
| 1837 | root | localhost | TraceRoute | Sleep | 31 | | NULL |
| 1838 | root | localhost | TraceRoute | Sleep | 31 | | NULL |
| 1839 | root | localhost | TraceRoute | Sleep | 13 | | NULL |
| 1840 | root | localhost | TraceRoute | Sleep | 13 | | NULL |
| 1841 | root | localhost | TraceRoute | Query | 31 | Locked | lock table landmark_traceroute_R_jw1_l6 write |
| 1842 | root | localhost | TraceRoute | Sleep | 13 | | NULL |
| 1843 | root | localhost | TraceRoute | Query | 22 | Locked | lock table landmark_traceroute_R_jw1_l6 write |
| 1844 | root | localhost | TraceRoute | Sleep | 8 | | NULL |
| 1846 | root | localhost | TraceRoute | Query | 0 | NULL | show processlist
[解决办法]
sleep那么多线程应该是死锁了，Table_locks_waited | 168622
lock table tablename write；
换成排他锁试试？
[解决办法]
