- 爱易网页
-
MySQL教程
- 大家看看数据库有什么有关问题,是不是表死锁了
日期:2014-05-16 浏览次数:20975 次
大家看看数据库有什么问题,是不是表死锁了?
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