PDF (US Ltr)
- 0.9Mb
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.Parent topic: Manage Data in HeatWave