As a followup of T119380, things that are pending:
- Set a maintenance window for converting tables on db1046 to TokuDB. The maintenance requires going read-only for some days or coordinate on a failover.
1 | SELECT table_name, (DATA_LENGTH + INDEX_LENGTH)/1024/1024/1024 as `TOTAL SIZE (GB)`, ENGINE, CREATE_OPTIONS FROM information_schema.tables WHERE TABLE_SCHEMA='log' /* AND `ENGINE` <> 'TokuDB' */ ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC LIMIT 30; |
---|---|
2 | |
3 | mysql> SELECT table_name, (DATA_LENGTH + INDEX_LENGTH)/1024/1024/1024 as `TOTAL SIZE (GB)`, ENGINE, CREATE_OPTIONS FROM information_schema.tables WHERE TABLE_SCHEMA='log' /* AND `ENGINE` <> 'TokuDB' */ ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC LIMIT 30; |
4 | +--------------------------------------------+------------------+--------+---------------------------------------------------+ |
5 | | table_name | TOTAL SIZE (GB) | ENGINE | CREATE_OPTIONS | |
6 | +--------------------------------------------+------------------+--------+---------------------------------------------------+ |
7 | | MobileWebUIClickTracking_10742159 | 381.725290197879 | TokuDB | `compression`='tokudb_zlib' | |
8 | | MobileWebClickTracking_5929948 | 361.198562531732 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
9 | | Edit_11448630 | 141.018585060723 | TokuDB | `compression`='tokudb_zlib' | |
10 | | PageContentSaveComplete_5588433 | 137.354089650325 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
11 | | MediaViewer_10867062 | 133.406105597503 | TokuDB | `compression`='tokudb_zlib' | |
12 | | Edit_13457736 | 121.433242797852 | InnoDB | | |
13 | | MobileWikiAppToCInteraction_10375484 | 81.189829871990 | TokuDB | `compression`='tokudb_zlib' | |
14 | | MobileWebEditing_8599025 | 61.526363065466 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
15 | | DeprecatedUsage_7906187 | 53.731984032318 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
16 | | MobileWikiAppArticleSuggestions_12443791 | 49.361083984375 | InnoDB | | |
17 | | MobileWebSectionUsage_14321266 | 49.022262573242 | InnoDB | | |
18 | | MobileWikiAppMediaGallery_10923135 | 29.499001029879 | TokuDB | `compression`='tokudb_zlib' | |
19 | | MobileWikiAppSearch_10641988 | 28.150512695313 | InnoDB | | |
20 | | NavigationTiming_10785754 | 21.677765787579 | TokuDB | `compression`='tokudb_zlib' | |
21 | | MobileWikiAppToCInteraction_8461467 | 19.969530507922 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
22 | | MobileWikiAppArticleSuggestions_11448426 | 16.618270874023 | InnoDB | | |
23 | | ImageMetricsCorsSupport_11686678 | 16.049972534180 | InnoDB | | |
24 | | ContentTranslationCTA_11616099 | 15.547241210938 | InnoDB | | |
25 | | NavigationTiming_12405818 | 15.501541137695 | InnoDB | | |
26 | | MultimediaViewerNetworkPerformance_7917896 | 14.237171442248 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
27 | | MobileWikiAppArticleSuggestions_10590869 | 14.102098437957 | TokuDB | `compression`='tokudb_zlib' | |
28 | | EchoInteraction_5782287 | 13.824828155339 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
29 | | MediaViewer_8572637 | 12.886538302526 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
30 | | MediaViewer_8245578 | 12.405743772164 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
31 | | UniversalLanguageSelector_7327441 | 12.037833562121 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
32 | | PersonalBar_7829128 | 11.579391132109 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
33 | | CentralAuth_5690875 | 10.704098877497 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
34 | | PageCreation_7481635 | 10.452265075408 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
35 | | MediaViewer_10606177 | 8.973897109739 | TokuDB | `compression`='tokudb_zlib' | |
36 | | Echo_7731316 | 8.949344517663 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' | |
37 | +--------------------------------------------+------------------+--------+---------------------------------------------------+ |
- Change the application so it create the tables in TokuDB compressed format by default:
ENGINE=TokuDB row_format=COMPRESSED `compression`='tokudb_zlib'
- Perform an automatic rotation of tables when they become too big for easier maintenance (right now it is impossible to perform online maintenance because some tables grow faster than the changes are applied)