Documentation Home
MySQL HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.7Mb
PDF (A4) - 1.7Mb


MySQL HeatWave User Guide  /  ...  /  Unload Advisor Examples

2.8.5.2 Unload Advisor Examples

  • To view recommendations for tables to unload, for a particular schema:

    mysql> CALL sys.heatwave_advisor(JSON_OBJECT('auto_unload',JSON_OBJECT('mode','recommend')));
    +----------------------------------------------------------------------------------------------------------------------------------------------------------+
    | HEATWAVE UNLOAD ADVISOR                                                                                                                                  | 
    +----------------------------------------------------------------------------------------------------------------------------------------------------------+
    | This feature is in Preview Mode.                                                                                                                         |
    | Using:                                                                                                                                                   |
    |  "last_queried_hours": 24                                                                                                                                |
    |  "memory_gain_ascending": false                                                                                                                          |
    |  "limit_tables": 10                                                                                                                                      |                                                                                                                
    | Number of excluded tables: 0                                                                                                                             |
    |                                                                                                                                                          |
    | SCHEMA                   TABLE                                                                                 MEMORY GAIN               MEMORY GAIN     | 
    | NAME                     NAME                                                   REASON                    (HEATWAVE NODES)                    (HOST)     |
    | ------                   -----------      ---------------------------------------------     ------------------------------       -------------------     |
    | `tpch128`                `LINEITEM`         LAST QUERIED ON '2022-09-12 15:30:40.538585'                             10 GiB                     0 GiB    |
    | `tpch128`                `CUSTOMER`         LAST QUERIED ON '2022-09-12 15:30:40.538585'                             10 GiB                     5 GiB    |
    |                                                                                                                                                          |
    |                                                                                                                                                          |
    | Storage consumed by base relations after unload: 100 GiB                                                                                                 |
    +----------------------------------------------------------------------------------------------------------------------------------------------------------+