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

[hoo]

hoo added a comment.

Table sizes pre-deploy to cawiki and cewiki:

mysql:wikiadmin@db1079 [cawiki]> SHOW TABLE STATUS like "wbc_entity_usage"\G
*************************** 1. row ***************************
           Name: wbc_entity_usage
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 11676926
 Avg_row_length: 124
    Data_length: 1450704896
Max_data_length: 0
   Index_length: 1864957952
      Data_free: 258998272
 Auto_increment: 27091066
…

mysql:wikiadmin@db1094 [cawiki]> SHOW TABLE STATUS like "wbc_entity_usage"\G
*************************** 1. row ***************************
           Name: wbc_entity_usage
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 11275586
 Avg_row_length: 129
    Data_length: 1454882816
Max_data_length: 0
   Index_length: 1839742976
      Data_free: 279969792
 Auto_increment: 27091066
…

mysql:wikiadmin@db1078 [cewiki]> SHOW TABLE STATUS like "wbc_entity_usage"\G
*************************** 1. row ***************************
           Name: wbc_entity_usage
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 5958796
 Avg_row_length: 78
    Data_length: 465485824
Max_data_length: 0
   Index_length: 564248576
      Data_free: 9437184
 Auto_increment: 10184030
…

mysql:wikiadmin@db1077 [cewiki]> SHOW TABLE STATUS like "wbc_entity_usage"\G
*************************** 1. row ***************************
           Name: wbc_entity_usage
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 5825230
 Avg_row_length: 81
    Data_length: 474906624
Max_data_length: 0
   Index_length: 568295424
      Data_free: 11534336
 Auto_increment: 10184030
…

Usages pre-deploy:
cawiki:

No      eu_aspect
5767425 L.ca
412499  L.en
442257  L.oc
585871  O
649594  S
3046987 T
1174675 X

cewiki:

No      eu_aspect
130585  L.ce
3905    L.en
126406  L.ru
160246  O
172761  S
1798197 T
3645127 X

cawiki had to be reverted after a few minutes as the number of usages added skyrocketed, I saw over 22,000 usages being added in a minute. (Usages: 23832; SLEEP(60); Usages: 46490). A total of 90430 statement usages were added in just 6 minutes on cawiki (~15k per minute or 250/s).

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, Luke081515, Mbch331, Jay8g, Krenair

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