Paste P7154

(An Untitled Masterwork)
ActivePublic
Actions

Authored by jcrespo on May 25 2018, 11:09 AM.

Tags

None

Referenced Files

	F18525708:
	May 25 2018, 11:09 AM

Subscribers

None

	$ ./mysql.py -h db1092 sys -e "SELECT * FROM statement_analysis LIMIT 10"
	+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+--------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
	\| query \| db \| full_scan \| exec_count \| err_count \| warn_count \| total_latency \| max_latency \| avg_latency \| lock_latency \| rows_sent \| rows_sent_avg \| rows_examined \| rows_examined_avg \| rows_affected \| rows_affected_avg \| tmp_tables \| tmp_disk_tables \| rows_sorted \| sort_merge_passes \| digest \| first_seen \| last_seen \|
	+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+--------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
	\| SELECT `chd_site` FROM `wb_cha ... DER BY `chd_seen` ASC LIMIT ? \| wikidatawiki \| * \| 2091637 \| 0 \| 0 \| 5.02 w \| 34.40 s \| 1.45 s \| 2.44 m \| 31369835 \| 15 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 7c5ab9603647a7a91a3dc928be60c3b7 \| 2018-01-16 16:33:10 \| 2018-05-25 08:39:38 \|
	\| SELECT `rev_id` , `rev_content ... ND ( ? = `page_namespace` ) ) \| wikidatawiki \| \| 4466782301 \| 2 \| 0 \| 2.51 w \| 10.13 s \| 339.92 us \| 4.61 d \| 4462205755 \| 1 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 60937b3d44adc51442f822f5d727d565 \| 2018-01-16 16:29:01 \| 2018-05-25 08:37:29 \|
	\| SELECT `ips_site_id` , `ips_si ... id` = ? AND `ips_site_id` = ? \| wikidatawiki \| \| 2883067366 \| 0 \| 0 \| 2.45 w \| 1.22 s \| 513.71 us \| 1.66 d \| 2026006567 \| 1 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 9f0112fff7a73df079e02be8d0960ace \| 2018-01-16 16:29:02 \| 2018-05-25 08:36:41 \|
	\| SELECT `term_type` , `term_lan ... uage` = ? AND `term_type` = ? \| wikidatawiki \| \| 398178711 \| 0 \| 0 \| 1.77 w \| 302.98 ms \| 2.70 ms \| 7.42 h \| 1614927823 \| 4 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 4abb06c571e26a48f28ccb3b73e89ea2 \| 2018-01-16 16:29:01 \| 2018-02-28 18:30:23 \|
	\| SELECT `ts` FROM `heartbeat` . ... ? ORDER BY `ts` DESC LIMIT ? \| wikidatawiki \| * \| 3498549202 \| 0 \| 0 \| 1.55 w \| 113.76 ms \| 268.31 us \| 2.94 d \| 3497840542 \| 1 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 3498808464 \| 0 \| f546ce5172e81fd91c3f1313888560e4 \| 2018-01-16 16:29:01 \| 2018-05-25 08:37:29 \|
	\| SELECT `term_type` , `term_lan ... uage` = ? AND `term_type` = ? \| wikidatawiki \| \| 993985985 \| 0 \| 0 \| 1.36 w \| 2.03 s \| 829.29 us \| 18.39 h \| 4135827032 \| 4 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| def08adf6c5656c17b3438e115aae4b5 \| 2018-02-26 15:11:20 \| 2018-05-25 08:36:42 \|
	\| SELECT `MASTER_GTID_WAIT` (...) \| NULL \| \| 1369277683 \| 0 \| 0 \| 1.25 w \| 1.00 m \| 551.04 us \| 0 ps \| 1369145799 \| 1 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 108c4653c7a13c3b7329db9b88272c68 \| 2018-01-16 16:29:03 \| 2018-05-25 08:42:03 \|
	\| SELECT `term_type` , `term_lan ... IN (...) AND `term_type` = ? \| wikidatawiki \| \| 1060029409 \| 0 \| 0 \| 6.59 d \| 1.21 s \| 537.04 us \| 18.11 h \| 2176443807 \| 2 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 48f26a6b3355cc64d2d728e762207c7e \| 2018-02-26 15:11:24 \| 2018-05-25 08:36:41 \|
	\| SELECT `term_type` , `term_lan ... IN (...) AND `term_type` = ? \| wikidatawiki \| \| 458506738 \| 0 \| 0 \| 5.51 d \| 257.03 ms \| 1.04 ms \| 7.92 h \| 912649608 \| 2 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 6cf1f85833d54018dd6bb9010e6aa391 \| 2018-01-16 16:29:01 \| 2018-02-28 18:30:37 \|
	\| SELECT `term_type` , `term_lan ... uage` = ? AND `term_type` = ? \| wikidatawiki \| \| 31877129 \| 0 \| 0 \| 3.99 d \| 945.35 ms \| 10.80 ms \| 37.29 m \| 311441890 \| 10 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 0 \| 5e40fb86709f8b95fe160aec3bd95e94 \| 2018-01-16 16:29:09 \| 2018-02-26 15:11:49 \|
	+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+--------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+

Event Timeline

jcrespo created this paste.May 25 2018, 11:09 AM