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.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.

Parent topic: Manage Data in HeatWave