[Wikidata-bugs] [Maniphest] [Commented On] T191391: Apply schema changes to an isolated database and examine the results

Wed, 09 May 2018 02:52:59 -0700

Ladsgroup added a comment.

After running the optimize table we have this now:

[email protected](wikidatawiki)>SELECT * from information_schema.TABLES where TABLE_NAME = 'wb_terms'\G;
*************************** 1. row ***************************
  TABLE_CATALOG: def
   TABLE_SCHEMA: wikidatawiki
     TABLE_NAME: wb_terms
     TABLE_TYPE: BASE TABLE
         ENGINE: InnoDB
        VERSION: 10
     ROW_FORMAT: Compressed
     TABLE_ROWS: 1600682009
 AVG_ROW_LENGTH: 45
    DATA_LENGTH: 72589770752
MAX_DATA_LENGTH: 0
   INDEX_LENGTH: 52602863616
      DATA_FREE: 0
 AUTO_INCREMENT: 2130542996
    CREATE_TIME: 2018-05-09 07:18:14
    UPDATE_TIME: NULL
     CHECK_TIME: NULL
TABLE_COLLATION: binary
       CHECKSUM: NULL
 CREATE_OPTIONS: row_format=COMPRESSED key_block_size=8
  TABLE_COMMENT:
1 row in set (0.04 sec)


That sounds okay to me

TASK DETAIL
https://phabricator.wikimedia.org/T191391

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

To: Ladsgroup
Cc: Aklapper, Lucas_Werkmeister_WMDE, Jonas, jcrespo, Ladsgroup, Lahi, Gq86, GoranSMilovanovic, lisong, QZanden, Marostegui, LawExplorer, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331, Jay8g, Krenair
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to