开发者社区> xaubllxwtvaqiu> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

开发指南—DAL语句—SHOW—SHOW HELP

简介: 本文介绍了如何使用SHOW HELP命令。
+关注继续查看

操作样例

SHOW HELP用于展示PolarDB-X所有辅助SQL指令及其说明。


mysql> 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                          |
+-----------------------------------------+---------------------------------------------------------+---------------

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
开发指南—DAL语句—SHOW—SHOW HELP
本文介绍了如何使用SHOW HELP命令。
9 0
【一步步一起学DApp开发】(三)Solidity语言讲解 | 用Solidity编写智能合约 上
【一步步一起学DApp开发】(三)Solidity语言讲解 | 用Solidity编写智能合约
79 0
重构——13将类内联化(Inline Class)
类内联化(Inline Class):某各类没有做太多的事情;将这个类的所有特性搬移到另外一个类中,然后移除原类
1291 0
2014 Asia AnShan Regional Contest --- HDU 5073 Galaxy
Galaxy Problem's Link:   http://acm.hdu.edu.cn/showproblem.php?pid=5073   Mean:  在一条数轴上,有n颗卫星,现在你可以改变k颗卫星的位置,使得剩下的n-k颗卫星到某个点(不固定)的距离的平方和最小。
793 0
C++检查注册表中.net版本号,自动安装.net安装包,然后再执行C#程序
说实在的我的C++功底太浅,希望达人不要笑话 做这篇文章主要是为了解决斯克迪亚的这个问题实现自动判定是否有.Net框架,没有就安装.Net框架!啥也不说了先来代码吧!代码中注释还算多,如仍有问题请在此文下面的评论中提出 代码 #include #include #include usi...
733 0
4725
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载