1. mysql>
  2. mysql> show processlist\G;
  3. *************************** 1. row ***************************
  4. Id: 1
  5. User: system user
  6. Host:
  7. db: datadb
  8. Command: Connect
  9. Time: 61
  10. State: Locked
  11. Info: UPDATE `wp_posts` SET `post_parent` = 0 WHERE `post_parent` = 236849 AND `post_type` = 'attachment'
  12. *************************** 2. row ***************************
  13. Id: 2
  14. User: system user
  15. Host:
  16. db: NULL
  17. Command: Connect
  18. Time: 7179883
  19. State: Waiting for master to send event
  20. Info: NULL
  21. *************************** 3. row ***************************
  22. Id: 20769851
  23. User: datadb
  24. Host: server1.domain.com:60491
  25. db: datadb
  26. Command: Query
  27. Time: 8
  28. State: Copying to tmp table
  29. Info: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati
  30. *************************** 4. row ***************************
  31. Id: 20769948
  32. User: datadb
  33. Host: server1.domain.com:60746
  34. db: datadb
  35. Command: Query
  36. Time: 8
  37. State: Copying to tmp table
  38. Info: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati
  39. *************************** 5. row ***************************
  40. Id: 20769955
  41. User: root
  42. Host: localhost
  43. db: NULL
  44. Command: Query
  45. Time: 0
  46. State: NULL
  47. Info: show processlist
  48. *************************** 6. row ***************************
  49. Id: 20770129
  50. User: datadb
  51. Host: server1.domain.com:61300
  52. db: datadb
  53. Command: Query
  54. Time: 8
  55. State: Copying to tmp table
  56. Info: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati
  57. *************************** 7. row ***************************
  58. Id: 20770133
  59. User: datadb
  60. Host: server1.domain.com:61329
  61. db: datadb
  62. Command: Query
  63. Time: 14
  64. State: Copying to tmp table
  65. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  66. *************************** 8. row ***************************
  67. Id: 20770149
  68. User: datadb
  69. Host: server1.domain.com:61369
  70. db: datadb
  71. Command: Query
  72. Time: 14
  73. State: Copying to tmp table
  74. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  75. *************************** 9. row ***************************
  76. Id: 20770239
  77. User: datadb
  78. Host: server1.domain.com:61594
  79. db: datadb
  80. Command: Sleep
  81. Time: 1
  82. State:
  83. Info: NULL
  84. *************************** 10. row ***************************
  85. Id: 20770259
  86. User: datadb
  87. Host: server1.domain.com:61645
  88. db: datadb
  89. Command: Query
  90. Time: 12
  91. State: Copying to tmp table
  92. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  93. *************************** 11. row ***************************
  94. Id: 20770263
  95. User: datadb
  96. Host: server1.domain.com:61661
  97. db: datadb
  98. Command: Query
  99. Time: 11
  100. State: Copying to tmp table
  101. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  102. *************************** 12. row ***************************
  103. Id: 20770273
  104. User: datadb
  105. Host: server1.domain.com:61683
  106. db: datadb
  107. Command: Query
  108. Time: 10
  109. State: Copying to tmp table
  110. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  111. *************************** 13. row ***************************
  112. Id: 20770281
  113. User: datadb
  114. Host: server1.domain.com:61711
  115. db: datadb
  116. Command: Query
  117. Time: 8
  118. State: Copying to tmp table
  119. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  120. *************************** 14. row ***************************
  121. Id: 20770287
  122. User: datadb
  123. Host: server1.domain.com:61729
  124. db: datadb
  125. Command: Query
  126. Time: 6
  127. State: Copying to tmp table
  128. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  129. *************************** 15. row ***************************
  130. Id: 20770299
  131. User: datadb
  132. Host: server1.domain.com:61763
  133. db: datadb
  134. Command: Query
  135. Time: 5
  136. State: Copying to tmp table
  137. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  138. *************************** 16. row ***************************
  139. Id: 20770311
  140. User: datadb
  141. Host: server1.domain.com:61801
  142. db: datadb
  143. Command: Query
  144. Time: 4
  145. State: Locked
  146. Info: SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2011' AND MONTH(wp_posts
  147. *************************** 17. row ***************************
  148. Id: 20770321
  149. User: datadb
  150. Host: server1.domain.com:61822
  151. db: datadb
  152. Command: Query
  153. Time: 4
  154. State: Locked
  155. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  156. *************************** 18. row ***************************
  157. Id: 20770327
  158. User: datadb
  159. Host: server1.domain.com:61832
  160. db: datadb
  161. Command: Query
  162. Time: 3
  163. State: Locked
  164. Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
  165. *************************** 19. row ***************************
  166. Id: 20770333
  167. User: datadb
  168. Host: server1.domain.com:61853
  169. db: datadb
  170. Command: Query
  171. Time: 2
  172. State: Locked
  173. Info: SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts
  174. *************************** 20. row ***************************
  175. Id: 20770335
  176. User: datadb
  177. Host: server1.domain.com:61861
  178. db: datadb
  179. Command: Query
  180. Time: 1
  181. State: Locked
  182. Info: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati
  183. *************************** 21. row ***************************
  184. Id: 20770337
  185. User: datadb
  186. Host: server1.domain.com:61866
  187. db: datadb
  188. Command: Query
  189. Time: 1
  190. State: Locked
  191. Info: SELECT ID, post_name, post_parent FROM wp_posts WHERE post_name IN ('aquiremediafeedreader') AND (po
  192. *************************** 22. row ***************************
  193. Id: 20770353
  194. User: datadb
  195. Host: server1.domain.com:61880
  196. db: datadb
  197. Command: Sleep
  198. Time: 0
  199. State:
  200. Info: NULL
  201. 22 rows in set (0.00 sec)
  202.  
  203. ERROR:
  204. No query specified
  205.  
  206. mysql> show processlist\G;
  207. show processlist\G;;;
  208. +----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
  209. | Id | User | Host | db | Command | Time | State | Info |
  210. +----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
  211. | 1 | system user | | datadb | Connect | 70 | Locked | UPDATE `wp_posts` SET `guid` = 'http://www.forexlive.com/?p=238119' WHERE `ID` = 238119 |
  212. | 2 | system user | | NULL | Connect | 7179894 | Waiting for master to send event | NULL |
  213. | 20769955 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  214. | 20770239 | datadb | server1.domain.com:61594 | datadb | Sleep | 0 | | NULL |
  215. | 20770287 | datadb | server1.domain.com:61729 | datadb | Query | 1 | Locked | SELECT * FROM wp_posts WHERE ID = 238112 LIMIT 1 |
  216. | 20770327 | datadb | server1.domain.com:61832 | datadb | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  217. | 20770337 | datadb | server1.domain.com:61866 | datadb | Sleep | 3 | | NULL |
  218. | 20770367 | datadb | server1.domain.com:61914 | datadb | Query | 2 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  219. | 20770387 | datadb | server1.domain.com:61967 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  220. | 20770389 | datadb | server1.domain.com:61972 | datadb | Query | 1 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  221. | 20770391 | datadb | server1.domain.com:61974 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  222. | 20770393 | datadb | server1.domain.com:61976 | datadb | Query | 2 | Sorting result | SELECT post_date_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', ' |
  223. | 20770395 | datadb | server1.domain.com:61980 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  224. | 20770397 | datadb | server1.domain.com:61984 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  225. | 20770401 | datadb | server1.domain.com:61990 | datadb | Query | 2 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  226. | 20770405 | datadb | server1.domain.com:61997 | datadb | Query | 1 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  227. | 20770407 | datadb | server1.domain.com:61999 | datadb | Query | 2 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  228. | 20770409 | datadb | server1.domain.com:62003 | datadb | Query | 2 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  229. | 20770411 | datadb | server1.domain.com:62007 | datadb | Query | 1 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  230. | 20770413 | datadb | server1.domain.com:62011 | datadb | Query | 1 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  231. | 20770415 | datadb | server1.domain.com:62013 | datadb | Query | 0 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  232. | 20770417 | datadb | server1.domain.com:62015 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  233. | 20770419 | datadb | server1.domain.com:62019 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  234. | 20770421 | datadb | server1.domain.com:62021 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  235. | 20770423 | datadb | server1.domain.com:62025 | datadb | Query | 0 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  236. | 20770425 | datadb | server1.domain.com:62027 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  237. | 20770427 | datadb | server1.domain.com:62029 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  238. +----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
  239. 27 rows in set (0.00 sec)
  240.  
  241. mysql> \ddsesc wp_post;s;
  242. ERROR 1046 (3D000): No database selected
  243. mysql> use datadb;
  244. Database changed
  245. mysql> use datadb;
  246. desc wp_posts;
  247. +-----------------------+---------------------+------+-----+---------------------+----------------+
  248. | Field | Type | Null | Key | Default | Extra |
  249. +-----------------------+---------------------+------+-----+---------------------+----------------+
  250. | ID | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
  251. | post_author | bigint(20) unsigned | NO | MUL | 0 | |
  252. | post_date | datetime | NO | | 0000-00-00 00:00:00 | |
  253. | post_date_gmt | datetime | NO | | 0000-00-00 00:00:00 | |
  254. | post_content | longtext | NO | | NULL | |
  255. | post_title | text | NO | | NULL | |
  256. | post_category | int(4) | NO | | 0 | |
  257. | post_excerpt | text | NO | | NULL | |
  258. | post_status | varchar(20) | NO | MUL | publish | |
  259. | comment_status | varchar(20) | NO | | open | |
  260. | ping_status | varchar(20) | NO | | open | |
  261. | post_password | varchar(20) | NO | | | |
  262. | post_name | varchar(200) | NO | MUL | | |
  263. | to_ping | text | NO | | NULL | |
  264. | pinged | text | NO | | NULL | |
  265. | post_modified | datetime | NO | | 0000-00-00 00:00:00 | |
  266. | post_modified_gmt | datetime | NO | | 0000-00-00 00:00:00 | |
  267. | post_content_filtered | text | NO | | NULL | |
  268. | post_parent | bigint(20) unsigned | NO | MUL | 0 | |
  269. | guid | varchar(255) | NO | | | |
  270. | menu_order | int(11) | NO | | 0 | |
  271. | post_type | varchar(20) | NO | MUL | post | |
  272. | post_mime_type | varchar(100) | NO | | | |
  273. | comment_count | bigint(20) | NO | | 0 | |
  274. +-----------------------+---------------------+------+-----+---------------------+----------------+
  275. 24 rows in set (0.01 sec)
  276.  
  277. show processlist;
  278. +----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
  279. | Id | User | Host | db | Command | Time | State | Info |
  280. +----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
  281. | 1 | system user | | datadb | Connect | 106 | Locked | UPDATE `wp_posts` SET `post_author` = 87, `post_date` = '2012-02-24 21:20:12', `post_date_gmt` = '20 |
  282. | 2 | system user | | NULL | Connect | 7179981 | Waiting for master to send event | NULL |
  283. | 20769955 | root | localhost | datadb | Query | 0 | NULL | show processlist |
  284. | 20770409 | datadb | server1.domain.com:62003 | datadb | Query | 34 | removing tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  285. | 20770419 | datadb | server1.domain.com:62019 | datadb | Query | 34 | removing tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  286. | 20770427 | datadb | server1.domain.com:62029 | datadb | Query | 34 | removing tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  287. | 20770433 | datadb | server1.domain.com:62035 | datadb | Query | 21 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  288. | 20770435 | datadb | server1.domain.com:62037 | datadb | Query | 21 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  289. | 20770437 | datadb | server1.domain.com:62041 | datadb | Query | 21 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  290. | 20770439 | datadb | server1.domain.com:62043 | datadb | Query | 21 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  291. | 20770443 | datadb | server1.domain.com:62051 | datadb | Query | 22 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  292. | 20770445 | datadb | server1.domain.com:62055 | datadb | Query | 21 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  293. | 20770493 | datadb | server1.domain.com:62159 | datadb | Query | 21 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  294. | 20770557 | datadb | server1.domain.com:62293 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  295. | 20770585 | datadb | server1.domain.com:62347 | datadb | Query | 34 | removing tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  296. | 20770599 | datadb | server1.domain.com:62382 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  297. | 20770607 | datadb | server1.domain.com:62403 | datadb | Query | 2 | Sorting for group | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  298. | 20770609 | datadb | server1.domain.com:62405 | datadb | Query | 28 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  299. | 20770611 | datadb | server1.domain.com:62407 | datadb | Query | 28 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  300. | 20770615 | datadb | server1.domain.com:62413 | datadb | Query | 4 | Sorting for group | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  301. | 20770627 | datadb | server1.domain.com:62441 | datadb | Query | 28 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  302. | 20770633 | datadb | server1.domain.com:62462 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  303. | 20770635 | datadb | server1.domain.com:62464 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  304. | 20770637 | datadb | server1.domain.com:62466 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  305. | 20770639 | datadb | server1.domain.com:62468 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  306. | 20770641 | datadb | server1.domain.com:62470 | datadb | Query | 28 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  307. | 20770645 | datadb | server1.domain.com:62484 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  308. | 20770648 | datadb | server1.domain.com:62493 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  309. | 20770649 | datadb | server1.domain.com:62494 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  310. | 20770651 | datadb | server1.domain.com:62496 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  311. | 20770653 | datadb | server1.domain.com:62500 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  312. | 20770655 | datadb | server1.domain.com:62506 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  313. | 20770657 | datadb | server1.domain.com:62508 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  314. | 20770661 | datadb | server1.domain.com:62513 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  315. | 20770663 | datadb | server1.domain.com:62519 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  316. | 20770669 | datadb | server1.domain.com:62531 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  317. | 20770671 | datadb | server1.domain.com:62537 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  318. | 20770673 | datadb | server1.domain.com:62545 | datadb | Query | 21 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  319. | 20770677 | datadb | server1.domain.com:62552 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  320. | 20770679 | datadb | server1.domain.com:62554 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  321. | 20770683 | datadb | server1.domain.com:62558 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  322. | 20770685 | datadb | server1.domain.com:62566 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  323. | 20770687 | datadb | server1.domain.com:62570 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  324. | 20770689 | datadb | server1.domain.com:62576 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  325. | 20770691 | datadb | server1.domain.com:62578 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  326. | 20770693 | datadb | server1.domain.com:62580 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  327. | 20770700 | datadb | server1.domain.com:62593 | datadb | Query | 28 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  328. | 20770707 | datadb | server1.domain.com:62606 | datadb | Query | 36 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  329. | 20770717 | datadb | server1.domain.com:62624 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  330. | 20770719 | datadb | server1.domain.com:62628 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  331. | 20770727 | datadb | server1.domain.com:62648 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  332. | 20770729 | datadb | server1.domain.com:62651 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  333. | 20770731 | datadb | server1.domain.com:62658 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  334. | 20770733 | datadb | server1.domain.com:62668 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  335. | 20770735 | datadb | server1.domain.com:62672 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  336. | 20770737 | datadb | server1.domain.com:62674 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  337. | 20770739 | datadb | server1.domain.com:62676 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  338. | 20770741 | datadb | server1.domain.com:62682 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  339. | 20770743 | datadb | server1.domain.com:62684 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  340. | 20770747 | datadb | server1.domain.com:62698 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  341. | 20770749 | datadb | server1.domain.com:62704 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  342. | 20770757 | datadb | server1.domain.com:62726 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  343. | 20770759 | datadb | server1.domain.com:62730 | datadb | Query | 11 | Sending data | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-01-25 19:31:11' AND p.post_type = 'post' AN |
  344. | 20770761 | datadb | server1.domain.com:62732 | datadb | Query | 11 | Sorting for group | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  345. | 20770765 | datadb | server1.domain.com:62742 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  346. | 20770769 | datadb | server1.domain.com:62750 | datadb | Query | 11 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  347. | 20770771 | datadb | server1.domain.com:62752 | datadb | Query | 26 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  348. | 20770779 | datadb | server1.domain.com:62771 | datadb | Query | 0 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  349. | 20770781 | datadb | server1.domain.com:62775 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  350. | 20770783 | datadb | server1.domain.com:62777 | datadb | Query | 1 | Sorting for group | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  351. | 20770785 | datadb | server1.domain.com:62785 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  352. | 20770787 | datadb | server1.domain.com:62791 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  353. | 20770789 | datadb | server1.domain.com:62795 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  354. | 20770791 | datadb | server1.domain.com:62799 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  355. | 20770793 | datadb | server1.domain.com:62807 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  356. | 20770795 | datadb | server1.domain.com:62809 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  357. | 20770800 | datadb | server1.domain.com:62820 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  358. | 20770801 | datadb | server1.domain.com:62821 | datadb | Query | 0 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  359. | 20770807 | datadb | server1.domain.com:62831 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  360. | 20770813 | datadb | server1.domain.com:62850 | datadb | Query | 23 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  361. | 20770815 | datadb | server1.domain.com:62854 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  362. | 20770819 | datadb | server1.domain.com:62858 | datadb | Query | 0 | Locked | SELECT post_name FROM wp_posts WHERE post_name = 'us-data-may-richmond-fed-mfg-index-4-vs-14-in' AND |
  363. | 20770823 | datadb | server1.domain.com:62864 | datadb | Sleep | 0 | | NULL |
  364. | 20770829 | datadb | server1.domain.com:62872 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  365. | 20770833 | datadb | server1.domain.com:62876 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  366. | 20770835 | datadb | server1.domain.com:62880 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  367. | 20770841 | datadb | server1.domain.com:62898 | datadb | Sleep | 0 | | NULL |
  368. | 20770843 | datadb | server1.domain.com:62900 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  369. | 20770845 | datadb | server1.domain.com:62906 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  370. | 20770849 | datadb | server1.domain.com:62914 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  371. | 20770853 | datadb | server1.domain.com:62918 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  372. | 20770855 | datadb | server1.domain.com:62924 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  373. | 20770857 | datadb | server1.domain.com:62926 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  374. | 20770859 | datadb | server1.domain.com:62935 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  375. | 20770861 | datadb | server1.domain.com:62937 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  376. | 20770863 | datadb | server1.domain.com:62939 | datadb | Sleep | 0 | | NULL |
  377. | 20770865 | datadb | server1.domain.com:62943 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  378. | 20770867 | datadb | server1.domain.com:62947 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  379. | 20770871 | datadb | server1.domain.com:62951 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  380. | 20770876 | datadb | server1.domain.com:62959 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  381. | 20770880 | datadb | server1.domain.com:62971 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  382. | 20770882 | datadb | server1.domain.com:62975 | datadb | Query | 29 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  383. | 20770890 | datadb | server1.domain.com:62991 | datadb | Query | 27 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  384. | 20770892 | datadb | server1.domain.com:62993 | datadb | Query | 0 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  385. | 20770894 | datadb | server1.domain.com:62999 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  386. | 20770896 | datadb | server1.domain.com:63001 | datadb | Query | 0 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  387. | 20770899 | datadb | server1.domain.com:63004 | datadb | Query | 0 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  388. | 20770900 | datadb | server1.domain.com:63005 | datadb | Query | 0 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  389. | 20770902 | datadb | server1.domain.com:63019 | datadb | Query | 26 | Sorting result | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  390. | 20770904 | datadb | server1.domain.com:63029 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'us-data-apr-existing-home-sales-3-4-to-4-62-mln%' AND |
  391. | 20770906 | datadb | server1.domain.com:63031 | datadb | Query | 26 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  392. | 20770908 | datadb | server1.domain.com:63036 | datadb | Query | 0 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  393. | 20770910 | datadb | server1.domain.com:63052 | datadb | Query | 24 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  394. | 20770912 | datadb | server1.domain.com:63054 | datadb | Query | 24 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  395. | 20770914 | datadb | server1.domain.com:63060 | datadb | Query | 24 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  396. | 20770918 | datadb | server1.domain.com:63068 | datadb | Query | 24 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  397. | 20770920 | datadb | server1.domain.com:63076 | datadb | Query | 23 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  398. | 20770922 | datadb | server1.domain.com:63078 | datadb | Sleep | 0 | | NULL |
  399. | 20770924 | datadb | server1.domain.com:63080 | datadb | Sleep | 0 | | NULL |
  400. | 20770926 | datadb | server1.domain.com:63082 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  401. | 20770928 | datadb | server1.domain.com:63086 | datadb | Query | 23 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  402. | 20770930 | datadb | server1.domain.com:63088 | datadb | Query | 0 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  403. | 20770932 | datadb | server1.domain.com:63090 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  404. | 20770934 | datadb | server1.domain.com:63092 | datadb | Query | 23 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  405. | 20770936 | datadb | server1.domain.com:63094 | datadb | Query | 0 | Locked | SELECT post_id FROM wp_postmeta, wp_posts WHERE ID = post_id AND post_type = 'post' AND meta_key = ' |
  406. | 20770941 | datadb | server1.domain.com:63105 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  407. | 20770942 | datadb | server1.domain.com:63106 | datadb | Sleep | 0 | | NULL |
  408. | 20770945 | datadb | server1.domain.com:63111 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  409. | 20770946 | datadb | server1.domain.com:63112 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  410. | 20770950 | datadb | server1.domain.com:63119 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  411. | 20770952 | datadb | server1.domain.com:63124 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  412. | 20770954 | datadb | server1.domain.com:63128 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  413. | 20770956 | datadb | server1.domain.com:63130 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  414. | 20770958 | datadb | server1.domain.com:63134 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  415. | 20770960 | datadb | server1.domain.com:63136 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'eurozone-consumer-morale-unexpectedly-recovers-in-may% |
  416. | 20770962 | datadb | server1.domain.com:63140 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  417. | 20770964 | datadb | server1.domain.com:63142 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'ecbs-constancio-do-not-expect-greece-to-leave-eurozone |
  418. | 20770966 | datadb | server1.domain.com:63144 | datadb | Query | 0 | Locked | SELECT post_id FROM wp_postmeta, wp_posts WHERE ID = post_id AND post_type = 'post' AND meta_key = ' |
  419. | 20770968 | datadb | server1.domain.com:63146 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  420. | 20770970 | datadb | server1.domain.com:63150 | datadb | Query | 21 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  421. | 20770972 | datadb | server1.domain.com:63154 | datadb | Query | 21 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  422. | 20770974 | datadb | server1.domain.com:63158 | datadb | Query | 0 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  423. | 20770978 | datadb | server1.domain.com:63162 | datadb | Query | 20 | Sorting result | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  424. | 20770982 | datadb | server1.domain.com:63168 | datadb | Query | 20 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  425. | 20770984 | datadb | server1.domain.com:63170 | datadb | Query | 20 | Sorting result | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  426. | 20770986 | datadb | server1.domain.com:63176 | datadb | Query | 19 | Sorting result | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  427. | 20770988 | datadb | server1.domain.com:63194 | datadb | Query | 18 | Sorting result | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  428. | 20770990 | datadb | server1.domain.com:63207 | datadb | Query | 17 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  429. | 20770992 | datadb | server1.domain.com:63209 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  430. | 20770994 | datadb | server1.domain.com:63218 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  431. | 20770996 | datadb | server1.domain.com:63220 | datadb | Query | 17 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  432. | 20770998 | datadb | server1.domain.com:63222 | datadb | Query | 16 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  433. | 20771000 | datadb | server1.domain.com:63224 | datadb | Query | 0 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  434. | 20771004 | datadb | server1.domain.com:63230 | datadb | Query | 14 | Sorting result | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  435. | 20771006 | datadb | server1.domain.com:63232 | datadb | Query | 14 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  436. | 20771010 | datadb | server1.domain.com:63240 | datadb | Query | 13 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  437. | 20771014 | datadb | server1.domain.com:63252 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'eurozone-consumer-morale-unexpectedly-recovers-in-may% |
  438. | 20771016 | datadb | server1.domain.com:63254 | datadb | Query | 11 | Sorting result | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  439. | 20771018 | datadb | server1.domain.com:63256 | datadb | Query | 0 | Copying to tmp table | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  440. | 20771020 | datadb | server1.domain.com:63260 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  441. | 20771022 | datadb | server1.domain.com:63264 | datadb | Query | 11 | Sorting result | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  442. | 20771024 | datadb | server1.domain.com:63266 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  443. | 20771030 | datadb | server1.domain.com:63290 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  444. | 20771034 | datadb | server1.domain.com:63296 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'us-data-apr-bls-mass-layoffs-in-april-employers%' AND |
  445. | 20771038 | datadb | server1.domain.com:63304 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  446. | 20771040 | datadb | server1.domain.com:63318 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'us-data-apr-bls-mass-layoffs-in-april-employers%' AND |
  447. | 20771044 | datadb | server1.domain.com:63322 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  448. | 20771052 | datadb | server1.domain.com:63330 | datadb | Query | 0 | Locked | SELECT post_id FROM wp_postmeta, wp_posts WHERE ID = post_id AND post_type = 'post' AND meta_key = ' |
  449. | 20771054 | datadb | server1.domain.com:63332 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  450. | 20771056 | datadb | server1.domain.com:63336 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  451. | 20771058 | datadb | server1.domain.com:63342 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  452. | 20771060 | datadb | server1.domain.com:63346 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  453. | 20771062 | datadb | server1.domain.com:63348 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  454. | 20771066 | datadb | server1.domain.com:63360 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  455. | 20771074 | datadb | server1.domain.com:63374 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  456. | 20771076 | datadb | server1.domain.com:63376 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  457. | 20771078 | datadb | server1.domain.com:63378 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'us-pending-home-sales-6-4-in-sept%' AND post_status = |
  458. | 20771082 | datadb | server1.domain.com:63386 | datadb | Query | 0 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  459. | 20771084 | datadb | server1.domain.com:63392 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  460. | 20771086 | datadb | server1.domain.com:63422 | datadb | Query | 0 | Locked | SELECT ID, post_name, post_parent FROM wp_posts WHERE post_name IN ('economic-calendar') AND (post_t |
  461. | 20771090 | datadb | server1.domain.com:63426 | datadb | Query | 0 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  462. | 20771092 | datadb | server1.domain.com:63430 | datadb | Query | 0 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'us-data-apr-bls-mass-layoffs-in-april-employers%' AND |
  463. +----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
  464. 182 rows in set (0.00 sec)
  465.  
  466. mysql>
  467. mysql>
  468. mysql> show processlist;
  469. +----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
  470. | Id | User | Host | db | Command | Time | State | Info |
  471. +----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
  472. | 1 | system user | | datadb | Connect | 144 | Locked | UPDATE `wp_posts` SET `post_author` = 87, `post_date` = '2012-02-16 21:27:31', `post_date_gmt` = '20 |
  473. | 2 | system user | | NULL | Connect | 7180020 | Waiting for master to send event | NULL |
  474. | 20769955 | root | localhost | datadb | Query | 0 | NULL | show processlist |
  475. | 20770433 | datadb | server1.domain.com:62035 | datadb | Query | 37 | Copying to tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  476. | 20770435 | datadb | server1.domain.com:62037 | datadb | Query | 37 | Copying to tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  477. | 20770437 | datadb | server1.domain.com:62041 | datadb | Query | 37 | Copying to tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  478. | 20770439 | datadb | server1.domain.com:62043 | datadb | Query | 37 | Copying to tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  479. | 20770443 | datadb | server1.domain.com:62051 | datadb | Query | 37 | Copying to tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  480. | 20770445 | datadb | server1.domain.com:62055 | datadb | Query | 37 | Copying to tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  481. | 20770493 | datadb | server1.domain.com:62159 | datadb | Query | 37 | Copying to tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  482. | 20770557 | datadb | server1.domain.com:62293 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  483. | 20770585 | datadb | server1.domain.com:62347 | datadb | Query | 30 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  484. | 20770599 | datadb | server1.domain.com:62382 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  485. | 20770607 | datadb | server1.domain.com:62403 | datadb | Query | 25 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  486. | 20770609 | datadb | server1.domain.com:62405 | datadb | Query | 22 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  487. | 20770611 | datadb | server1.domain.com:62407 | datadb | Query | 20 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  488. | 20770615 | datadb | server1.domain.com:62413 | datadb | Query | 26 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  489. | 20770627 | datadb | server1.domain.com:62441 | datadb | Query | 21 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  490. | 20770633 | datadb | server1.domain.com:62462 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  491. | 20770635 | datadb | server1.domain.com:62464 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  492. | 20770637 | datadb | server1.domain.com:62466 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  493. | 20770639 | datadb | server1.domain.com:62468 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  494. | 20770641 | datadb | server1.domain.com:62470 | datadb | Query | 21 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  495. | 20770645 | datadb | server1.domain.com:62484 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  496. | 20770648 | datadb | server1.domain.com:62493 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  497. | 20770649 | datadb | server1.domain.com:62494 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  498. | 20770651 | datadb | server1.domain.com:62496 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  499. | 20770653 | datadb | server1.domain.com:62500 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  500. | 20770655 | datadb | server1.domain.com:62506 | datadb | Query | 30 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  501. | 20770657 | datadb | server1.domain.com:62508 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  502. | 20770661 | datadb | server1.domain.com:62513 | datadb | Query | 22 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  503. | 20770663 | datadb | server1.domain.com:62519 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  504. | 20770669 | datadb | server1.domain.com:62531 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  505. | 20770671 | datadb | server1.domain.com:62537 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  506. | 20770673 | datadb | server1.domain.com:62545 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  507. | 20770677 | datadb | server1.domain.com:62552 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  508. | 20770679 | datadb | server1.domain.com:62554 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  509. | 20770683 | datadb | server1.domain.com:62558 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  510. | 20770685 | datadb | server1.domain.com:62566 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  511. | 20770687 | datadb | server1.domain.com:62570 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  512. | 20770689 | datadb | server1.domain.com:62576 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  513. | 20770691 | datadb | server1.domain.com:62578 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  514. | 20770693 | datadb | server1.domain.com:62580 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  515. | 20770700 | datadb | server1.domain.com:62593 | datadb | Query | 22 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  516. | 20770707 | datadb | server1.domain.com:62606 | datadb | Query | 22 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  517. | 20770717 | datadb | server1.domain.com:62624 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  518. | 20770719 | datadb | server1.domain.com:62628 | datadb | Query | 30 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  519. | 20770727 | datadb | server1.domain.com:62648 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  520. | 20770729 | datadb | server1.domain.com:62651 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  521. | 20770731 | datadb | server1.domain.com:62658 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  522. | 20770733 | datadb | server1.domain.com:62668 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  523. | 20770735 | datadb | server1.domain.com:62672 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  524. | 20770737 | datadb | server1.domain.com:62674 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  525. | 20770739 | datadb | server1.domain.com:62676 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  526. | 20770741 | datadb | server1.domain.com:62682 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  527. | 20770743 | datadb | server1.domain.com:62684 | datadb | Query | 39 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  528. | 20770747 | datadb | server1.domain.com:62698 | datadb | Query | 39 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  529. | 20770749 | datadb | server1.domain.com:62704 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  530. | 20770757 | datadb | server1.domain.com:62726 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  531. | 20770761 | datadb | server1.domain.com:62732 | datadb | Query | 25 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  532. | 20770765 | datadb | server1.domain.com:62742 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  533. | 20770771 | datadb | server1.domain.com:62752 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  534. | 20770779 | datadb | server1.domain.com:62771 | datadb | Query | 30 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  535. | 20770783 | datadb | server1.domain.com:62777 | datadb | Query | 26 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  536. | 20770785 | datadb | server1.domain.com:62785 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  537. | 20770787 | datadb | server1.domain.com:62791 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  538. | 20770789 | datadb | server1.domain.com:62795 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  539. | 20770791 | datadb | server1.domain.com:62799 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  540. | 20770793 | datadb | server1.domain.com:62807 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  541. | 20770795 | datadb | server1.domain.com:62809 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  542. | 20770800 | datadb | server1.domain.com:62820 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  543. | 20770801 | datadb | server1.domain.com:62821 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  544. | 20770807 | datadb | server1.domain.com:62831 | datadb | Query | 39 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  545. | 20770813 | datadb | server1.domain.com:62850 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  546. | 20770815 | datadb | server1.domain.com:62854 | datadb | Query | 30 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  547. | 20770829 | datadb | server1.domain.com:62872 | datadb | Query | 39 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  548. | 20770833 | datadb | server1.domain.com:62876 | datadb | Query | 30 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2012-05-14 15:15:49' AND p.post_type = 'post' AN |
  549. | 20770835 | datadb | server1.domain.com:62880 | datadb | Query | 39 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  550. | 20770843 | datadb | server1.domain.com:62900 | datadb | Query | 30 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2012-05-22 08:31:46' AND p.post_type = 'post' AN |
  551. | 20770845 | datadb | server1.domain.com:62906 | datadb | Query | 30 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2012-05-21 18:34:50' AND p.post_type = 'post' AN |
  552. | 20770849 | datadb | server1.domain.com:62914 | datadb | Query | 39 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  553. | 20770853 | datadb | server1.domain.com:62918 | datadb | Query | 39 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  554. | 20770855 | datadb | server1.domain.com:62924 | datadb | Query | 39 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  555. | 20770857 | datadb | server1.domain.com:62926 | datadb | Query | 30 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2012-05-22 10:37:01' AND p.post_type = 'post' AN |
  556. | 20770859 | datadb | server1.domain.com:62935 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  557. | 20770861 | datadb | server1.domain.com:62937 | datadb | Query | 39 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  558. | 20770865 | datadb | server1.domain.com:62943 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  559. | 20770867 | datadb | server1.domain.com:62947 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  560. | 20770871 | datadb | server1.domain.com:62951 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  561. | 20770876 | datadb | server1.domain.com:62959 | datadb | Query | 30 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2012-05-17 21:27:28' AND p.post_type = 'post' AN |
  562. | 20770880 | datadb | server1.domain.com:62971 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  563. | 20770882 | datadb | server1.domain.com:62975 | datadb | Query | 14 | Locked | SELECT * from wp_posts JOIN wp_term_relationships ON (wp_term_relationships.object_id=ID) WHERE ID |
  564. | 20770890 | datadb | server1.domain.com:62991 | datadb | Query | 30 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2012-05-22 08:31:46' AND p.post_type = 'post' AN |
  565. | 20770892 | datadb | server1.domain.com:62993 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  566. | 20770894 | datadb | server1.domain.com:62999 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  567. | 20770896 | datadb | server1.domain.com:63001 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  568. | 20770899 | datadb | server1.domain.com:63004 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_ord |
  569. | 20770900 | datadb | server1.domain.com:63005 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  570. | 20770902 | datadb | server1.domain.com:63019 | datadb | Query | 15 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  571. | 20770904 | datadb | server1.domain.com:63029 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  572. | 20770906 | datadb | server1.domain.com:63031 | datadb | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  573. | 20770908 | datadb | server1.domain.com:63036 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  574. | 20770910 | datadb | server1.domain.com:63052 | datadb | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  575. | 20770912 | datadb | server1.domain.com:63054 | datadb | Query | 14 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  576. | 20770914 | datadb | server1.domain.com:63060 | datadb | Query | 15 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  577. | 20770918 | datadb | server1.domain.com:63068 | datadb | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  578. | 20770920 | datadb | server1.domain.com:63076 | datadb | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  579. | 20770928 | datadb | server1.domain.com:63086 | datadb | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  580. | 20770930 | datadb | server1.domain.com:63088 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  581. | 20770932 | datadb | server1.domain.com:63090 | datadb | Query | 14 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-03-13 20:30:33' AND p.post_type = 'post' AN |
  582. | 20770934 | datadb | server1.domain.com:63092 | datadb | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  583. | 20770936 | datadb | server1.domain.com:63094 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  584. | 20770941 | datadb | server1.domain.com:63105 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  585. | 20770945 | datadb | server1.domain.com:63111 | datadb | Query | 17 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  586. | 20770950 | datadb | server1.domain.com:63119 | datadb | Query | 16 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  587. | 20770952 | datadb | server1.domain.com:63124 | datadb | Query | 16 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  588. | 20770954 | datadb | server1.domain.com:63128 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  589. | 20770956 | datadb | server1.domain.com:63130 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  590. | 20770958 | datadb | server1.domain.com:63134 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  591. | 20770960 | datadb | server1.domain.com:63136 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  592. | 20770962 | datadb | server1.domain.com:63140 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  593. | 20770964 | datadb | server1.domain.com:63142 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  594. | 20770966 | datadb | server1.domain.com:63144 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  595. | 20770968 | datadb | server1.domain.com:63146 | datadb | Query | 16 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  596. | 20770970 | datadb | server1.domain.com:63150 | datadb | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  597. | 20770972 | datadb | server1.domain.com:63154 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  598. | 20770974 | datadb | server1.domain.com:63158 | datadb | Query | 30 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2012-05-19 16:50:01' AND p.post_type = 'post' AN |
  599. | 20770978 | datadb | server1.domain.com:63162 | datadb | Query | 14 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  600. | 20770982 | datadb | server1.domain.com:63168 | datadb | Query | 14 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  601. | 20770984 | datadb | server1.domain.com:63170 | datadb | Query | 16 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  602. | 20770986 | datadb | server1.domain.com:63176 | datadb | Query | 14 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  603. | 20770988 | datadb | server1.domain.com:63194 | datadb | Query | 15 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  604. | 20770990 | datadb | server1.domain.com:63207 | datadb | Query | 30 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  605. | 20770992 | datadb | server1.domain.com:63209 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  606. | 20770994 | datadb | server1.domain.com:63218 | datadb | Query | 15 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2011-12-12 17:01:08' AND p.post_type = 'post' AN |
  607. | 20770996 | datadb | server1.domain.com:63220 | datadb | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  608. | 20770998 | datadb | server1.domain.com:63222 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  609. | 20771000 | datadb | server1.domain.com:63224 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  610. | 20771004 | datadb | server1.domain.com:63230 | datadb | Query | 14 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  611. | 20771006 | datadb | server1.domain.com:63232 | datadb | Query | 30 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  612. | 20771010 | datadb | server1.domain.com:63240 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  613. | 20771014 | datadb | server1.domain.com:63252 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  614. | 20771016 | datadb | server1.domain.com:63254 | datadb | Query | 15 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  615. | 20771018 | datadb | server1.domain.com:63256 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  616. | 20771020 | datadb | server1.domain.com:63260 | datadb | Query | 15 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-02-17 00:49:10' AND p.post_type = 'post' AN |
  617. | 20771022 | datadb | server1.domain.com:63264 | datadb | Query | 14 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  618. | 20771024 | datadb | server1.domain.com:63266 | datadb | Query | 15 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-05-18 03:20:01' AND p.post_type = 'post' AN |
  619. | 20771030 | datadb | server1.domain.com:63290 | datadb | Query | 14 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-02-17 00:49:10' AND p.post_type = 'post' AN |
  620. | 20771034 | datadb | server1.domain.com:63296 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  621. | 20771038 | datadb | server1.domain.com:63304 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  622. | 20771040 | datadb | server1.domain.com:63318 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  623. | 20771044 | datadb | server1.domain.com:63322 | datadb | Query | 16 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-05-22 14:02:58' AND p.post_type = 'post' AN |
  624. | 20771052 | datadb | server1.domain.com:63330 | datadb | Query | 30 | Locked | SELECT ID FROM wp_posts WHERE post_name LIKE 'richmond-fed-4-vs-11-exp%' AND YEAR(post_date) = 2012 |
  625. | 20771054 | datadb | server1.domain.com:63332 | datadb | Query | 17 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  626. | 20771056 | datadb | server1.domain.com:63336 | datadb | Query | 16 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-05-22 14:02:58' AND p.post_type = 'post' AN |
  627. | 20771058 | datadb | server1.domain.com:63342 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  628. | 20771060 | datadb | server1.domain.com:63346 | datadb | Query | 39 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  629. | 20771062 | datadb | server1.domain.com:63348 | datadb | Query | 17 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
  630. | 20771066 | datadb | server1.domain.com:63360 | datadb | Query | 16 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-05-22 14:05:41' AND p.post_type = 'post' AN |
  631. | 20771074 | datadb | server1.domain.com:63374 | datadb | Query | 14 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-05-22 14:02:58' AND p.post_type = 'post' AN |
  632. | 20771076 | datadb | server1.domain.com:63376 | datadb | Query | 15 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-05-22 14:05:41' AND p.post_type = 'post' AN |
  633. | 20771078 | datadb | server1.domain.com:63378 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 54609 LIMIT 1 |
  634. | 20771082 | datadb | server1.domain.com:63386 | datadb | Query | 16 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-05-22 14:02:58' AND p.post_type = 'post' AN |
  635. | 20771084 | datadb | server1.domain.com:63392 | datadb | Query | 39 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  636. | 20771086 | datadb | server1.domain.com:63422 | datadb | Query | 30 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.ID = '5932') AND wp_posts.post_type = 'p |
  637. | 20771090 | datadb | server1.domain.com:63426 | datadb | Query | 16 | Locked | SELECT post_date_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', ' |
  638. | 20771092 | datadb | server1.domain.com:63430 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  639. | 20771094 | datadb | server1.domain.com:63432 | datadb | Query | 15 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  640. | 20771096 | datadb | server1.domain.com:63436 | datadb | Query | 30 | Locked | SELECT count(1) FROM wp_posts WHERE post_status = 'draft' AND ID = 215121 |
  641. | 20771100 | datadb | server1.domain.com:63446 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  642. | 20771102 | datadb | server1.domain.com:63454 | datadb | Query | 15 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  643. | 20771106 | datadb | server1.domain.com:63476 | datadb | Query | 30 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.ID = '0') AND wp_posts.post_type = 'page |
  644. | 20771108 | datadb | server1.domain.com:63478 | datadb | Query | 30 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (238094,238112,23 |
  645. | 20771110 | datadb | server1.domain.com:63482 | datadb | Query | 30 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (238094,238112,23 |
  646. | 20771112 | datadb | server1.domain.com:63484 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  647. | 20771114 | datadb | server1.domain.com:63488 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  648. | 20771116 | datadb | server1.domain.com:63490 | datadb | Query | 16 | Locked | SELECT post_date_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', ' |
  649. | 20771118 | datadb | server1.domain.com:63494 | datadb | Query | 16 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  650. | 20771120 | datadb | server1.domain.com:63496 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  651. | 20771122 | datadb | server1.domain.com:63502 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  652. | 20771124 | datadb | server1.domain.com:63504 | datadb | Query | 16 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  653. | 20771126 | datadb | server1.domain.com:63508 | datadb | Query | 30 | Locked | SELECT post_id FROM wp_postmeta, wp_posts WHERE ID = post_id AND post_type = 'post' AND meta_key = ' |
  654. | 20771128 | datadb | server1.domain.com:63512 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  655. | 20771130 | datadb | server1.domain.com:63514 | datadb | Query | 16 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  656. | 20771134 | datadb | server1.domain.com:63518 | datadb | Query | 30 | Locked | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHE |
  657. | 20771136 | datadb | server1.domain.com:63520 | datadb | Query | 14 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  658. | 20771138 | datadb | server1.domain.com:63524 | datadb | Query | 15 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  659. | 20771142 | datadb | server1.domain.com:63528 | datadb | Query | 30 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  660. | 20771146 | datadb | server1.domain.com:63537 | datadb | Query | 29 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  661. | 20771148 | datadb | server1.domain.com:63543 | datadb | Query | 29 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  662. | 20771150 | datadb | server1.domain.com:63547 | datadb | Query | 29 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  663. | 20771152 | datadb | server1.domain.com:63549 | datadb | Query | 29 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  664. | 20771154 | datadb | server1.domain.com:63551 | datadb | Query | 28 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  665. | 20771156 | datadb | server1.domain.com:63553 | datadb | Query | 28 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  666. | 20771158 | datadb | server1.domain.com:63557 | datadb | Query | 28 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  667. | 20771160 | datadb | server1.domain.com:63565 | datadb | Query | 28 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  668. | 20771162 | datadb | server1.domain.com:63572 | datadb | Query | 27 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  669. | 20771164 | datadb | server1.domain.com:63578 | datadb | Query | 27 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  670. | 20771166 | datadb | server1.domain.com:63583 | datadb | Query | 26 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  671. | 20771168 | datadb | server1.domain.com:63585 | datadb | Query | 26 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  672. | 20771170 | datadb | server1.domain.com:63587 | datadb | Query | 26 | Locked | SELECT post_id FROM wp_postmeta, wp_posts WHERE ID = post_id AND post_type = 'post' AND meta_key = ' |
  673. | 20771172 | datadb | server1.domain.com:63589 | datadb | Query | 26 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  674. | 20771174 | datadb | server1.domain.com:63595 | datadb | Query | 26 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  675. | 20771176 | datadb | server1.domain.com:63597 | datadb | Query | 26 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  676. | 20771178 | datadb | server1.domain.com:63605 | datadb | Query | 25 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  677. | 20771180 | datadb | server1.domain.com:63609 | datadb | Query | 25 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  678. | 20771182 | datadb | server1.domain.com:63615 | datadb | Query | 25 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  679. | 20771184 | datadb | server1.domain.com:63617 | datadb | Query | 25 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  680. | 20771186 | datadb | server1.domain.com:63625 | datadb | Query | 25 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  681. | 20771188 | datadb | server1.domain.com:63627 | datadb | Query | 24 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  682. | 20771190 | datadb | server1.domain.com:63629 | datadb | Query | 24 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.ID = '5932') AND wp_posts.post_type = 'p |
  683. | 20771192 | datadb | server1.domain.com:63641 | datadb | Query | 23 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  684. | 20771194 | datadb | server1.domain.com:63643 | datadb | Query | 23 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  685. | 20771196 | datadb | server1.domain.com:63647 | datadb | Query | 23 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  686. | 20771198 | datadb | server1.domain.com:63651 | datadb | Query | 23 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  687. | 20771200 | datadb | server1.domain.com:63657 | datadb | Query | 23 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  688. | 20771202 | datadb | server1.domain.com:63661 | datadb | Query | 23 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  689. | 20771204 | datadb | server1.domain.com:63673 | datadb | Query | 22 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
  690. | 20771206 | datadb | server1.domain.com:63676 | datadb | Query | 22 | Locked | SELECT ID, post_name, post_parent FROM wp_posts WHERE post_name IN ('apple-touch-icon-precomposed-pn |
  691. | 20771208 | datadb | server1.domain.com:63678 | datadb | Query | 22 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  692. | 20771210 | datadb | server1.domain.com:63680 | datadb | Query | 22 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  693. | 20771212 | datadb | server1.domain.com:63688 | datadb | Query | 21 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2010' AND MONTH(wp_posts |
  694. | 20771214 | datadb | server1.domain.com:63698 | datadb | Query | 20 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2011' AND MONTH(wp_posts |
  695. | 20771216 | datadb | server1.domain.com:63700 | datadb | Query | 19 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  696. | 20771218 | datadb | server1.domain.com:63704 | datadb | Query | 19 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  697. | 20771232 | datadb | server1.domain.com:63743 | datadb | Query | 17 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  698. | 20771234 | datadb | server1.domain.com:63745 | datadb | Query | 17 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  699. | 20771236 | datadb | server1.domain.com:63750 | datadb | Query | 16 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  700. | 20771238 | datadb | server1.domain.com:63753 | datadb | Query | 16 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  701. | 20771240 | datadb | server1.domain.com:63757 | datadb | Query | 15 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  702. | 20771242 | datadb | server1.domain.com:63762 | datadb | Query | 15 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  703. | 20771244 | datadb | server1.domain.com:63764 | datadb | Query | 15 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  704. | 20771246 | datadb | server1.domain.com:63771 | datadb | Query | 15 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  705. | 20771248 | datadb | server1.domain.com:63779 | datadb | Query | 14 | Locked | SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page |
  706. | 20771250 | datadb | server1.domain.com:63792 | datadb | Query | 14 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  707. | 20771254 | datadb | server1.domain.com:63801 | datadb | Query | 14 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  708. | 20771256 | datadb | server1.domain.com:63803 | datadb | Query | 13 | Locked | SELECT ID, post_name, post_parent FROM wp_posts WHERE post_name IN ('114914','all','eurusd-dumps-on- |
  709. | 20771258 | datadb | server1.domain.com:63805 | datadb | Query | 13 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  710. | 20771260 | datadb | server1.domain.com:63807 | datadb | Query | 13 | Locked | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2012-05-21 09:11:13' AND p.post_type = 'post' AN |
  711. | 20771266 | datadb | server1.domain.com:63815 | datadb | Query | 13 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  712. | 20771268 | datadb | server1.domain.com:63823 | datadb | Query | 11 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  713. | 20771270 | datadb | server1.domain.com:63825 | datadb | Query | 11 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  714. | 20771272 | datadb | server1.domain.com:63827 | datadb | Query | 11 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  715. | 20771276 | datadb | server1.domain.com:63841 | datadb | Query | 10 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  716. | 20771283 | datadb | server1.domain.com:63857 | datadb | Query | 9 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  717. | 20771287 | datadb | server1.domain.com:63863 | datadb | Query | 8 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  718. | 20771289 | datadb | server1.domain.com:63867 | datadb | Query | 8 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (238094,238112,23 |
  719. | 20771291 | datadb | server1.domain.com:63874 | datadb | Query | 7 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  720. | 20771293 | datadb | server1.domain.com:63877 | datadb | Query | 7 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  721. | 20771295 | datadb | server1.domain.com:63881 | datadb | Query | 7 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  722. | 20771297 | datadb | server1.domain.com:63889 | datadb | Query | 6 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  723. | 20771299 | datadb | server1.domain.com:63900 | datadb | Query | 4 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  724. | 20771305 | datadb | server1.domain.com:63910 | datadb | Query | 4 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  725. | 20771307 | datadb | server1.domain.com:63922 | datadb | Query | 3 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  726. | 20771309 | datadb | server1.domain.com:63924 | datadb | Query | 3 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2010' AND MONTH(wp_posts |
  727. | 20771311 | datadb | server1.domain.com:63926 | datadb | Query | 3 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  728. | 20771313 | datadb | server1.domain.com:63935 | datadb | Query | 2 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts |
  729. | 20771315 | datadb | server1.domain.com:63937 | datadb | Query | 2 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  730. | 20771317 | datadb | server1.domain.com:63939 | datadb | Query | 2 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  731. | 20771319 | datadb | server1.domain.com:63947 | datadb | Query | 2 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author = 53) AND |
  732. | 20771323 | datadb | server1.domain.com:63951 | datadb | Query | 2 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.post_author != 87) AN |
  733. | 20771325 | datadb | server1.domain.com:63953 | datadb | Query | 1 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  734. | 20771327 | datadb | server1.domain.com:63959 | datadb | Query | 1 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  735. | 20771329 | datadb | server1.domain.com:63963 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  736. | 20771331 | datadb | server1.domain.com:63965 | datadb | Query | 0 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
  737. +----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
  738. 265 rows in set (0.00 sec)
  739.  
  740. mysql>
  741. Bye
  742. ]0;root@db1.domain.com:~You have new mail in /var/spool/mail/root
  743. [root@db1.domain.com ~]# uptime
  744. 10:13:34 up 83 days, 3:29, 2 users, load average: 55.69, 30.47, 14.25