mysql>
mysql> show processlist\G;
*************************** 1. row ***************************
Id: 1
User: system user
Host:
db: datadb
Command: Connect
Time: 61
State: Locked
Info: UPDATE `wp_posts` SET `post_parent` = 0 WHERE `post_parent` = 236849 AND `post_type` = 'attachment'
*************************** 2. row ***************************
Id: 2
User: system user
Host:
db: NULL
Command: Connect
Time: 7179883
State: Waiting for master to send event
Info: NULL
*************************** 3. row ***************************
Id: 20769851
User: datadb
Host: server1.domain.com:60491
db: datadb
Command: Query
Time: 8
State: Copying to tmp table
Info: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati
*************************** 4. row ***************************
Id: 20769948
User: datadb
Host: server1.domain.com:60746
db: datadb
Command: Query
Time: 8
State: Copying to tmp table
Info: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati
*************************** 5. row ***************************
Id: 20769955
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
*************************** 6. row ***************************
Id: 20770129
User: datadb
Host: server1.domain.com:61300
db: datadb
Command: Query
Time: 8
State: Copying to tmp table
Info: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati
*************************** 7. row ***************************
Id: 20770133
User: datadb
Host: server1.domain.com:61329
db: datadb
Command: Query
Time: 14
State: Copying to tmp table
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 8. row ***************************
Id: 20770149
User: datadb
Host: server1.domain.com:61369
db: datadb
Command: Query
Time: 14
State: Copying to tmp table
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 9. row ***************************
Id: 20770239
User: datadb
Host: server1.domain.com:61594
db: datadb
Command: Sleep
Time: 1
State:
Info: NULL
*************************** 10. row ***************************
Id: 20770259
User: datadb
Host: server1.domain.com:61645
db: datadb
Command: Query
Time: 12
State: Copying to tmp table
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 11. row ***************************
Id: 20770263
User: datadb
Host: server1.domain.com:61661
db: datadb
Command: Query
Time: 11
State: Copying to tmp table
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 12. row ***************************
Id: 20770273
User: datadb
Host: server1.domain.com:61683
db: datadb
Command: Query
Time: 10
State: Copying to tmp table
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 13. row ***************************
Id: 20770281
User: datadb
Host: server1.domain.com:61711
db: datadb
Command: Query
Time: 8
State: Copying to tmp table
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 14. row ***************************
Id: 20770287
User: datadb
Host: server1.domain.com:61729
db: datadb
Command: Query
Time: 6
State: Copying to tmp table
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 15. row ***************************
Id: 20770299
User: datadb
Host: server1.domain.com:61763
db: datadb
Command: Query
Time: 5
State: Copying to tmp table
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 16. row ***************************
Id: 20770311
User: datadb
Host: server1.domain.com:61801
db: datadb
Command: Query
Time: 4
State: Locked
Info: SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2011' AND MONTH(wp_posts
*************************** 17. row ***************************
Id: 20770321
User: datadb
Host: server1.domain.com:61822
db: datadb
Command: Query
Time: 4
State: Locked
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 18. row ***************************
Id: 20770327
User: datadb
Host: server1.domain.com:61832
db: datadb
Command: Query
Time: 3
State: Locked
Info: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.
*************************** 19. row ***************************
Id: 20770333
User: datadb
Host: server1.domain.com:61853
db: datadb
Command: Query
Time: 2
State: Locked
Info: SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2012' AND MONTH(wp_posts
*************************** 20. row ***************************
Id: 20770335
User: datadb
Host: server1.domain.com:61861
db: datadb
Command: Query
Time: 1
State: Locked
Info: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati
*************************** 21. row ***************************
Id: 20770337
User: datadb
Host: server1.domain.com:61866
db: datadb
Command: Query
Time: 1
State: Locked
Info: SELECT ID, post_name, post_parent FROM wp_posts WHERE post_name IN ('aquiremediafeedreader') AND (po
*************************** 22. row ***************************
Id: 20770353
User: datadb
Host: server1.domain.com:61880
db: datadb
Command: Sleep
Time: 0
State:
Info: NULL
22 rows in set (0.00 sec)
ERROR:
No query specified
mysql> show processlist\G;
[C[C[C[C[C[C[C[Kshow processlist\G;[1P;[1P;
+----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
| 1 | system user | | datadb | Connect | 70 | Locked | UPDATE `wp_posts` SET `guid` = 'http://www.forexlive.com/?p=238119' WHERE `ID` = 238119 |
| 2 | system user | | NULL | Connect | 7179894 | Waiting for master to send event | NULL |
| 20769955 | root | localhost | NULL | Query | 0 | NULL | show processlist |
| 20770239 | datadb | server1.domain.com:61594 | datadb | Sleep | 0 | | NULL |
| 20770287 | datadb | server1.domain.com:61729 | datadb | Query | 1 | Locked | SELECT * FROM wp_posts WHERE ID = 238112 LIMIT 1 |
| 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. |
| 20770337 | datadb | server1.domain.com:61866 | datadb | Sleep | 3 | | NULL |
| 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. |
| 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 |
| 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 |
| 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 |
| 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', ' |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
+----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
27 rows in set (0.00 sec)
mysql> \d[K[Kds[Kesc wp_post;[Ks;
ERROR 1046 (3D000): No database selected
mysql> use datadb;
Database changed
mysql> use datadb;
[C[C[C[C[C[C[C[2Pdesc wp_posts;
+-----------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+---------------------+------+-----+---------------------+----------------+
| ID | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| post_author | bigint(20) unsigned | NO | MUL | 0 | |
| post_date | datetime | NO | | 0000-00-00 00:00:00 | |
| post_date_gmt | datetime | NO | | 0000-00-00 00:00:00 | |
| post_content | longtext | NO | | NULL | |
| post_title | text | NO | | NULL | |
| post_category | int(4) | NO | | 0 | |
| post_excerpt | text | NO | | NULL | |
| post_status | varchar(20) | NO | MUL | publish | |
| comment_status | varchar(20) | NO | | open | |
| ping_status | varchar(20) | NO | | open | |
| post_password | varchar(20) | NO | | | |
| post_name | varchar(200) | NO | MUL | | |
| to_ping | text | NO | | NULL | |
| pinged | text | NO | | NULL | |
| post_modified | datetime | NO | | 0000-00-00 00:00:00 | |
| post_modified_gmt | datetime | NO | | 0000-00-00 00:00:00 | |
| post_content_filtered | text | NO | | NULL | |
| post_parent | bigint(20) unsigned | NO | MUL | 0 | |
| guid | varchar(255) | NO | | | |
| menu_order | int(11) | NO | | 0 | |
| post_type | varchar(20) | NO | MUL | post | |
| post_mime_type | varchar(100) | NO | | | |
| comment_count | bigint(20) | NO | | 0 | |
+-----------------------+---------------------+------+-----+---------------------+----------------+
24 rows in set (0.01 sec)
[C[C[C[C[C[C[Cshow processlist;
+----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
| 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 |
| 2 | system user | | NULL | Connect | 7179981 | Waiting for master to send event | NULL |
| 20769955 | root | localhost | datadb | Query | 0 | NULL | show processlist |
| 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 |
| 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 |
| 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 |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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 |
| 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 |
| 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 |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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. |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 20770823 | datadb | server1.domain.com:62864 | datadb | Sleep | 0 | | NULL |
| 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. |
| 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 |
| 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. |
| 20770841 | datadb | server1.domain.com:62898 | datadb | Sleep | 0 | | NULL |
| 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 |
| 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 |
| 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. |
| 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. |
| 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. |
| 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 |
| 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 |
| 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. |
| 20770863 | datadb | server1.domain.com:62939 | datadb | Sleep | 0 | | NULL |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 20770922 | datadb | server1.domain.com:63078 | datadb | Sleep | 0 | | NULL |
| 20770924 | datadb | server1.domain.com:63080 | datadb | Sleep | 0 | | NULL |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 = ' |
| 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 |
| 20770942 | datadb | server1.domain.com:63106 | datadb | Sleep | 0 | | NULL |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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% |
| 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 |
| 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 |
| 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 = ' |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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% |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 = ' |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 = |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
+----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
182 rows in set (0.00 sec)
mysql>
[Kmysql>
[Kmysql> show processlist;
+----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
| 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 |
| 2 | system user | | NULL | Connect | 7180020 | Waiting for master to send event | NULL |
| 20769955 | root | localhost | datadb | Query | 0 | NULL | show processlist |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 20770557 | datadb | server1.domain.com:62293 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 20770599 | datadb | server1.domain.com:62382 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 20770633 | datadb | server1.domain.com:62462 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770635 | datadb | server1.domain.com:62464 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770637 | datadb | server1.domain.com:62466 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770639 | datadb | server1.domain.com:62468 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 20770645 | datadb | server1.domain.com:62484 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770648 | datadb | server1.domain.com:62493 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770649 | datadb | server1.domain.com:62494 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770651 | datadb | server1.domain.com:62496 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770653 | datadb | server1.domain.com:62500 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 20770657 | datadb | server1.domain.com:62508 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 20770663 | datadb | server1.domain.com:62519 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770669 | datadb | server1.domain.com:62531 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770671 | datadb | server1.domain.com:62537 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770673 | datadb | server1.domain.com:62545 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770677 | datadb | server1.domain.com:62552 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770679 | datadb | server1.domain.com:62554 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770683 | datadb | server1.domain.com:62558 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770685 | datadb | server1.domain.com:62566 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770687 | datadb | server1.domain.com:62570 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770689 | datadb | server1.domain.com:62576 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770691 | datadb | server1.domain.com:62578 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770693 | datadb | server1.domain.com:62580 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 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. |
| 20770717 | datadb | server1.domain.com:62624 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 20770727 | datadb | server1.domain.com:62648 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770729 | datadb | server1.domain.com:62651 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770731 | datadb | server1.domain.com:62658 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770733 | datadb | server1.domain.com:62668 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770735 | datadb | server1.domain.com:62672 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770737 | datadb | server1.domain.com:62674 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770739 | datadb | server1.domain.com:62676 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770741 | datadb | server1.domain.com:62682 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 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. |
| 20770749 | datadb | server1.domain.com:62704 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770757 | datadb | server1.domain.com:62726 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 20770765 | datadb | server1.domain.com:62742 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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 |
| 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. |
| 20770785 | datadb | server1.domain.com:62785 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770787 | datadb | server1.domain.com:62791 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770789 | datadb | server1.domain.com:62795 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770791 | datadb | server1.domain.com:62799 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770793 | datadb | server1.domain.com:62807 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770795 | datadb | server1.domain.com:62809 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770800 | datadb | server1.domain.com:62820 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770801 | datadb | server1.domain.com:62821 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 20770813 | datadb | server1.domain.com:62850 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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. |
| 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 |
| 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. |
| 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 |
| 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 |
| 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. |
| 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. |
| 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. |
| 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 |
| 20770859 | datadb | server1.domain.com:62935 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 20770865 | datadb | server1.domain.com:62943 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770867 | datadb | server1.domain.com:62947 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770871 | datadb | server1.domain.com:62951 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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. |
| 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 |
| 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 |
| 20770892 | datadb | server1.domain.com:62993 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770894 | datadb | server1.domain.com:62999 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770896 | datadb | server1.domain.com:63001 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 20770900 | datadb | server1.domain.com:63005 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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 |
| 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. |
| 20770908 | datadb | server1.domain.com:63036 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 20770930 | datadb | server1.domain.com:63088 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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. |
| 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 |
| 20770941 | datadb | server1.domain.com:63105 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770945 | datadb | server1.domain.com:63111 | datadb | Query | 17 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770950 | datadb | server1.domain.com:63119 | datadb | Query | 16 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770952 | datadb | server1.domain.com:63124 | datadb | Query | 16 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 20770956 | datadb | server1.domain.com:63130 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770958 | datadb | server1.domain.com:63134 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770960 | datadb | server1.domain.com:63136 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770962 | datadb | server1.domain.com:63140 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20770964 | datadb | server1.domain.com:63142 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 20770968 | datadb | server1.domain.com:63146 | datadb | Query | 16 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 20770972 | datadb | server1.domain.com:63154 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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. |
| 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 |
| 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. |
| 20770992 | datadb | server1.domain.com:63209 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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. |
| 20770998 | datadb | server1.domain.com:63222 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20771000 | datadb | server1.domain.com:63224 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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. |
| 20771010 | datadb | server1.domain.com:63240 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20771014 | datadb | server1.domain.com:63252 | datadb | Query | 14 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 20771018 | datadb | server1.domain.com:63256 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 20771038 | datadb | server1.domain.com:63304 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 20771040 | datadb | server1.domain.com:63318 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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 |
| 20771054 | datadb | server1.domain.com:63332 | datadb | Query | 17 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 20771058 | datadb | server1.domain.com:63342 | datadb | Query | 15 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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. |
| 20771062 | datadb | server1.domain.com:63348 | datadb | Query | 17 | Locked | SELECT * FROM wp_posts WHERE ID = 238109 LIMIT 1 |
| 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 |
| 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 |
| 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 |
| 20771078 | datadb | server1.domain.com:63378 | datadb | Query | 30 | Locked | SELECT * FROM wp_posts WHERE ID = 54609 LIMIT 1 |
| 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 |
| 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. |
| 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 |
| 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', ' |
| 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 |
| 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. |
| 20771096 | datadb | server1.domain.com:63436 | datadb | Query | 30 | Locked | SELECT count(1) FROM wp_posts WHERE post_status = 'draft' AND ID = 215121 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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', ' |
| 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. |
| 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 |
| 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 |
| 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. |
| 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 = ' |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 = ' |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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- |
| 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. |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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. |
| 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. |
| 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 |
| 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 |
| 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. |
| 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 |
| 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 |
| 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. |
| 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 |
| 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. |
| 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 |
| 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. |
| 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 |
| 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. |
| 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. |
| 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 |
| 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 |
| 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. |
| 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. |
| 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. |
| 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. |
+----------+-------------+---------------------------+-------------+---------+---------+----------------------------------+------------------------------------------------------------------------------------------------------+
265 rows in set (0.00 sec)
mysql>
Bye
]0;root@db1.domain.com:~You have new mail in /var/spool/mail/root
[root@db1.domain.com ~]# uptime
10:13:34 up 83 days, 3:29, 2 users, load average: 55.69, 30.47, 14.25