EXPLAIN mycat
时间: 2023-10-24 08:02:53 浏览: 138
Mycat提供的EXPLAIN语句并不是用来查看执行计划的,而是用来查看路由结果的。当使用EXPLAIN mycat语句时,Mycat会将该语句路由到相应的数据源节点,并返回路由结果,而不是真正的执行计划。如果想要查询真正的执行计划,可以通过获取路由结果中的sql语句,并在具体的数据源节点上查看执行计划。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [6 Mycat原理解析-EXPLAIN语句处理](https://blog.csdn.net/u011983531/article/details/79172160)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [mysql学习笔记(13)之mycat切分规则与es基础](https://blog.csdn.net/weixin_39775274/article/details/114293873)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文