Page MenuHomePhabricator
Create Task
Maniphest T163548

Drop the useless wb_terms keys "wb_terms_entity_type" and "wb_terms_type" on "wb_terms" table
Closed, ResolvedPublic
Actions

Description

Both of them are unused (P5306), to no surprise: There are two distinct values in wb_terms_entity_type and three distinct values in wb_terms_type, thus an index makes no sense. Both indexes don't exist within the Wikibase code as of 4cf8b2fcf35df7fcf8c113cc1020385490009297.

For reference:

  KEY `wb_terms_entity_type` (`term_entity_type`),
# …
  KEY `wb_terms_type` (`term_type`),

This concerns all wikidatawiki servers, testwikidatawiki is not affected.

Details

Show related patches Customize query in gerrit

Related Objects

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 21 2017, 12:25 PM
Marostegui mentioned this in T162539: Deploy schema change for adding term_full_entity_id column to wb_terms table.Apr 21 2017, 12:26 PM
hoo updated the task description. (Show Details)Apr 21 2017, 12:33 PM
hoo updated the task description. (Show Details)
hoo added projects: Schema-change, DBA, Wikidata.Apr 21 2017, 12:35 PM
hoo removed subscribers: Schema-change, DBA, Wikidata.
hoo added subscribers: daniel, aude.
Marostegui renamed this task from Drop the useless wb_terms keys "wb_terms_entity_type" and "wb_terms_type" to Drop the useless wb_terms keys "wb_terms_entity_type" and "wb_terms_type" on "wb_terms" table.Apr 21 2017, 12:36 PM
Marostegui claimed this task.Apr 21 2017, 1:12 PM
Marostegui moved this task from Triage to In progress on the DBA board.
gerritbot subscribed.Apr 21 2017, 1:13 PM

Change 349430 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1092

https://gerrit.wikimedia.org/r/349430

gerritbot added a project: Patch-For-Review.Apr 21 2017, 1:13 PM
gerritbot added a comment.Apr 21 2017, 1:18 PM

Change 349430 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1092

https://gerrit.wikimedia.org/r/349430

Stashbot subscribed.Apr 21 2017, 1:20 PM

Mentioned in SAL (#wikimedia-operations) [2017-04-21T13:20:29Z] <marostegui@naos> Synchronized wmf-config/db-eqiad.php: Depool db1092 - T162539 T163548 (duration: 01m 18s)

Stashbot added a comment.Apr 21 2017, 1:35 PM

Mentioned in SAL (#wikimedia-operations) [2017-04-21T13:35:33Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms on db1092 - T162539 T163548

Marostegui added a comment.Apr 24 2017, 6:03 AM

db1092 is done:

root@neodymium:~# mysql --skip-ssl -hdb1092 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:~#
gerritbot added a comment.Apr 24 2017, 6:06 AM

Change 349870 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Repool db1092, depool db1087

https://gerrit.wikimedia.org/r/349870

gerritbot added a comment.Apr 24 2017, 6:09 AM

Change 349870 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Repool db1092, depool db1087

https://gerrit.wikimedia.org/r/349870

Stashbot added a comment.Apr 24 2017, 6:12 AM

Mentioned in SAL (#wikimedia-operations) [2017-04-24T06:12:32Z] <marostegui@naos> Synchronized wmf-config/db-eqiad.php: Repool db1092, depoll db1087 - T162539 T163548 (duration: 02m 19s)

Stashbot added a comment.Apr 24 2017, 6:12 AM

Mentioned in SAL (#wikimedia-operations) [2017-04-24T06:12:44Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms on db1087 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548

Marostegui added a comment.Apr 24 2017, 1:05 PM

db1087 is done:

root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1087 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
gerritbot added a comment.Apr 24 2017, 1:08 PM

Change 349953 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1082

https://gerrit.wikimedia.org/r/349953

Stashbot added a comment.Apr 24 2017, 1:11 PM

Mentioned in SAL (#wikimedia-operations) [2017-04-24T13:11:03Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms on db1063 - T162539 https://phabricator.wikimedia.org/T163548

Stashbot added a comment.Apr 24 2017, 1:12 PM

Mentioned in SAL (#wikimedia-operations) [2017-04-24T13:12:04Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms on db1082 - T162539 - T163548

gerritbot added a comment.Apr 24 2017, 1:15 PM

Change 349953 abandoned by Marostegui:
db-eqiad.php: Depool db1082

Reason:
not needed

https://gerrit.wikimedia.org/r/349953

Marostegui added a comment.Apr 25 2017, 5:54 AM

db1082 is done:

root@neodymium:~# mysql --skip-ssl -hdb1082 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:~#
gerritbot added a comment.Apr 25 2017, 5:58 AM

Change 350119 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1071 and db1026

https://gerrit.wikimedia.org/r/350119

gerritbot added a comment.Apr 25 2017, 6:04 AM

Change 350119 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1071 and db1026

https://gerrit.wikimedia.org/r/350119

Stashbot added a comment.Apr 25 2017, 6:06 AM

Mentioned in SAL (#wikimedia-operations) [2017-04-25T06:06:12Z] <marostegui@naos> Synchronized wmf-config/db-eqiad.php: Repool db1071, depool db1026 - T162539 T163548 (duration: 01m 17s)

Marostegui added a comment.Apr 26 2017, 5:53 AM

db1071 and db1063 are done:

root@neodymium:~# mysql --skip-ssl -hdb1071 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:~# mysql --skip-ssl -hdb1063 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:~#
gerritbot added a comment.Apr 26 2017, 6:50 AM

Change 350369 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Repool db1071

https://gerrit.wikimedia.org/r/350369

gerritbot added a comment.Apr 26 2017, 6:53 AM

Change 350369 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Repool db1071

https://gerrit.wikimedia.org/r/350369

Stashbot added a comment.Apr 26 2017, 6:56 AM

Mentioned in SAL (#wikimedia-operations) [2017-04-26T06:56:08Z] <marostegui@naos> Synchronized wmf-config/db-eqiad.php: Repool db1071 - T162539 T163548 (duration: 02m 24s)

Marostegui added a comment.Apr 26 2017, 9:22 AM

db1026 is done:

root@neodymium:~# mysql --skip-ssl -hdb1026 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:~#
gerritbot added a comment.Apr 26 2017, 1:16 PM

Change 350411 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Repool db1026

https://gerrit.wikimedia.org/r/350411

Stashbot added a comment.Apr 26 2017, 1:23 PM

Mentioned in SAL (#wikimedia-operations) [2017-04-26T13:23:23Z] <marostegui> Deploy alter table db1045 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548

Stashbot added a comment.Apr 26 2017, 1:27 PM

Mentioned in SAL (#wikimedia-operations) [2017-04-26T13:27:01Z] <marostegui> Deploy alter table labsdb1001 https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548

Stashbot added a comment.Apr 26 2017, 1:29 PM

Mentioned in SAL (#wikimedia-operations) [2017-04-26T13:29:44Z] <marostegui> Deploy alter table on db1069 (wikidatawiki) https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548

gerritbot added a comment.Apr 26 2017, 1:59 PM

Change 350411 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Repool db1026, depool db1045

https://gerrit.wikimedia.org/r/350411

Stashbot added a comment.Apr 26 2017, 2:00 PM

Mentioned in SAL (#wikimedia-operations) [2017-04-26T14:00:30Z] <marostegui@naos> Synchronized wmf-config/db-eqiad.php: Repool db1026, depool db1045 - T162539 T163548 (duration: 00m 53s)

Reedy moved this task from Unsorted to Delete / Drop / Remove on the Schema-change board.Apr 26 2017, 2:22 PM
Marostegui added a comment.Apr 27 2017, 5:59 AM

labsdb1001 is done:

[root@labsdb1001 05:57 /root]
# mysql --skip-ssl wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"

[root@labsdb1001 05:59 /root]
#
Stashbot added a comment.Apr 27 2017, 5:59 AM

Mentioned in SAL (#wikimedia-operations) [2017-04-27T05:59:54Z] <marostegui> Deploy alter table labsdb1003 (wikidatawiki) https://phabricator.wikimedia.org/T162539%C2%A0https://phabricator.wikimedia.org/T163548

Marostegui added a comment.Apr 27 2017, 6:14 AM

I am altering db1070 locally, instead of from neodymium as this host is going to be affected by: T162681
I ran it with set session sql_log_bin=0

Stashbot added a comment.Apr 27 2017, 6:14 AM

Mentioned in SAL (#wikimedia-operations) [2017-04-27T06:14:33Z] <marostegui> Deploy alter table on s5 (wikidatawiki) on db1070 (running locally instead of neodymium as this host will be affected by the network maintenance) - T163548

Stashbot added a comment.Apr 27 2017, 6:14 AM

Mentioned in SAL (#wikimedia-operations) [2017-04-27T06:14:44Z] <marostegui> Deploy alter table on s5 (wikidatawiki) on db1049 - T163548

Marostegui added a comment.Apr 27 2017, 1:50 PM

db1069 is done:

root@db1069:~# mysql -S /tmp/mysql.s5.sock --skip-ssl wikidatawiki -e  "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@db1069:~#
Marostegui added a comment.Apr 27 2017, 4:00 PM

db1070 is done:

root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1070 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:/home/marostegui/git/software/dbtools#
Marostegui added a comment.Apr 28 2017, 6:26 AM

db1045 is done:

root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1045 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:/home/marostegui/git/software/dbtools#

db1049 is done:

root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1049 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:/home/marostegui/git/software/dbtools#

Pending hosts in eqiad: dbstore1001 and dbstore1002.

gerritbot added a comment.Apr 28 2017, 7:50 AM

Change 350798 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Repool db1045

https://gerrit.wikimedia.org/r/350798

gerritbot added a comment.Apr 28 2017, 7:55 AM

Change 350798 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Repool db1045

https://gerrit.wikimedia.org/r/350798

Stashbot added a comment.Apr 28 2017, 7:58 AM

Mentioned in SAL (#wikimedia-operations) [2017-04-28T07:58:44Z] <marostegui@naos> Synchronized wmf-config/db-eqiad.php: Repool db1045 - T162539 T163548 (duration: 02m 38s)

Stashbot added a comment.May 4 2017, 6:03 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-04T06:03:48Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms - dbstore2002 - T162539 T163548

gerritbot added a comment.May 4 2017, 6:05 AM

Change 351766 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Depool db2066

https://gerrit.wikimedia.org/r/351766

gerritbot added a comment.May 4 2017, 6:08 AM

Change 351766 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Depool db2066

https://gerrit.wikimedia.org/r/351766

Stashbot added a comment.May 4 2017, 6:10 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-04T06:10:09Z] <marostegui@naos> Synchronized wmf-config/db-codfw.php: Depool db2066 - T162539 T163548 (duration: 01m 25s)

Stashbot added a comment.May 4 2017, 6:10 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-04T06:10:26Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms - db2066 - T162539 T163548

Marostegui added a comment.May 4 2017, 3:03 PM

db2066 is done:

root@neodymium:~# mysql --skip-ssl -hdb2066.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
gerritbot added a comment.May 4 2017, 3:06 PM

Change 351858 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Repool db2066, depool db2059

https://gerrit.wikimedia.org/r/351858

gerritbot added a comment.May 4 2017, 3:12 PM

Change 351858 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Repool db2066, depool db2059

https://gerrit.wikimedia.org/r/351858

Stashbot added a comment.May 4 2017, 3:14 PM

Mentioned in SAL (#wikimedia-operations) [2017-05-04T15:14:28Z] <marostegui@naos> Synchronized wmf-config/db-codfw.php: Repool db2066, depool db2059 - T162539 T163548 (duration: 01m 06s)

Stashbot added a comment.May 4 2017, 3:16 PM

Mentioned in SAL (#wikimedia-operations) [2017-05-04T15:16:17Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms - db2059- https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548

Marostegui added a comment.May 5 2017, 5:43 AM

db2059 is done:

root@neodymium:~# mysql --skip-ssl -hdb2059.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:~#
`

dbstore2002 is done:

root@neodymium:~# mysql --skip-ssl -hdbstore2002.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:~#
gerritbot added a comment.May 5 2017, 5:48 AM

Change 352076 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Repool db2059, depool db2052

https://gerrit.wikimedia.org/r/352076

gerritbot added a comment.May 5 2017, 5:53 AM

Change 352076 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Repool db2059, depool db2052

https://gerrit.wikimedia.org/r/352076

Stashbot added a comment.May 5 2017, 5:55 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-05T05:55:01Z] <marostegui@tin> Synchronized wmf-config/db-codfw.php: Repool db2059, depool db2052 - T162539 T163548 (duration: 00m 40s)

Stashbot added a comment.May 5 2017, 5:55 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-05T05:55:19Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms - db2052 - T162539 T163548

Stashbot added a comment.May 5 2017, 7:11 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-05T07:11:58Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms - dbstore2001 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548

Stashbot added a comment.May 5 2017, 7:49 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-05T07:49:15Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms - dbstore1002 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548

Lydia_Pintscher moved this task from incoming to ready to go on the Wikidata board.May 5 2017, 1:44 PM
Marostegui added a comment.May 5 2017, 3:13 PM

db2052 is done:

root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb2052.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:/home/marostegui/git/software/dbtools#
gerritbot added a comment.May 5 2017, 3:21 PM

Change 352167 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Repool db2052, depool db2045

https://gerrit.wikimedia.org/r/352167

gerritbot added a comment.May 5 2017, 3:26 PM

Change 352167 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Repool db2052, depool db2045

https://gerrit.wikimedia.org/r/352167

Stashbot added a comment.May 5 2017, 3:28 PM

Mentioned in SAL (#wikimedia-operations) [2017-05-05T15:28:12Z] <marostegui@tin> Synchronized wmf-config/db-codfw.php: Repool db2052, depool db2045 - T162539 T163548 (duration: 00m 41s)

Stashbot added a comment.May 5 2017, 3:28 PM

Mentioned in SAL (#wikimedia-operations) [2017-05-05T15:28:21Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms - db2045 - https://phabricator.wikimedia.org/T162539 https://phabricator.wikimedia.org/T163548

Marostegui added a comment.May 8 2017, 6:07 AM

db2045 is done:

root@neodymium:~# mysql --skip-ssl -hdb2045.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"

dbstore2001 is done:

root@neodymium:~# mysql --skip-ssl -hdbstore2001.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"

dbstore1002 is done:

root@neodymium:~# mysql --skip-ssl -hdbstore1002 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
gerritbot added a comment.May 8 2017, 6:11 AM

Change 352543 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Repool db2045, depool db2038

https://gerrit.wikimedia.org/r/352543

gerritbot added a comment.May 8 2017, 6:14 AM

Change 352543 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Repool db2045, depool db2038

https://gerrit.wikimedia.org/r/352543

Stashbot added a comment.May 8 2017, 6:18 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-08T06:18:18Z] <marostegui@tin> Synchronized wmf-config/db-codfw.php: Repool db2045, depool db2038 - T162539 T163548 (duration: 00m 40s)

Marostegui added a comment.May 8 2017, 3:55 PM

db2038 is done:

root@neodymium:/home/marostegui/git/software/dbtools#  mysql --skip-ssl -hdb2038.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
root@neodymium:/home/marostegui/git/software/dbtools#

The only pending host is codfw master which will be done tomorrow morning.

gerritbot added a comment.May 8 2017, 3:57 PM

Change 352607 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Repool db2038

https://gerrit.wikimedia.org/r/352607

Stashbot added a comment.May 9 2017, 5:54 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-09T05:54:39Z] <marostegui> Deploy alter table on wikidatawiki.wb_terms on codfw master db2023 - https://phabricator.wikimedia.org/T162539 - https://phabricator.wikimedia.org/T163548

gerritbot added a comment.May 9 2017, 6:00 AM

Change 352607 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Repool db2038

https://gerrit.wikimedia.org/r/352607

Stashbot added a comment.May 9 2017, 6:01 AM

Mentioned in SAL (#wikimedia-operations) [2017-05-09T06:01:53Z] <marostegui@tin> Synchronized wmf-config/db-codfw.php: Repool db2038 - T162539 T163548 (duration: 00m 41s)

Marostegui added a comment.May 10 2017, 6:10 AM

codfw master, db2023 is done:

root@neodymium:~# mysql --skip-ssl -hdb2023.codfw.wmnet wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
Marostegui added a comment.May 11 2017, 12:03 PM

dbstore1001 is done:

root@neodymium:/home/marostegui# mysql --skip-ssl -hdbstore1001 wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
Marostegui closed this task as Resolved.May 11 2017, 12:12 PM

All hosts are done:

dbstore2002.codfw.wmnet
dbstore2001.codfw.wmnet
db2038.codfw.wmnet
db2045.codfw.wmnet
db2052.codfw.wmnet
db2059.codfw.wmnet
db2066.codfw.wmnet
db2023.codfw.wmnet
db1069.eqiad.wmnet
dbstore1001.eqiad.wmnet
dbstore1002.eqiad.wmnet
db1026.eqiad.wmnet
db1045.eqiad.wmnet
db1049.eqiad.wmnet
db1070.eqiad.wmnet
db1071.eqiad.wmnet
db1082.eqiad.wmnet
db1087.eqiad.wmnet
db1092.eqiad.wmnet
db1063.eqiad.wmnet
[12:10:45] marostegui@labsdb1003:~$ sudo -i mysql --skip-ssl wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
[12:10:55] marostegui@labsdb1003:~$

[12:11:31] marostegui@labsdb1001:~$  sudo -i mysql --skip-ssl wikidatawiki -e "show create table wb_terms\G" | egrep "wb_terms_entity_type|wb_terms_type"
[12:11:36] marostegui@labsdb1001:~$
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits