SHOW CACHE HOTSPOT

Description

This statement is used to display the hotspot information of the file cache.

Note

Before version 3.0.4, you could use the SHOW CACHE HOTSPOT statement to query cache hotspot information statistics. Starting from version 3.0.4, the use of the SHOW CACHE HOTSPOT statement for cache hotspot information statistics is no longer supported. Please directly access the system table __internal_schema.cloud_cache_hotspot for queries. For detailed usage, refer to MANAGING FILE CACHE.

Syntax

   SHOW CACHE HOTSPOT '/[<compute_group_name>/<db.table_name>]';

Parameters

Parameter Name	Description
<compute_group_name>	The name of the compute group.
<table_name>	The name of the table.

Examples

1. Display the cache hotspot information for the entire system.

   SHOW CACHE HOTSPOT '/';

2. Display the cache hotspot information for a specific compute group named my_compute_group.

   SHOW CACHE HOTSPOT '/my_compute_group/';

References

• MANAGING FILE CACHE
• WARMUP CACHE