PolarDB-X 1.0-SQL 手冊-SHOW-SHOW-SHOW HELP

SHOW HELP 展示 DRDS 所有輔助 SQL 指令及其說明。

1. mysql> show help;

2. +-----------------------------------------+---------------------------------------------------------+---------------------------------------------+

3. | STATEMENT | DESCRIPTION | EXAMPLE |

4. +-----------------------------------------+---------------------------------------------------------+---------------------------------------------+

5. | show rule | Report all table rule | |

6. | show rule from TABLE | Report table rule | show rule from user |

7. | show full rule from TABLE | Report table full rule | show full rule from user |

8. | show topology from TABLE | Report table physical topology | show topology from user |

9. | show partitions from TABLE | Report table dbPartition or tbPartition columns | show partitions from user |

10. | show broadcasts | Report all broadcast tables | |

11. | show datasources | Report all partition db threadPool info | |

12. | show node | Report master/slave read status | |

13. | show slow | Report top 100 slow sql | |

14. | show physical_slow | Report top 100 physical slow sql | |

15. | clear slow | Clear slow data | |

16. | trace SQL | Start trace sql, use show trace to print profiling data | trace select count(*) from user; show trace |

17. | show trace | Report sql execute profiling info | |

18. | explain SQL | Report sql plan info | explain select count(*) from user |

19. | explain detail SQL | Report sql detail plan info | explain detail select count(*) from user |

20. | explain execute SQL | Report sql on physical db plan info | explain execute select count(*) from user |

21. | show sequences | Report all sequences status | |

22. | create sequence NAME [start with COUNT] | Create sequence | create sequence test start with 0 |

23. | alter sequence NAME [start with COUNT] | Alter sequence | alter sequence test start with 100000 |

24. | drop sequence NAME | Drop sequence | drop sequence test |

25. +-----------------------------------------+---------------------------------------------------------+---------------------------------------------+

26. 20 rows in set (0.00 sec)