Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

mysql_under_stress

By: a guest on May 31st, 2012  |  syntax: None  |  size: 113.08 KB  |  views: 33  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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