This topic describes the common system tables in the INFORMATION_SCHEMA system database of an AnalyticDB for MySQL cluster and how to use the tables.
kepler_connection_info_merged
Queries the number of connections to an AnalyticDB for MySQL cluster by username and by client IP address. For information about how to use the kepler_connection_info_merged table, see View connection information.
The following table describes the fields:
Field | Description |
schema | The name of the database. |
last_active_time | The last time when the connection was last active. |
create_time | The time when the connection was established. |
connection_id | The connection ID. |
ip_port | The IP address and port number of the access node of the AnalyticDB for MySQL cluster. |
access_ip | The IP address of the client that is used to connect to the AnalyticDB for MySQL cluster. |
user | The username that is used to connect to the AnalyticDB for MySQL cluster. |
kepler_persist_plan_summary
Queries all patterns that are configured with hints. For information about how to use the kepler_persist_plan_summary table, see Persist plan and query blocker.
The following table describes the fields:
Field | Description |
hit_applied | The number of times the pattern is applied after the persist plan is created. |
update_time | The time when the persist plan was last modified. |
create_time | The time when the persist plan was created. |
hints | The content of the hint. |
_sql_cnt | The number of statements that hit the pattern. |
sql | The pattern. |
kepler_meta_shards
Queries the number of shards in an AnalyticDB for MySQL cluster. For information about how to use the kepler_meta_shards table, see the "Quota limits" section of the Limits topic.
SELECT count(1) FROM information_schema.kepler_meta_shards;kepler_partitions
Queries the partition information of a table. For information about how to use the kepler_partitions table, see the "Q: How do I query all list partitions of a table and their statistics after I partition the table into list partitions?" question of the Schema design topic.
The following table describes the fields:
Field | Description |
schema_name | The name of the database. |
table_name | The name of the table. |
partition_id | The partition ID. |
row_count | The number of rows in the partition. |
data_size | The total size. Unit: bytes. |
index_size | The size of the index. Unit: bytes. |
detail_size | The data size. Unit: bytes. |
pk_size | The size of the primary key. Unit: bytes. |
remote_data_size | The size of cold data. Unit: bytes. |
local_data_size | The size of hot data. Unit: bytes. |
last_access | The time when the partition was last accessed. |
create_time | The time when the partition was created. |
kepler_meta_configs
Queries the configuration parameters of an AnalyticDB for MySQL cluster. For information about how to use the kepler_meta_configs table, see the "Execute the SELECT statement to query configuration parameters" section of the Analyzers for full-text indexes topic.
The following table describes the fields:
Field | Description |
create_time | The time when the configuration parameter was configured. |
description | The description of the configuration parameter. |
key | The name of the configuration parameter. |
value | The value of the configuration parameter. |
update_time | The time when the configuration parameter was updated. |
kepler_meta_build_task
Queries the information about a BUILD job of an AnalyticDB for MySQL cluster within the last three days. For information about how to use the kepler_meta_build_task table, see the "Query the status of a BUILD job" section of the BUILD topic.
The following table describes the fields:
Field | Description |
schema_name | The name of the database. |
table_name | The name of the table. |
status | The status of the BUILD job. |
create_time | The time when the BUILD job was created. |
kepler_meta_async_jobs
Queries the information about an import job of an AnalyticDB for MySQL cluster. For information about how to use the kepler_meta_async_jobs table, see the "How do I query the import jobs that are in the running state in the current database by using a statement?" question of the Import and export topic.
The following table describes the fields:
Field | Description |
create_time | The time when the import job was created. |
start_time | The start time of the import job. |
update_time | The time when the import job was updated. |
schema_name | The name of the database. |
user_name | The username. |
process_rows | The number of rows processed by the import job. |
status | The status of the import job. |
fail_msg | The failure information. |
definition | The definition of the import job. |
exec_job_id | The ID of the import job. |
kepler_cache_table_status
Queries the data of all cache tables in an AnalyticDB for MySQL cluster. For information about how to use the kepler_cache_table_status table, see Cache tables.
The following table describes the fields:
Field | Description |
schema_name | The name of the database. |
table_name | The name of the cache table. |
cache_id | The unique ID of the cache table. |
deleting | Indicates whether the cache table is being deleted. |
occupied | The number of connections or queries that are using the cache table. |
data_size | The size of the cache table. Unit: bytes. |
create_time | The time when the cache table was created. |
visit_time | The time when the cache table was last accessed. |
update_time | The time when the cache table was last updated. |