Page MenuHomePhabricator
Paste P5306

(An Untitled Masterwork)
ActivePublic

Authored by jcrespo on Apr 21 2017, 12:13 PM.
Tags
None
Referenced Files
F7686096:
Apr 21 2017, 12:13 PM
Subscribers
None
root@neodymium:~$ mysql -h db2023.codfw.wmnet -e "SELECT * FROM sys.schema_index_statistics WHERE table_schema='wikidatawiki' and table_name='wb_terms' and index_name IN ('wb_terms_entity_type', 'wb_terms_type')"
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| wikidatawiki | wb_terms | wb_terms_entity_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
| wikidatawiki | wb_terms | wb_terms_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
root@neodymium:~$ mysql -h db2038.codfw.wmnet -e "SELECT * FROM sys.schema_index_statistics WHERE table_schema='wikidatawiki' and table_name='wb_terms' and index_name IN ('wb_terms_entity_type', 'wb_terms_type')"
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| wikidatawiki | wb_terms | wb_terms_entity_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
| wikidatawiki | wb_terms | wb_terms_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
root@neodymium:~$ mysql -h db2045.codfw.wmnet -e "SELECT * FROM sys.schema_index_statistics WHERE table_schema='wikidatawiki' and table_name='wb_terms' and index_name IN ('wb_terms_entity_type', 'wb_terms_type')"
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| wikidatawiki | wb_terms | wb_terms_entity_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
| wikidatawiki | wb_terms | wb_terms_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
root@neodymium:~$ mysql -h db2052.codfw.wmnet -e "SELECT * FROM sys.schema_index_statistics WHERE table_schema='wikidatawiki' and table_name='wb_terms' and index_name IN ('wb_terms_entity_type', 'wb_terms_type')"
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| wikidatawiki | wb_terms | wb_terms_entity_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
| wikidatawiki | wb_terms | wb_terms_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
root@neodymium:~$ mysql -h db2059.codfw.wmnet -e "SELECT * FROM sys.schema_index_statistics WHERE table_schema='wikidatawiki' and table_name='wb_terms' and index_name IN ('wb_terms_entity_type', 'wb_terms_type')"
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| wikidatawiki | wb_terms | wb_terms_entity_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
| wikidatawiki | wb_terms | wb_terms_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
root@neodymium:~$ mysql -h db2066.codfw.wmnet -e "SELECT * FROM sys.schema_index_statistics WHERE table_schema='wikidatawiki' and table_name='wb_terms' and index_name IN ('wb_terms_entity_type', 'wb_terms_type')"
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| wikidatawiki | wb_terms | wb_terms_entity_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
| wikidatawiki | wb_terms | wb_terms_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
+--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+

Event Timeline

root@db2023.codfw.wmnet[sys]> SELECT * FROM schema_unused_indexes WHERE object_schema='wikidatawiki' and object_name='wb_terms';
+---------------+-------------+----------------------+
| object_schema | object_name | index_name           |
+---------------+-------------+----------------------+
| wikidatawiki  | wb_terms    | wb_terms_entity_type |
| wikidatawiki  | wb_terms    | wb_terms_type        |
| wikidatawiki  | wb_terms    | wb_terms_search_key  |
+---------------+-------------+----------------------+
3 rows in set (0.04 sec)