SHOW ACCOUNTS

Function Description

List meta-information and statistics for tenant users created under your account.

Function Syntax

> SHOW ACCOUNTS;

Tenant user information details

| Column Name | Information | Type | Data Source | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ACCOUNT_NAME | Tenant Name | varchar | mo_account | | ADMIN_NAME | Default super administrator name when creating | varchar | in the mo_user table under each tenant | | CREATED | Creation time | timestamp | mo_account | | STATUS | Current status, OPEN or SUSPENDED | varchar | mo_account | | SUSPENDED_TIME | Deactivation time | timestamp | mo_account | | DB_COUNT | Number of databases | bigint unsigned | mo_tables | | TABLE_COUNT | Number of tables | bigint unsigned | mo_tables | | ROW_COUNT | Total row count | bigint unsigned | sum(mo_table_rows()) | | SIZE | Total space used (MB) | decimal(29,3) | sum(mo_table_size(mt.reldatabase,mt.relname) | | COMMENT | COMMENT information at creation | varchar | mo_account |

Example

mysql> show accounts;
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| account_name | admin_name | created | status | suspended_time | db_count | table_count | size | comment |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| d95042d3_d421_4d9a_8d09_0bd56858xxxx | admin | 2024-02-04 02:08:54 | open | NULL | 9 | 64 | 285.436627 | |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.22 sec)