HeatWave on AWS  /  Manage Data in HeatWave  /  Maximum Number of Tables Loadable into a HeatWave Cluster

9.3 Maximum Number of Tables Loadable into a HeatWave Cluster

The maximum number of tables that can be loaded into a HeatWave Cluster depends on the shape of the DB system and the total number of columns of the tables to be loaded. If the tables have more columns, fewer tables can be loaded. See Table 9-1 for the approximate maximum number of columns and tables for each shape. As an illustration, the table shows the maximum number of tables with an average of 100 columns per table.

Tip:

You can use the HeatWave Autopilot to verify that there is sufficient memory to load the tables into your HeatWave Cluster.

Table 9-1 Limits on the Number of Columns and Tables Loadable into a HeatWave Cluster

DB System Shape Maximum number of columns (approx.) Maximum number of tables with an average of 100 columns per table (approx.)
MySQL.2.16GB 81,900 819
MySQL.4.32GB 81,900 819
MySQL.8.64GB 81,900 819
MySQL.16.128GB 81,900 819
MySQL.32.256GB 3,538,900 35,389

Note:

The estimates assume numerical data for the tables. The maximum number of columns and tables that can be loaded is reduced with string columns, because the data dictionary encoding for them incurs more memory.