MySQL连接数占满大量SQL锁定，请高手指教

勇者天空

系统是phpwind，具体情况表现为，突然间（这个不常见）MySQL连接数占满。
show full processlist 可见明显到达my.cnf设定的值，但这个时候服务器负载非常的低，硬盘I/O也没有占满。
查到的SQL就是不执行，超过几小时还是在等待中，感觉像是被事务锁定不释放资源。
show engine innodb status 以下信息，请高手指教。
里面的三个表信息：
pw_elements MyISAM类型
pw_hits_threads InnoDB类型
pw_memberdata MyISAM类型
系统autocommit = on
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 30

帖子太长，内容下页。

勇者天空

1. mysql> show engine innodb status\G
   
2. *************************** 1. row ***************************
   
3.   Type: InnoDB
   
4.   Name:
   
5. Status:
   
6. =====================================
   
7. 2013-07-20 22:33:14 7f90a9894700 INNODB MONITOR OUTPUT
   
8. =====================================
   
9. Per second averages calculated from the last 11 seconds
   
10. -----------------
    
11. BACKGROUND THREAD
    
12. -----------------
    
13. srv_master_thread loops: 572270 srv_active, 0 srv_shutdown, 3534 srv_idle
    
14. srv_master_thread log flush and writes: 575804
    
15. ----------
    
16. SEMAPHORES
    
17. ----------
    
18. OS WAIT ARRAY INFO: reservation count 1449629
    
19. OS WAIT ARRAY INFO: signal count 10046313
    
20. Mutex spin waits 121399643, rounds 87441130, OS waits 975276
    
21. RW-shared spins 3289111, rounds 16932934, OS waits 314541
    
22. RW-excl spins 1762666, rounds 19459283, OS waits 134250
    
23. Spin rounds per wait: 0.72 mutex, 5.15 RW-shared, 11.04 RW-excl
    
24. ------------
    
25. TRANSACTIONS
    
26. ------------
    
27. Trx id counter 734046624
    
28. Purge done for trx's n:o < 734046441 undo n:o < 0 state: running but idle
    
29. History list length 1692
    
30. LIST OF TRANSACTIONS FOR EACH SESSION:
    
31. ---TRANSACTION 734046623, not started
    
32. MySQL thread id 45409246, OS thread handle 0x7f90a9894700, query id 505729154 localhost root init
    
33. show engine innodb status
    
34. ---TRANSACTION 734046612, not started
    
35. MySQL thread id 45409287, OS thread handle 0x7f90a9916700, query id 505728675 localhost 127.0.0.1 root Waiting for table level lock
    
36. REPLACE LOW_PRIORITY INTO pw_elements (type,mark,id,value,addition,special) VALUES  ('hitsort','605','2545797','2021','','0')
    
37. ---TRANSACTION 734046607, not started
    
38. MySQL thread id 45409277, OS thread handle 0x7f90b91c7700, query id 505728592 localhost 127.0.0.1 root Waiting for table level lock
    
39. REPLACE LOW_PRIORITY INTO pw_elements (type,mark,id,value,addition,special) VALUES  ('hitsort','398','3238925','131105','','0') , ('hitsort','398','4615581','15907','','0') , ('hitsort','398','3194704','14405','','0') , ('hitsort','398','3179962','18409','','0') , ('hitsort','398','2048337','25322','','0') , ('hitsortday','398','6286085','6','1374321519','0') , ('hitsortday','398','6285006','10','1374297520','0') , ('hitsortday','398','6285379','5','1374306274','0')
    
40. ---TRANSACTION 734046603, not started
    
41. MySQL thread id 45409273, OS thread handle 0x7f90b8619700, query id 505728568 localhost 127.0.0.1 root query end
    
42. REPLACE LOW_PRIORITY INTO pw_elements (type,mark,id,value,addition,special) VALUES  ('hitsort','2','3533061','164079','','0') , ('hitsort','2','3262301','300417','','0') , ('hitsort','2','4857441','195474','','0') , ('hitsort','2','4786793','41312','','0') , ('hitsortday','2','6286785','1','1374328971','0') , ('hitsortday','2','6286046','9','1374321037','0') , ('hitsortday','2','6285166','11','1374301405','0') , ('hitsortday','2','6286379','3','1374324049','0') , ('hitsortday','2','6286281','5','1374323340','0') , ('hitsortday','2','6286115','9','1374321902','0') , ('hitsortday','2','6286680',
    
43. ---TRANSACTION 734046449, not started
    
44. MySQL thread id 45408882, OS thread handle 0x7f90b9410700, query id 505726138 localhost 127.0.0.1 root query end
    
45. UPDATE LOW_PRIORITY  `pw_memberdata`   SET   `lastvisit`  =  '1374328973' ,  `thisvisit`  =  '1374328973'  WHERE uid= '175088'
    
46. ---TRANSACTION 734046439, not started
    
47. mysql tables in use 1, locked 1
    
48. MySQL thread id 45408866, OS thread handle 0x7f90aa597700, query id 505726058 localhost 127.0.0.1 root query end
    
49. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6242812'
    
50. ---TRANSACTION 734046622, ACTIVE (PREPARED) 1242 sec
    
51. mysql tables in use 1, locked 1
    
52. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
53. MySQL thread id 45409301, OS thread handle 0x7f90a35fd700, query id 505728740 localhost 127.0.0.1 root query end
    
54. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '4677152'
    
55. ---TRANSACTION 734046621, ACTIVE (PREPARED) 1242 sec
    
56. mysql tables in use 1, locked 1
    
57. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
58. MySQL thread id 45409302, OS thread handle 0x7f90a35bc700, query id 505728739 localhost 127.0.0.1 root query end
    
59. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '3628395'
    
60. ---TRANSACTION 734046618, ACTIVE (PREPARED) 1243 sec
    
61. mysql tables in use 1, locked 1
    
62. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
63. MySQL thread id 45409294, OS thread handle 0x7f90a3742700, query id 505728701 localhost 127.0.0.1 root query end
    
64. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '3976246'
    
65. ---TRANSACTION 734046616, ACTIVE (PREPARED) 1244 sec
    
66. mysql tables in use 1, locked 1
    
67. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
68. MySQL thread id 45409290, OS thread handle 0x7f90a3805700, query id 505728674 localhost 127.0.0.1 root query end
    
69. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '5904448'
    
70. ---TRANSACTION 734046615, ACTIVE (PREPARED) 1244 sec
    
71. mysql tables in use 1, locked 1
    
72. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
73. MySQL thread id 45409291, OS thread handle 0x7f90aadf8700, query id 505728673 localhost 127.0.0.1 root query end
    
74. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '3632904'
    
75. ---TRANSACTION 734046611, ACTIVE (PREPARED) 1245 sec
    
76. mysql tables in use 1, locked 1
    
77. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
78. MySQL thread id 45409282, OS thread handle 0x7f90ab8a2700, query id 505728632 localhost 127.0.0.1 root query end
    
79. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '3735619'
    
80. ---TRANSACTION 734046610, ACTIVE (PREPARED) 1245 sec
    
81. mysql tables in use 1, locked 1
    
82. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
83. MySQL thread id 45409281, OS thread handle 0x7f90b9082700, query id 505728625 localhost 127.0.0.1 root query end
    
84. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '362836'
    
85. ---TRANSACTION 734046605, ACTIVE (PREPARED) 1246 sec
    
86. 
    
87. 
    

复制代码

勇者天空

1. mysql tables in use 1, locked 1
   
2. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
   
3. MySQL thread id 45409276, OS thread handle 0x7f90aa69b700, query id 505728589 localhost 127.0.0.1 root query end
   
4. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '5605190'
   
5. ---TRANSACTION 734046601, ACTIVE (PREPARED) 1248 sec
   
6. mysql tables in use 1, locked 1
   
7. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
   
8. MySQL thread id 45409268, OS thread handle 0x7f90abdb6700, query id 505728545 localhost 127.0.0.1 root query end
   
9. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6275225'
   
10. ---TRANSACTION 734046600, ACTIVE (PREPARED) 1248 sec
    
11. mysql tables in use 1, locked 1
    
12. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
13. MySQL thread id 45409269, OS thread handle 0x7f90ab555700, query id 505728544 localhost 127.0.0.1 root query end
    
14. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6286746'
    
15. ---TRANSACTION 734046597, ACTIVE (PREPARED) 1250 sec
    
16. mysql tables in use 1, locked 1
    
17. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
18. MySQL thread id 45409259, OS thread handle 0x7f90b9555700, query id 505728510 localhost 127.0.0.1 root query end
    
19. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6285907'
    
20. ---TRANSACTION 734046596, ACTIVE (PREPARED) 1250 sec
    
21. mysql tables in use 1, locked 1
    
22. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
23. MySQL thread id 45409260, OS thread handle 0x7f90ab4d3700, query id 505728509 localhost 127.0.0.1 root query end
    
24. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '3628554'
    
25. ---TRANSACTION 734046591, ACTIVE (PREPARED) 1788 sec
    
26. mysql tables in use 1, locked 1
    
27. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
28. MySQL thread id 45409226, OS thread handle 0x7f90b8452700, query id 505728288 localhost 127.0.0.1 root query end
    
29. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '343255'
    
30. ---TRANSACTION 734046590, ACTIVE (PREPARED) 1788 sec
    
31. mysql tables in use 1, locked 1
    
32. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
33. MySQL thread id 45409228, OS thread handle 0x7f90b9104700, query id 505728280 localhost 127.0.0.1 root query end
    
34. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6284808'
    
35. ---TRANSACTION 734046587, ACTIVE (PREPARED) 1789 sec
    
36. mysql tables in use 1, locked 1
    
37. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
38. MySQL thread id 45409222, OS thread handle 0x7f90b828b700, query id 505728240 localhost 127.0.0.1 root query end
    
39. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '3431468'
    
40. ---TRANSACTION 734046582, ACTIVE (PREPARED) 1790 sec
    
41. mysql tables in use 1, locked 1
    
42. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
43. MySQL thread id 45409210, OS thread handle 0x7f90a9b5f700, query id 505728180 localhost 127.0.0.1 root query end
    
44. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6286664'
    
45. ---TRANSACTION 734046578, ACTIVE (PREPARED) 1792 sec
    
46. mysql tables in use 1, locked 1
    
47. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
48. MySQL thread id 45409194, OS thread handle 0x7f90a9998700, query id 505728072 localhost 127.0.0.1 root query end
    
49. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6251456'
    
50. ---TRANSACTION 734046577, ACTIVE (PREPARED) 1792 sec
    
51. mysql tables in use 1, locked 1
    
52. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
53. MySQL thread id 45409195, OS thread handle 0x7f90ab410700, query id 505728071 localhost 127.0.0.1 root query end
    
54. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '4356520'
    
55. ---TRANSACTION 734046571, ACTIVE (PREPARED) 1794 sec
    
56. mysql tables in use 1, locked 1
    
57. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
58. MySQL thread id 45409177, OS thread handle 0x7f90ab451700, query id 505727958 localhost 127.0.0.1 root query end
    
59. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6286678'
    
60. ---TRANSACTION 734046570, ACTIVE (PREPARED) 1794 sec
    
61. mysql tables in use 1, locked 1
    
62. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
63. MySQL thread id 45409176, OS thread handle 0x7f90a9a1a700, query id 505727957 localhost 127.0.0.1 root query end
    
64. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6277777'
    
65. ---TRANSACTION 734046561, ACTIVE (PREPARED) 1797 sec
    
66. mysql tables in use 1, locked 1
    
67. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
68. MySQL thread id 45409151, OS thread handle 0x7f90aad35700, query id 505727791 localhost 127.0.0.1 root query end
    
69. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6286680'
    
70. ---TRANSACTION 734046560, ACTIVE (PREPARED) 1797 sec
    
71. mysql tables in use 1, locked 1
    
72. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
73. MySQL thread id 45409149, OS thread handle 0x7f90ab28a700, query id 505727790 localhost 127.0.0.1 root query end
    
74. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '5589339'
    
75. ---TRANSACTION 734046557, ACTIVE (PREPARED) 1798 sec
    
76. mysql tables in use 1, locked 1
    
77. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
78. MySQL thread id 45409144, OS thread handle 0x7f90aa71d700, query id 505727757 localhost 127.0.0.1 root query end
    
79. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '3790992'
    
80. ---TRANSACTION 734046552, ACTIVE (PREPARED) 1799 sec
    
81. mysql tables in use 1, locked 1
    
82. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
83. MySQL thread id 45409134, OS thread handle 0x7f90b871d700, query id 505727705 localhost 127.0.0.1 root query end
    
84. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '3078659'
    
85. ---TRANSACTION 734046548, ACTIVE (PREPARED) 1803 sec
    
86. mysql tables in use 1, locked 1
    
87. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
88. MySQL thread id 45409104, OS thread handle 0x7f90b8aab700, query id 505727513 localhost 127.0.0.1 root query end
    
89. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6284464'
    
90. ---TRANSACTION 734046546, ACTIVE (PREPARED) 1804 sec
    
91. mysql tables in use 1, locked 1
    
92. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
93. MySQL thread id 45409099, OS thread handle 0x7f90ab34d700, query id 505727486 localhost 127.0.0.1 root query end
    
94. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '2096292'
    
95. ---TRANSACTION 734046542, ACTIVE (PREPARED) 1805 sec
    
96. mysql tables in use 1, locked 1
    
97. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
    
98. MySQL thread id 45409088, OS thread handle 0x7f90b8db7700, query id 505727417 localhost 127.0.0.1 root query end
    
99. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6280900'
    
100. ---TRANSACTION 734046539, ACTIVE (PREPARED) 1806 sec
     
101. mysql tables in use 1, locked 1
     
102. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
103. MySQL thread id 45409080, OS thread handle 0x7f90ab30c700, query id 505727372 localhost 127.0.0.1 root query end
     
104. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '5450262'
     
105. ---TRANSACTION 734046531, ACTIVE (PREPARED) 1807 sec
     
106. mysql tables in use 1, locked 1
     
107. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
108. MySQL thread id 45409067, OS thread handle 0x7f90b8209700, query id 505727287 localhost 127.0.0.1 root query end
     
109. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '1845565'
     
110. ---TRANSACTION 734046526, ACTIVE (PREPARED) 1807 sec
     
111. mysql tables in use 1, locked 1
     
112. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
113. MySQL thread id 45409061, OS thread handle 0x7f90a38c8700, query id 505727254 localhost 127.0.0.1 root query end
     
114. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6285180'
     
115. ---TRANSACTION 734046524, ACTIVE (PREPARED) 1808 sec
     
116. mysql tables in use 1, locked 1
     
117. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
118. MySQL thread id 45409053, OS thread handle 0x7f90aa493700, query id 505727193 localhost 127.0.0.1 root query end
     
119. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '6270830'
     
120. ---TRANSACTION 734046522, ACTIVE (PREPARED) 1809 sec
     
121. mysql tables in use 1, locked 1
     
122. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
123. MySQL thread id 45409042, OS thread handle 0x7f90aa1c8700, query id 505727140 localhost 127.0.0.1 root query end
     
124. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '4976659'
     
125. ---TRANSACTION 734046520, ACTIVE (PREPARED) 1810 sec
     
126. mysql tables in use 1, locked 1
     
127. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
128. MySQL thread id 45409033, OS thread handle 0x7f90aa6dc700, query id 505727072 localhost 127.0.0.1 root query end
     
129. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '342764'
     
130. ---TRANSACTION 734046518, ACTIVE (PREPARED) 1810 sec
     
131. mysql tables in use 1, locked 1
     
132. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
133. MySQL thread id 45409028, OS thread handle 0x7f90b9000700, query id 505727052 localhost 127.0.0.1 root query end
     
134. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '5869660'
     
135. ---TRANSACTION 734046516, ACTIVE (PREPARED) 1811 sec
     
136. mysql tables in use 1, locked 1
     
137. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
138. MySQL thread id 45409025, OS thread handle 0x7f90b8bf0700, query id 505727024 localhost 127.0.0.1 root query end
     
139. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '5892945'
     
140. ---TRANSACTION 734046515, ACTIVE (PREPARED) 1811 sec
     
141. mysql tables in use 1, locked 1
     
142. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
143. MySQL thread id 45409024, OS thread handle 0x7f90ab965700, query id 505727023 localhost 127.0.0.1 root query end
     
144. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '1847147'
     
145. ---TRANSACTION 734046512, ACTIVE (PREPARED) 1813 sec
     
146. mysql tables in use 1, locked 1
     
147. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
     
148. MySQL thread id 45409017, OS thread handle 0x7f90b8aec700, query id 505726976 localhost 127.0.0.1 root query end
     
149. UPDATE LOW_PRIORITY pw_hits_threads SET hits=hits+1 WHERE tid= '947247'
     
150. --------
     
151. FILE I/O
     
152. --------
     
153. I/O thread 0 state: waiting for i/o request (insert buffer thread)
     
154. I/O thread 1 state: waiting for i/o request (log thread)
     
155. I/O thread 2 state: waiting for i/o request (read thread)
     
156. I/O thread 3 state: waiting for i/o request (read thread)
     
157. I/O thread 4 state: waiting for i/o request (read thread)
     
158. I/O thread 5 state: waiting for i/o request (read thread)
     
159. I/O thread 6 state: waiting for i/o request (write thread)
     
160. I/O thread 7 state: waiting for i/o request (write thread)
     
161. I/O thread 8 state: waiting for i/o request (write thread)
     
162. I/O thread 9 state: waiting for i/o request (write thread)
     
163. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
     
164. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
     
165. Pending flushes (fsync) log: 0; buffer pool: 0
     
166. 219605 OS file reads, 31691125 OS file writes, 4947602 OS fsyncs
     
167. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
     
168. -------------------------------------
     
169. INSERT BUFFER AND ADAPTIVE HASH INDEX
     
170. -------------------------------------
     
171. Ibuf: size 1, free list len 81, seg size 83, 6509 merges
     
172. merged operations:
     
173. insert 6655, delete mark 1588, delete 376
     
174. discarded operations:
     
175. insert 0, delete mark 0, delete 0
     
176. Hash table size 42499381, node heap has 32117 buffer(s)
     
177. 0.00 hash searches/s, 0.00 non-hash searches/s
     
178. ---
     
179. LOG
     
180. ---
     
181. Log sequence number 91843027065
     
182. Log flushed up to   91843027065
     
183. Pages flushed up to 91843027065
     
184. Last checkpoint at  91843027065
     
185. 0 pending log writes, 0 pending chkp writes
     
186. 26528170 log i/o's done, 0.00 log i/o's/second
     
187. ----------------------
     
188. BUFFER POOL AND MEMORY
     
189. ----------------------
     
190. Total memory allocated 21978152960; in additional pool allocated 0
     
191. Dictionary memory allocated 121762
     
192. Buffer pool size   1310712
     
193. Free buffers       1044777
     
194. Database pages     233818
     
195. Old database pages 86199
     
196. Modified db pages  0
     
197. Pending reads 0
     
198. Pending writes: LRU 0, flush list 0 single page 0
     
199. Pages made young 1954, not young 0
     
200. 0.00 youngs/s, 0.00 non-youngs/s
     
201. Pages read 228565, created 5253, written 4929197
     
202. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
     
203. No buffer pool page gets since the last printout
     
204. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
     
205. LRU len: 233818, unzip_LRU len: 0
     
206. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
     
207. ----------------------
     
208. INDIVIDUAL BUFFER POOL INFO
     
209. ----------------------
     
210. ---BUFFER POOL 0
     
211. Buffer pool size   163839
     
212. Free buffers       131034
     
213. Database pages     28803
     
214. Old database pages 10620
     
215. Modified db pages  0
     
216. Pending reads 0
     
217. Pending writes: LRU 0, flush list 0 single page 0
     
218. Pages made young 229, not young 0
     
219. 0.00 youngs/s, 0.00 non-youngs/s
     
220. Pages read 28152, created 651, written 586838
     
221. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
     
222. No buffer pool page gets since the last printout
     
223. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
     
224. LRU len: 28803, unzip_LRU len: 0
     
225. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
     
226. ---BUFFER POOL 1
     
227. Buffer pool size   163839
     
228. Free buffers       131638
     
229. Database pages     28161
     
230. Old database pages 10382
     
231. Modified db pages  0
     
232. Pending reads 0
     
233. Pending writes: LRU 0, flush list 0 single page 0
     
234. Pages made young 290, not young 0
     
235. 0.00 youngs/s, 0.00 non-youngs/s
     
236. Pages read 27585, created 576, written 610756
     
237. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
     
238. No buffer pool page gets since the last printout
     
239. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
     
240. LRU len: 28161, unzip_LRU len: 0
     
241. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
     
242. ---BUFFER POOL 2
     
243. Buffer pool size   163839
     
244. Free buffers       129849
     
245. Database pages     29943
     
246. Old database pages 11033
     
247. Modified db pages  0
     
248. Pending reads 0
     
249. Pending writes: LRU 0, flush list 0 single page 0
     
250. Pages made young 251, not young 0
     
251. 0.00 youngs/s, 0.00 non-youngs/s
     
252. Pages read 29329, created 614, written 616116
     
253. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
     
254. No buffer pool page gets since the last printout
     
255. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
     
256. LRU len: 29943, unzip_LRU len: 0
     
257. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
     
258. ---BUFFER POOL 3
     
259. Buffer pool size   163839
     
260. Free buffers       130300
     
261. Database pages     29531
     
262. Old database pages 10881
     
263. Modified db pages  0
     
264. Pending reads 0
     
265. Pending writes: LRU 0, flush list 0 single page 0
     
266. Pages made young 220, not young 0
     
267. 0.00 youngs/s, 0.00 non-youngs/s
     
268. Pages read 28849, created 682, written 645894
     
269. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
     
270. No buffer pool page gets since the last printout
     
271. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
     
272. LRU len: 29531, unzip_LRU len: 0
     
273. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
     
274. ---BUFFER POOL 4
     
275. Buffer pool size   163839
     
276. Free buffers       130416
     
277. Database pages     29381
     
278. Old database pages 10825
     
279. Modified db pages  0
     
280. Pending reads 0
     
281. Pending writes: LRU 0, flush list 0 single page 0
     
282. Pages made young 262, not young 0
     
283. 0.00 youngs/s, 0.00 non-youngs/s
     
284. Pages read 28751, created 630, written 592063
     
285. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
     
286. No buffer pool page gets since the last printout
     
287. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
     
288. LRU len: 29381, unzip_LRU len: 0
     
289. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
     
290. ---BUFFER POOL 5
     
291. Buffer pool size   163839
     
292. Free buffers       129963
     
293. Database pages     29865
     
294. Old database pages 11007
     
295. Modified db pages  0
     
296. Pending reads 0
     
297. Pending writes: LRU 0, flush list 0 single page 0
     
298. Pages made young 257, not young 0
     
299. 0.00 youngs/s, 0.00 non-youngs/s
     
300. Pages read 29219, created 646, written 605752
     
301. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
     
302. No buffer pool page gets since the last printout
     
303. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
     
304. LRU len: 29865, unzip_LRU len: 0
     
305. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
     
306. ---BUFFER POOL 6
     
307. Buffer pool size   163839
     
308. Free buffers       129849
     
309. Database pages     30037
     
310. Old database pages 11067
     
311. Modified db pages  0
     
312. Pending reads 0
     
313. Pending writes: LRU 0, flush list 0 single page 0
     
314. Pages made young 203, not young 0
     
315. 0.00 youngs/s, 0.00 non-youngs/s
     
316. Pages read 29310, created 727, written 626615
     
317. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
     
318. No buffer pool page gets since the last printout
     
319. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
     
320. LRU len: 30037, unzip_LRU len: 0
     
321. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
     
322. ---BUFFER POOL 7
     
323. Buffer pool size   163839
     
324. Free buffers       131728
     
325. Database pages     28097
     
326. Old database pages 10384
     
327. Modified db pages  0
     
328. Pending reads 0
     
329. Pending writes: LRU 0, flush list 0 single page 0
     
330. Pages made young 242, not young 0
     
331. 0.00 youngs/s, 0.00 non-youngs/s
     
332. Pages read 27370, created 727, written 645163
     
333. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
     
334. No buffer pool page gets since the last printout
     
335. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
     
336. LRU len: 28097, unzip_LRU len: 0
     
337. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
     
338. --------------
     
339. ROW OPERATIONS
     
340. --------------
     
341. 0 queries inside InnoDB, 0 queries in queue
     
342. 0 read views open inside InnoDB
     
343. Main thread process no. 2056, id 140259615176448, state: sleeping
     
344. Number of rows inserted 354458, updated 28369307, deleted 78309, read 34890835591
     
345. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
     
346. ----------------------------
     
347. END OF INNODB MONITOR OUTPUT
     
348. ============================
     
349. 
     
350. 1 row in set (0.00 sec)

复制代码

飞鸿无痕

pw_hits_threads表的索引情况如何？
processlist信息也贴一下看看。

勇者天空

processlist 没有收集，但大部份都是这个。
pw_hits_threads 主键tid，没有其它的索引。