[Wikidata-bugs] [Maniphest] [Commented On] T151717: Usage tracking: record which statement group is used

[hoo]

hoo added a comment.

Now that all articles have been refreshed (see T151717#3621993/T151717#3621975 for a comparison):

+----------+
| COUNT(*) |
+----------+
|  2646007 |
+----------+
1 row in set (16.76 sec)

+--------+-----------+
| No     | eu_aspect |
+--------+-----------+
| 269763 | X         |
| 192387 | S         |
| 150830 | T         |
|  99712 | L.el      |
|  80258 | O         |
|  57459 | C.P373    |
|  49197 | C.P21     |
|  36119 | C.P856    |
|  31948 | C.P570    |
|  31616 | C.P18     |
|  30382 | C.P569    |
|  27893 | C.P27     |
|  27515 | C.P69     |
|  27495 | C.P40     |
|  27407 | C.P26     |
|  27379 | C.P451    |
|  27161 | C.P22     |
|  27073 | C.P25     |
|  26649 | C.P106    |
|  25711 | C.P509    |
+--------+-----------+
20 rows in set (27.83 sec)

Table stats (see T151717#3622100 for comparison):

mysql:wikiadmin@db1038 [elwiki]> SHOW TABLE STATUS like "wbc_entity_usage"\G
*************************** 1. row ***************************
           Name: wbc_entity_usage
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 1950418
 Avg_row_length: 74
    Data_length: 145162240
Max_data_length: 0
   Index_length: 218972160
      Data_free: 6291456
 Auto_increment: 3553049
…
1 row in set (0.00 sec)

mysql:wikiadmin@db1035 [elwiki]> SHOW TABLE STATUS like "wbc_entity_usage"\G
*************************** 1. row ***************************
           Name: wbc_entity_usage
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 2670782
 Avg_row_length: 73
    Data_length: 195395584
Max_data_length: 0
   Index_length: 287178752
      Data_free: 4194304
 Auto_increment: 3553050
…
1 row in set (0.00 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T151717

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: hoo
Cc: Bawolff, eranroz, Ottomata, PokestarFan, Ladsgroup, Stashbot, gerritbot, Halfak, jcrespo, TomT0m, Hall1467, hoo, zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226, MZMcBride, Ricordisamoa, Micru, jayvdb, Daniel_Mietchen, Tobi_WMDE_SW, Legoktm, Abraham, Wikidata-bugs, liangent, jeremyb, aude, Bianjiang, Aklapper, DixonD, daniel, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Marostegui, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Mbch331, Jay8g, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs