Documentation
API
Q&A
Read
AnnouncementsArticlesWebsite tips
Learn
Getting StartedManagerMaestroAnalyticsExchangeWorkspaces
Resources
VideosDownloadsExchange PackagesRelease Notes
Ideas
Contact
Platform
Manager
Maestro
Exchange
Workspaces
Analytics
Springboard

Data Retention Summary: Top Table Sizes

   Journey Manager (JM) The transaction engine for the platform.  |    System Manager / DevOps  |  All versions This feature is related to all versions.

Manager allows you to view current top table sizes data summary.

Note

This information is only available if a Manager instance uses a MySQLMySQL is an open-source relational database management system (RDBMS). It's an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, UNIX and Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web applications and online publishing. DB.

To view top table sizes data retention summary, select System > Data Retention Management and click the Top Table Sizes tab to see the following data usage summary of 19 largest tables listed by their size in descending order.

  • Rows - the number of transaction records for this table.
  • Avg Row (KB) - the average row size in kilobytes for this table.
  • Data (MB) - the data size in megabytes for this table.
  • Indexes (MB) - the indexes size in megabytes for this table.
  • Total (MB) - the total data size in megabytes for this table.
  • DB Percentage - the percentage of total data size in megabytes for this table of the total megabytes for the top table sizes.

Next, learn how to view transactions data retention summary.