Compare text

Find the difference between two text files

Real-time editor
Hide unchanged lines
Disable line wrap
Layout
Diff precision
Syntax highlighting

Untitled diff

Created Diff never expires
92 removals
188 lines
93 additions
185 lines
MariaDB [wikidatawiki]> describe wb_changes;
MariaDB [default]> describe wb_changes;
+--------------------+------------------+------+-----+---------+----------------+
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+----------------+
+--------------------+------------------+------+-----+---------+----------------+
| change_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| change_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| change_type | varbinary(25) | NO | MUL | NULL | |
| change_type | varbinary(25) | NO | MUL | NULL | |
| change_time | varbinary(14) | NO | MUL | NULL | |
| change_time | varbinary(14) | NO | MUL | NULL | |
| change_object_id | varbinary(14) | NO | MUL | NULL | |
| change_object_id | varbinary(14) | NO | MUL | NULL | |
| change_revision_id | int(10) unsigned | NO | MUL | NULL | |
| change_revision_id | int(10) unsigned | NO | MUL | NULL | |
| change_user_id | int(10) unsigned | NO | MUL | NULL | |
| change_user_id | int(10) unsigned | NO | MUL | NULL | |
| change_info | mediumblob | NO | | NULL | |
| change_info | mediumblob | NO | | NULL | |
+--------------------+------------------+------+-----+---------+----------------+
+--------------------+------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
7 rows in set (0.001 sec)


MariaDB [wikidatawiki]> show index from wb_changes;
MariaDB [default]> show index from wb_changes;
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_changes | 0 | PRIMARY | 1 | change_id | A | 1621042 | NULL | NULL | | BTREE | | |
| wb_changes | 0 | PRIMARY | 1 | change_id | A | 17 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_type | 1 | change_type | A | 13 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_type | 1 | change_type | A | 8 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_time | 1 | change_time | A | 540347 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_time | 1 | change_time | A | 17 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_object_id | 1 | change_object_id | A | 1621042 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_object_id | 1 | change_object_id | A | 17 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_user_id | 1 | change_user_id | A | 6839 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_user_id | 1 | change_user_id | A | 2 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_revision_id | 1 | change_revision_id | A | 1621042 | NULL | NULL | | BTREE | | |
| wb_changes | 1 | wb_changes_change_revision_id | 1 | change_revision_id | A | 17 | NULL | NULL | | BTREE | | |
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+------------+------------+-------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
6 rows in set (0.00 sec)
6 rows in set (0.001 sec)


MariaDB [wikidatawiki]> describe wb_changes_dispatch;
MariaDB [default]> describe wb_changes_dispatch;
+--------------+---------------------+------+-----+----------------+-------+
+--------------+---------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+----------------+-------+
+--------------+---------------------+------+-----+----------------+-------+
| chd_site | varbinary(32) | NO | PRI | NULL | |
| chd_site | varbinary(32) | NO | PRI | NULL | |
| chd_db | varbinary(32) | NO | | NULL | |
| chd_db | varbinary(32) | NO | | NULL | |
| chd_seen | int(11) | NO | MUL | 0 | |
| chd_seen | int(11) | NO | MUL | 0 | |
| chd_touched | varbinary(14) | NO | MUL | 00000000000000 | |
| chd_touched | varbinary(14) | NO | MUL | 00000000000000 | |
| chd_lock | varbinary(64) | YES | | NULL | |
| chd_lock | varbinary(64) | YES | | NULL | |
| chd_disabled | tinyint(3) unsigned | NO | | 0 | |
| chd_disabled | tinyint(3) unsigned | NO | | 0 | |
+--------------+---------------------+------+-----+----------------+-------+
+--------------+---------------------+------+-----+----------------+-------+
6 rows in set (0.00 sec)
6 rows in set (0.001 sec)


MariaDB [wikidatawiki]> show index from wb_changes_dispatch;
MariaDB [default]> show index from wb_changes_dispatch;
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_changes_dispatch | 0 | PRIMARY | 1 | chd_site | A | 577 | NULL | NULL | | BTREE | | |
| wb_changes_dispatch | 0 | PRIMARY | 1 | chd_site | A | 0 | NULL | NULL | | BTREE | | |
| wb_changes_dispatch | 1 | wb_changes_dispatch_chd_seen | 1 | chd_seen | A | 2 | NULL | NULL | | BTREE | | |
| wb_changes_dispatch | 1 | wb_changes_dispatch_chd_seen | 1 | chd_seen | A | 0 | NULL | NULL | | BTREE | | |
| wb_changes_dispatch | 1 | wb_changes_dispatch_chd_touched | 1 | chd_touched | A | 2 | NULL | NULL | | BTREE | | |
| wb_changes_dispatch | 1 | wb_changes_dispatch_chd_touched | 1 | chd_touched | A | 0 | NULL | NULL | | BTREE | | |
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+---------------------+------------+---------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.00 sec)
3 rows in set (0.000 sec)


MariaDB [wikidatawiki]> describe wb_changes_subscription;
MariaDB [default]> describe wb_changes_subscription;
+------------------+----------------+------+-----+---------+----------------+
+------------------+----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
| Field | Type | Null | Key | Default | Extra |
+------------------+----------------+------+-----+---------+----------------+
+------------------+----------------+------+-----+---------+----------------+
| cs_row_id | bigint(20) | NO | PRI | NULL | auto_increment |
| cs_row_id | bigint(20) | NO | PRI | NULL | auto_increment |
| cs_entity_id | varbinary(255) | NO | MUL | NULL | |
| cs_entity_id | varbinary(255) | NO | MUL | NULL | |
| cs_subscriber_id | varbinary(255) | NO | MUL | NULL | |
| cs_subscriber_id | varbinary(255) | NO | MUL | NULL | |
+------------------+----------------+------+-----+---------+----------------+
+------------------+----------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
3 rows in set (0.001 sec)


MariaDB [wikidatawiki]> show index from wb_changes_subscription;
MariaDB [default]> show index from wb_changes_subscription;
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_changes_subscription | 0 | PRIMARY | 1 | cs_row_id | A | 62616116 | NULL | NULL | | BTREE | | |
| wb_changes_subscription | 0 | PRIMARY | 1 | cs_row_id | A | 0 | NULL | NULL | | BTREE | | |
| wb_changes_subscription | 0 | cs_entity_id | 1 | cs_entity_id | A | 62616116 | NULL | NULL | | BTREE | | |
| wb_changes_subscription | 0 | cs_entity_id | 1 | cs_entity_id | A | 0 | NULL | NULL | | BTREE | | |
| wb_changes_subscription | 0 | cs_entity_id | 2 | cs_subscriber_id | A | 62616116 | NULL | NULL | | BTREE | | |
| wb_changes_subscription | 0 | cs_entity_id | 2 | cs_subscriber_id | A | 0 | NULL | NULL | | BTREE | | |
| wb_changes_subscription | 1 | cs_subscriber_id | 1 | cs_subscriber_id | A | 70993 | NULL | NULL | | BTREE | | |
| wb_changes_subscription | 1 | cs_subscriber_id | 1 | cs_subscriber_id | A | 0 | NULL | NULL | | BTREE | | |
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+-------------------------+------------+------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
4 rows in set (0.00 sec)
4 rows in set (0.000 sec)


MariaDB [wikidatawiki]> describe wb_id_counters;
MariaDB [default]> describe wb_id_counters;
+----------+------------------+------+-----+---------+-------+
+----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
+----------+------------------+------+-----+---------+-------+
| id_value | int(10) unsigned | NO | | NULL | |
| id_value | int(10) unsigned | NO | | NULL | |
| id_type | varbinary(32) | NO | PRI | NULL | |
| id_type | varbinary(32) | NO | PRI | NULL | |
+----------+------------------+------+-----+---------+-------+
+----------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
2 rows in set (0.001 sec)


MariaDB [wikidatawiki]> show index from wb_id_counters;
MariaDB [default]> show index from wb_id_counters;
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_id_counters | 0 | wb_id_counters_type | 1 | id_type | A | 3 | NULL | NULL | | BTREE | | |
| wb_id_counters | 0 | wb_id_counters_type | 1 | id_type | A | 3 | NULL | NULL | | BTREE | | |
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+----------------+------------+---------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
1 row in set (0.00 sec)
1 row in set (0.000 sec)


MariaDB [wikidatawiki]> describe wb_items_per_site;
MariaDB [default]> describe wb_items_per_site;
+---------------+---------------------+------+-----+---------+----------------+
+---------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+----------------+
+---------------+---------------------+------+-----+---------+----------------+
| ips_row_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| ips_row_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| ips_item_id | int(10) unsigned | NO | MUL | NULL | |
| ips_item_id | int(10) unsigned | NO | MUL | NULL | |
| ips_site_id | varbinary(32) | NO | MUL | NULL | |
| ips_site_id | varbinary(32) | NO | MUL | NULL | |
| ips_site_page | varbinary(310) | NO | | NULL | |
| ips_site_page | varbinary(310) | NO | | NULL | |
+---------------+---------------------+------+-----+---------+----------------+
+---------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
4 rows in set (0.001 sec)


MariaDB [wikidatawiki]> show index from wb_items_per_site;
MariaDB [default]> show index from wb_items_per_site;
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_items_per_site | 0 | PRIMARY | 1 | ips_row_id | A | 60912657 | NULL | NULL | | BTREE | | |
| wb_items_per_site | 0 | PRIMARY | 1 | ips_row_id | A | 0 | NULL | NULL | | BTREE | | |
| wb_items_per_site | 0 | wb_ips_item_site_page | 1 | ips_site_id | A | 87267 | NULL | NULL | | BTREE | | |
| wb_items_per_site | 0 | wb_ips_item_site_page | 1 | ips_site_id | A | 0 | NULL | NULL | | BTREE | | |
| wb_items_per_site | 0 | wb_ips_item_site_page | 2 | ips_site_page | A | 60912657 | NULL | NULL | | BTREE | | |
| wb_items_per_site | 0 | wb_ips_item_site_page | 2 | ips_site_page | A | 0 | NULL | NULL | | BTREE | | |
| wb_items_per_site | 1 | wb_ips_item_id | 1 | ips_item_id | A | 60912657 | NULL | NULL | | BTREE | | |
| wb_items_per_site | 1 | wb_ips_item_id | 1 | ips_item_id | A | 0 | NULL | NULL | | BTREE | | |
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+-------------------+------------+-----------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
4 rows in set (0.00 sec)
4 rows in set (0.000 sec)


MariaDB [wikidatawiki]> describe wb_property_info;
MariaDB [default]> describe wb_property_info;
+----------------+------------------+------+-----+---------+-------+
+----------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
+----------------+------------------+------+-----+---------+-------+
| pi_property_id | int(10) unsigned | NO | PRI | NULL | |
| pi_property_id | int(10) unsigned | NO | PRI | NULL | |
| pi_type | varbinary(32) | NO | MUL | NULL | |
| pi_type | varbinary(32) | NO | MUL | NULL | |
| pi_info | blob | NO | | NULL | |
| pi_info | blob | NO | | NULL | |
+----------------+------------------+------+-----+---------+-------+
+----------------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
3 rows in set (0.001 sec)


MariaDB [wikidatawiki]> show index from wb_property_info;
MariaDB [default]> show index from wb_property_info;
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_property_info | 0 | PRIMARY | 1 | pi_property_id | A | 5144 | NULL | NULL | | BTREE | | |
| wb_property_info | 0 | PRIMARY | 1 | pi_property_id | A | 1 | NULL | NULL | | BTREE | | |
| wb_property_info | 1 | pi_type | 1 | pi_type | A | 30 | NULL | NULL | | BTREE | | |
| wb_property_info | 1 | pi_type | 1 | pi_type | A | 1 | NULL | NULL | | BTREE | | |
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+------------------+------------+----------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
2 rows in set (0.00 sec)
2 rows in set (0.000 sec)


MariaDB [wikidatawiki]> describe wb_terms;
MariaDB [default]> describe wb_terms;
+---------------------+---------------------+------+-----+---------+----------------+
+---------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------------+------+-----+---------+----------------+
+---------------------+---------------------+------+-----+---------+----------------+
| term_row_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| term_row_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| term_entity_id | int(10) unsigned | NO | MUL | NULL | |
| term_entity_id | int(10) unsigned | NO | | NULL | |
| term_full_entity_id | varbinary(32) | YES | MUL | NULL | |
| term_full_entity_id | varbinary(32) | YES | MUL | NULL | |
| term_entity_type | varbinary(32) | NO | | NULL | |
| term_entity_type | varbinary(32) | NO | | NULL | |
| term_language | varbinary(32) | NO | MUL | NULL | |
| term_language | varbinary(32) | NO | MUL | NULL | |
| term_type | varbinary(32) | NO | | NULL | |
| term_type | varbinary(32) | NO | | NULL | |
| term_text | varbinary(255) | NO | MUL | NULL | |
| term_text | varbinary(255) | NO | MUL | NULL | |
| term_search_key | varbinary(255) | NO | MUL | NULL | |
| term_search_key | varbinary(255) | NO | MUL | NULL | |
| term_weight | float unsigned | NO | | 0 | |
| term_weight | float unsigned | NO | | 0 | |
+---------------------+---------------------+------+-----+---------+----------------+
+---------------------+---------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)
9 rows in set (0.001 sec)


MariaDB [wikidatawiki]> show index from wb_terms;
MariaDB [default]> show index from wb_terms;
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_terms | 0 | PRIMARY | 1 | term_row_id | A | 1717619563 | NULL | NULL | | BTREE | | |
| wb_terms | 0 | PRIMARY | 1 | term_row_id | A | 4 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | wb_terms_entity_id | 1 | term_entity_id | A | 156147233 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_full_entity | 1 | term_full_entity_id | A | 4 | NULL | NULL | YES | BTREE | | |
| wb_terms | 1 | wb_terms_text | 1 | term_text | A | 429404890 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_text | 1 | term_text | A | 4 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | wb_terms_search_key | 1 | term_search_key | A | 156147233 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_text | 2 | term_language | A | 4 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_full_entity | 1 | term_full_entity_id | A | 85880978 | NULL | NULL | YES | BTREE | | |
| wb_terms | 1 | term_search_key | 1 | term_search_key | A | 4 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_search_full | 1 | term_language | A | 6580917 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_search_key | 2 | term_language | A | 4 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_search_full | 2 | term_full_entity_id | A | 1717619563 | NULL | NULL | YES | BTREE | | |
| wb_terms | 1 | term_search_full | 1 | term_language | A | 4 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_search_full | 3 | term_type | A | 1717619563 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_search_full | 2 | term_full_entity_id | A | 4 | NULL | NULL | YES | BTREE | | |
| wb_terms | 1 | term_search_full | 4 | term_search_key | A | 1717619563 | 16 | NULL | | BTREE | | |
| wb_terms | 1 | term_search_full | 3 | term_type | A | 4 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | tmp1 | 1 | term_language | A | 6982193 | NULL | NULL | | BTREE | | |
| wb_terms | 1 | term_search_full | 4 | term_search_key | A | 4 | 16 | NULL | | BTREE | | |
| wb_terms | 1 | tmp1 | 2 | term_type | A | 6709451 | NULL | NULL | | BTREE | | |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_terms | 1 | tmp1 | 3 | term_entity_type | A | 8718881 | NULL | NULL | | BTREE | | |
10 rows in set (0.001 sec)
| wb_terms | 1 | tmp1 | 4 | term_search_key | A | 429404890 | NULL | NULL | | BTREE | | |
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
13 rows in set (0.00 sec)


MariaDB [wikidatawiki]> describe wbc_entity_usage;
MariaDB [default]> describe wbc_entity_usage;
+--------------+----------------+------+-----+---------+----------------+
+--------------+----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------+------+-----+---------+----------------+
+--------------+----------------+------+-----+---------+----------------+
| eu_row_id | bigint(20) | NO | PRI | NULL | auto_increment |
| eu_row_id | bigint(20) | NO | PRI | NULL | auto_increment |
| eu_entity_id | varbinary(255) | NO | MUL | NULL | |
| eu_entity_id | varbinary(255) | NO | MUL | NULL | |
| eu_aspect | varbinary(37) | NO | | NULL | |
| eu_aspect | varbinary(37) | NO | | NULL | |
| eu_page_id | int(11) | NO | MUL | NULL | |
| eu_page_id | int(11) | NO | MUL | NULL | |
+--------------+----------------+------+-----+---------+----------------+
+--------------+----------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
4 rows in set (0.001 sec)


MariaDB [wikidatawiki]> show index from wbc_entity_usage;
MariaDB [default]> show index from wbc_entity_usage;
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wbc_entity_usage | 0 | PRIMARY | 1 | eu_row_id | A | 6485691 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 0 | PRIMARY | 1 | eu_row_id | A | 0 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 0 | eu_entity_id | 1 | eu_entity_id | A | 3242845 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 0 | eu_entity_id | 1 | eu_entity_id | A | 0 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 0 | eu_entity_id | 2 | eu_aspect | A | 6485691 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 0 | eu_entity_id | 2 | eu_aspect | A | 0 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 0 | eu_entity_id | 3 | eu_page_id | A | 6485691 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 0 | eu_entity_id | 3 | eu_page_id | A | 0 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 1 | eu_page_id | 1 | eu_page_id | A | 180158 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 1 | eu_page_id | 1 | eu_page_id | A | 0 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 1 | eu_page_id | 2 | eu_entity_id | A | 6485691 | NULL | NULL | | BTREE | | |
| wbc_entity_usage | 1 | eu_page_id | 2 | eu_entity_id | A | 0 | NULL | NULL | | BTREE | | |
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
6 rows in set (0.00 sec)
6 rows in set (0.000 sec)
Saved diffs