SHOW HELP
This topic describes how to execute the SHOW HELP statement.
Example
You can execute the SHOW HELP statement to view all auxiliary SQL statements supported by PolarDB-X and their descriptions.
show help;
+-----------------------------------------+---------------------------------------------------------+---------------------------------------------+
| STATEMENT | DESCRIPTION | EXAMPLE |
+-----------------------------------------+---------------------------------------------------------+---------------------------------------------+
| show rule | Report all table rule | |
| show rule from TABLE | Report table rule | show rule from user |
| show full rule from TABLE | Report table full rule | show full rule from user |
| show topology from TABLE | Report table physical topology | show topology from user |
| show partitions from TABLE | Report table dbPartition or tbPartition columns | show partitions from user |
| show broadcasts | Report all broadcast tables | |
| show datasources | Report all partition db threadPool info | |
| show node | Report master/slave read status | |
| show slow | Report top 100 slow sql | |
| show physical_slow | Report top 100 physical slow sql | |
| clear slow | Clear slow data | |
| trace SQL | Start trace sql, use show trace to print profiling data | trace select count(*) from user; show trace |
| show trace | Report sql execute profiling info | |
| explain SQL | Report sql plan info | explain select count(*) from user |
| explain detail SQL | Report sql detail plan info | explain detail select count(*) from user |
| explain execute SQL | Report sql on physical db plan info | explain execute select count(*) from user |
| show sequences | Report all sequences status | |
| create sequence NAME [start with COUNT] | Create sequence | create sequence test start with 0 |
| alter sequence NAME [start with COUNT] | Alter sequence | alter sequence test start with 100000 |
| drop sequence NAME | Drop sequence | drop sequence test |
| show db status | Report size of each physical database | show db status |
| show full db status | Report size of each physical table, support like | show full db status like user |
| show ds | Report simple partition db info | show ds |
| show connection | Report all connections info | show connection |
| show trans | Report trans info | show trans/show trans limit 2 |
| show full trans | Report all trans info | show full trans/show full trans limit 2 |
| show stats | Report all requst stats | show stats |
| show stc | Report all requst stats by partition | show stc |
| show htc | Report the CPU/LOAD/MEM/NET/GC stats | show htc |
| show ccl_rules | Report the ccl rule info | show ccl_rules |
| clear ccl_rules | Clear the ccl rules | clear ccl_rules |
| show ccl_triggers | Report the ccl trigger info | show ccl_triggers |
| clear ccl_triggers | Clear the ccl triggers | clear ccl_triggers |
+-----------------------------------------+---------------------------------------------------------+---------------------------------------------+