(An Untitled Masterwork)
ActivePublic
Actions

Authored by jcrespo on Dec 3 2015, 8:54 AM.

Tags

None

Referenced Files

	F3043878:
	Dec 3 2015, 8:54 AM

Subscribers

None

	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.

jcrespo mentioned this in T120187: Pending maintenance on the eventlogging databases (db1046, db1047, dbstore1002, other dbstores).Dec 3 2015, 9:02 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' \|
	+--------------------------------------------+------------------+--------+---------------------------------------------------+

(An Untitled Masterwork)ActivePublicActions

Event Timeline

(An Untitled Masterwork)
ActivePublic
Actions