56,682
社区成员
发帖
与我相关
我的任务
分享
+------+-------------+-----------------+-----------+---------+-------+----------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-------------+-----------------+-----------+---------+-------+----------------------------------+------------------------------------------------------------------------------------------------------+
| 3 | system user | | NULL | Connect | 1323 | Waiting for master to send event | NULL |
| 4 | system user | | news_data | Connect | -1066 | Locked | UPDATE E_info SET info_reprint = info_reprint + 1 WHERE infoID = 2724158912 |
| 1130 | web_dev | 10.0.0.46:57567 | news_data | Query | 92 | Sending data | ( SELECT E_info.infoID,E_info.info_time , E_role_info.roleID,E_role_info.related
FROM `E |
| 1133 | web_dev | 10.0.0.46:57685 | news_data | Query | 74 | Locked | ( SELECT 3109066 AS 'columnID', '4.1.' AS 'cno', E_info_100.infoID,E_info_100.info_title, E_info_10 |
| 1134 | web_dev | 10.0.0.46:57727 | news_data | Query | 55 | Locked | ( SELECT 2601693 AS 'columnID', '1.1.1.' AS 'cno', E_info_100.* , E_role_info_100.roleID,E_role_in |
| 1135 | web_dev | 10.0.0.46:57740 | news_data | Query | 52 | Locked | ( SELECT E_info_100.infoID,E_info_100.info_time , E_role_info_100.roleID,E_role_info_100.related |
| 1136 | web_dev | 10.0.0.46:57744 | news_data | Query | 51 | Locked | ( SELECT 3032931 AS 'columnID', '1.1.' AS 'cno', E_info_100.infoID,E_info_100.info_title, E_info_10 |
| 1137 | web_dev | 10.0.0.46:57756 | news_data | Query | 47 | Locked | ( SELECT 2378187 AS 'columnID', '3.2.' AS 'cno', E_info_100.infoID,E_info_100.info_title, E_info_10 |
| 1138 | web_dev | 10.0.0.46:57794 | news_data | Query | 38 | Locked | ( SELECT E_info_100.infoID,E_info_100.info_time , E_role_info_100.roleID,E_role_info_100.related |
| 1139 | web_dev | 10.0.0.46:57797 | news_data | Query | 38 | Locked | ( SELECT 2243835 AS 'columnID', '2.1.' AS 'cno', E_info_100.infoID,E_info_100.info_title, E_info_10 |
| 1140 | web_dev | 10.0.0.46:57805 | news_data | Query | 34 | Locked | ( SELECT E_info_100.infoID,E_info_100.info_time , E_role_info_100.roleID,E_role_info_100.related |
| 1141 | web_dev | 10.0.0.46:57834 | news_data | Query | 28 | Locked | ( SELECT 350674 AS 'columnID', '2.2.' AS 'cno', E_info_100.infoID,E_info_100.info_title, E_info_100 |
| 1142 | web_dev | 10.0.0.46:57849 | news_data | Query | 25 | Locked | ( SELECT E_info_100.infoID,E_info_100.info_time , E_role_info_100.roleID,E_role_info_100.related |
| 1143 | web_dev | 10.0.0.46:57854 | news_data | Query | 25 | Locked | ( SELECT 79991 AS 'columnID', '2.1.1.' AS 'cno', E_info_100.infoID,E_info_100.info_title, E_info_10 |
| 1144 | web_dev | 10.0.0.46:57856 | news_data | Query | 25 | Locked | ( SELECT 183824 AS 'columnID', '2.5.' AS 'cno', E_info_100.* , E_role_info_100.roleID,E_role_info_ |
| 1145 | web_dev | 10.0.0.46:57914 | news_data | Query | 8 | Locked | ( SELECT E_info_100.infoID,E_info_100.info_time , E_role_info_100.roleID,E_role_info_100.related |
| 1146 | web_dev | 10.0.0.46:57919 | news_data | Query | 6 | Locked | ( SELECT E_info_100.infoID,E_info_100.info_time , E_role_info_100.roleID,E_role_info_100.related |
| 1149 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+------+-------------+-----------------+-----------+---------+-------+----------------------------------+------------------------------------------------------------------------------------------------------+
18 rows in set (0.00 sec)
# 0.00 seconds A select query (ie. read-only) accesses the table, it will take around 2 seconds to complete.
# 0.01 seconds Another select query accesses the table, it takes no time and will complete in an instant as it can run in parallel.
0.02 seconds An insert, delete or update query (ie. write) attempts to write to that very same table before the first select has completed.
# 0.03 seconds A select query comes in, again waiting for the first select to complete.
# 0.04 seconds Another select query comes in, again waiting for the first select to complete.
# 0.05 seconds Yet another select query comes in, again waiting for the first select to complete.
# .
# 1.99 seconds (~1000 queries later) Yet another select query comes in, again waiting for the first select to complete.