Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement