Page MenuHomePhabricator
Paste P2368

(An Untitled Masterwork)
ActivePublic

Authored by jcrespo on Dec 3 2015, 8:54 AM.
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;
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;
+--------------------------------------------+------------------+--------+---------------------------------------------------+
| table_name | TOTAL SIZE (GB) | ENGINE | CREATE_OPTIONS |
+--------------------------------------------+------------------+--------+---------------------------------------------------+
| MobileWebUIClickTracking_10742159 | 381.725290197879 | TokuDB | `compression`='tokudb_zlib' |
| MobileWebClickTracking_5929948 | 361.198562531732 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| Edit_11448630 | 141.018585060723 | TokuDB | `compression`='tokudb_zlib' |
| PageContentSaveComplete_5588433 | 137.354089650325 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| MediaViewer_10867062 | 133.406105597503 | TokuDB | `compression`='tokudb_zlib' |
| Edit_13457736 | 121.433242797852 | InnoDB | |
| MobileWikiAppToCInteraction_10375484 | 81.189829871990 | TokuDB | `compression`='tokudb_zlib' |
| MobileWebEditing_8599025 | 61.526363065466 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| DeprecatedUsage_7906187 | 53.731984032318 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| MobileWikiAppArticleSuggestions_12443791 | 49.361083984375 | InnoDB | |
| MobileWebSectionUsage_14321266 | 49.022262573242 | InnoDB | |
| MobileWikiAppMediaGallery_10923135 | 29.499001029879 | TokuDB | `compression`='tokudb_zlib' |
| MobileWikiAppSearch_10641988 | 28.150512695313 | InnoDB | |
| NavigationTiming_10785754 | 21.677765787579 | TokuDB | `compression`='tokudb_zlib' |
| MobileWikiAppToCInteraction_8461467 | 19.969530507922 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| MobileWikiAppArticleSuggestions_11448426 | 16.618270874023 | InnoDB | |
| ImageMetricsCorsSupport_11686678 | 16.049972534180 | InnoDB | |
| ContentTranslationCTA_11616099 | 15.547241210938 | InnoDB | |
| NavigationTiming_12405818 | 15.501541137695 | InnoDB | |
| MultimediaViewerNetworkPerformance_7917896 | 14.237171442248 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| MobileWikiAppArticleSuggestions_10590869 | 14.102098437957 | TokuDB | `compression`='tokudb_zlib' |
| EchoInteraction_5782287 | 13.824828155339 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| MediaViewer_8572637 | 12.886538302526 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| MediaViewer_8245578 | 12.405743772164 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| UniversalLanguageSelector_7327441 | 12.037833562121 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| PersonalBar_7829128 | 11.579391132109 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| CentralAuth_5690875 | 10.704098877497 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| PageCreation_7481635 | 10.452265075408 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
| MediaViewer_10606177 | 8.973897109739 | TokuDB | `compression`='tokudb_zlib' |
| Echo_7731316 | 8.949344517663 | TokuDB | row_format=COMPRESSED `compression`='tokudb_zlib' |
+--------------------------------------------+------------------+--------+---------------------------------------------------+

Event Timeline

jcrespo edited the content of this paste. (Show Details)Dec 3 2015, 8:54 AM
jcrespo updated the paste's language from autodetect to autodetect.