1. MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区

{“moduleinfo”:{“icon_count”:[{“count_phone”:2,”count”:2}]},”icon”:{“name”:”基础 ICON”,”link”:”//at.alicdn.com/t/font_276948_28ii451l5wi.css”,”family”:”dbl-icon-base”},{“name”:” 云产品 “,”link”:”[//at.alicdn.com/t/font_274588_yachs0mkbn.css”,”family”:”dbl-icon-product”}],”countinfo”:{“icon”:{“length_pc”:0,”length“:0}}}

{“config”:{“moduleinfo”:{“javascripts_count”:[{“count_phone”:1,”count”:1}],”styles_count”:[{“count_phone”:3,”count”:3}],”htmls_count”:[{“count_phone”:0,”count”:0}]},”htmls”:[],”styles”:[{“text”:”.aliyun-topbar .aliyun-topbar-header .aliyun-topbar-element.sub-logo .sub-logo-link .sub-logo-image{height:22px !important;}”},{“text”:”.aliyun-topbar .aliyun-topbar-header .aliyun-topbar-element.sub-logo .sub-logo-link.pointer{display: flex;align-items:center;}”},{“text”:”.aliyun-topbar .aliyun-topbar-header .aliyun-topbar-element.aliyun-language{display:none !important;}”},{“text”:”.aliyun-topbar{ box-shadow:none; }”}],”javascripts”:[],”countinfo”:{“javascripts”:{“length_pc”:0,”length”:0},”styles”:{“length_pc”:0,”length”:0}},”header”:”activity”,”logo”:”[https://img.alicdn.com/tfs/TB1r4I1o6MZ7e4jSZFOXXX7epXa-199-40.png”,”logoLink”:”https://developer.aliyun.com/“,”searchUrl”:”https://developer.aliyun.com/search?q=MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图1search”,”searchStyle”:”窄”},”settings”:{}})

{“moduleinfo”:{“javascripts_count”:[{“count_phone”:1,”count”:1}],”styles_count”:[{“count_phone”:3,”count”:3}],”htmls_count”:[{“count_phone”:0,”count”:0}]},”htmls”:[],”styles”:[{“text”:”.aliyun-topbar .aliyun-topbar-header .aliyun-topbar-element.sub-logo .sub-logo-link .sub-logo-image{height:22px !important;}”},{“text”:”.aliyun-topbar .aliyun-topbar-header .aliyun-topbar-element.sub-logo .sub-logo-link.pointer{display: flex;align-items:center;}”},{“text”:”.aliyun-topbar .aliyun-topbar-header .aliyun-topbar-element.aliyun-language{display:none !important;}”},{“text”:”.aliyun-topbar{ box-shadow:none; }”}],”javascripts”:[],”countinfo”:{“javascripts”:{“length_pc”:0,”length”:0},”styles”:{“length_pc”:0,”length”:0}},”header”:”activity”,”logo”:”[https://img.alicdn.com/tfs/TB1r4I1o6MZ7e4jSZFOXXX7epXa-199-40.png”,”logoLink”:”https://developer.aliyun.com/“,”searchUrl”:”https://developer.aliyun.com/search?q=MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图2search”,”searchStyle”:”窄”})

{“MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图3page”:{“env”:”production”},”](https://g.yuque.com/gr/latex?context%22%3A%7B%22moduleinfo%22%3A%7B%22javascripts_count%22%3A%5C%5B%7B%22count_phone%22%3A1%2C%22count%22%3A1%7D%5D%2C%22styles_count%22%3A%5C%5B%7B%22count_phone%22%3A3%2C%22count%22%3A3%7D%5D%2C%22htmls_count%22%3A%5C%5B%7B%22count_phone%22%3A0%2C%22count%22%3A0%7D%5D%7D%2C%22htmls%22%3A%5C%5B%5D%2C%22styles%22%3A%5C%5B%7B%22text%22%3A%22.aliyun-topbar%20.aliyun-topbar-header%20.aliyun-topbar-element.sub-logo%20.sub-logo-link%20.sub-logo-image%7Bheight%3A22px%20!important%3B%7D%22%7D%2C%7B%22text%22%3A%22.aliyun-topbar%20.aliyun-topbar-header%20.aliyun-topbar-element.sub-logo%20.sub-logo-link.pointer%7Bdisplay%3A%20flex%3Balign-items%3Acenter%3B%7D%22%7D%2C%7B%22text%22%3A%22.aliyun-topbar%20.aliyun-topbar-header%20.aliyun-topbar-element.aliyun-language%7Bdisplay%3Anone%20!important%3B%7D%22%7D%2C%7B%22text%22%3A%22.aliyun-topbar%7B%20box-shadow%3Anone%3B%20%7D%22%7D%5D%2C%22javascripts%22%3A%5C%5B%5D%2C%22countinfo%22%3A%7B%22javascripts%22%3A%7B%22length_pc%22%3A0%2C%22length%22%3A0%7D%2C%22styles%22%3A%7B%22length_pc%22%3A0%2C%22length%22%3A0%7D%7D%2C%22header%22%3A%22activity%22%2C%22logo%22%3A%22%5Bhttps%3A%2F%2Fimg.alicdn.com%2Ftfs%2FTB1r4I1o6MZ7e4jSZFOXXX7epXa-199-40.png%22%2C%22logoLink%22%3A%22https%3A%2F%2Fdeveloper.aliyun.com%2F%22%2C%22searchUrl%22%3A%22https%3A%2F%2Fdeveloper.aliyun.com%2Fsearch%3Fq%3D#card=math&code=context%22%3A%7B%22moduleinfo%22%3A%7B%22javascripts_count%22%3A%5C%5B%7B%22count_phone%22%3A1%2C%22count%22%3A1%7D%5D%2C%22styles_count%22%3A%5C%5B%7B%22count_phone%22%3A3%2C%22count%22%3A3%7D%5D%2C%22htmls_count%22%3A%5C%5B%7B%22count_phone%22%3A0%2C%22count%22%3A0%7D%5D%7D%2C%22htmls%22%3A%5C%5B%5D%2C%22styles%22%3A%5C%5B%7B%22text%22%3A%22.aliyun-topbar%20.aliyun-topbar-header%20.aliyun-topbar-element.sub-logo%20.sub-logo-link%20.sub-logo-image%7Bheight%3A22px%20%21important%3B%7D%22%7D%2C%7B%22text%22%3A%22.aliyun-topbar%20.aliyun-topbar-header%20.aliyun-topbar-element.sub-logo%20.sub-logo-link.pointer%7Bdisplay%3A%20flex%3Balign-items%3Acenter%3B%7D%22%7D%2C%7B%22text%22%3A%22.aliyun-topbar%20.aliyun-topbar-header%20.aliyun-topbar-element.aliyun-language%7Bdisplay%3Anone%20%21important%3B%7D%22%7D%2C%7B%22text%22%3A%22.aliyun-topbar%7B%20box-shadow%3Anone%3B%20%7D%22%7D%5D%2C%22javascripts%22%3A%5C%5B%5D%2C%22countinfo%22%3A%7B%22javascripts%22%3A%7B%22length_pc%22%3A0%2C%22length%22%3A0%7D%2C%22styles%22%3A%7B%22length_pc%22%3A0%2C%22length%22%3A0%7D%7D%2C%22header%22%3A%22activity%22%2C%22logo%22%3A%22%5Bhttps%3A%2F%2Fimg.alicdn.com%2Ftfs%2FTB1r4I1o6MZ7e4jSZFOXXX7epXa-199-40.png%22%2C%22logoLink%22%3A%22https%3A%2F%2Fdeveloper.aliyun.com%2F%22%2C%22searchUrl%22%3A%22https%3A%2F%2Fdeveloper.aliyun.com%2Fsearch%3Fq%3D)search","searchStyle":" 窄 "}}

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图5
MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图6

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图7

中国站

中国站

简体中文

International

English简体中文繁體中文日本語한국어DeutschFrançaisBahasa Indonesiaไทย

Country/Region

Australia - EnglishEurope - EnglishIndia - EnglishIndonesia - EnglishMalaysia - EnglishSingapore - EnglishUnited States - English中國香港 - 繁體中文Việt Nam - Tiếng Việt日本 - 日本語

文档备案控制台登录立即注册

我的阿里云

飞天会员

{“choiceType”:”官网通用导航”,”isTop”:true,”isLanguage”:true,”isCart”:true,”isInfoSearch”:true,”menu”:{“text”:”最新活动”,”link”:”https://www.aliyun.com/activity”,”isBlank”:false,”dropdownOpen”:”_blank”},{“text”:” 产品 “,”isBlank”:false,”source”:”9890595”,”link”:”https://www.aliyun.com/product/list”,”isleftShow”:true,”placeholderText”:” 搜索云产品 “,”dropdownOpen”:”_self”},{“text”:” 解决方案 “,”isBlank”:false,”source”:”9722694”,”link”:”https://www.aliyun.com/solution/all”,”isleftShow”:true,”placeholderText”:” 搜索解决方案 “,”dropdownOpen”:”_self”},{“text”:” 云市场 “,”link”:”https://market.aliyun.com/“,”source”:”9152649”,”isBlank”:true,”innerIsBlank”:true,”dropdownOpen”:”_blank”,”dropdownTitle”:” 云市场 “,”dropdownDesc”:” 阿里云市场携手 1000 + 第三方服务商合作,为您提供 20000+ 商品及服务,满足您的不同需求。”},{“text”:” 合作伙伴 “,”link”:”[https://partner.aliyun.com/“,”source”:”9732600”,”isBlank”:false,”dropdownOpen”:”_blank”,”dropdownTitle”:” 合作伙伴 “,”dropdownDesc”:” 基于不同的合作伙伴分类,阿里云生态为伙伴提供不同的合作计划。”},{“source”:”9325708”,”text”:” 支持与服务 “,”link”:”https://www.aliyun.com/service”,”isBlank”:false,”dropdownOpen”:”_blank”,”dropdownTitle”:” 支持与服务 “,”dropdownDesc”:” 阿里云为您提供 7×24 小时专业服务,以及多样化的支持计划和专家服务,满足您从上云部署、日常运维到优化升级等全周期需求,让您的数字化转型之路更加高效敏捷。”},{“text”:” 开发者 “,”link”:”https://developer.aliyun.com/“,”source”:”9390322”,”isBlank”:true,”innerIsBlank”:true,”dropdownOpen”:”_blank”,”dropdownTitle”:” 开发者 “,”dropdownDesc”:” 为千万技术人服务的开发者内容,打造云上技术学习、信息交流平台。”},{“text”:” 了解阿里云 “,”source”:”9856553”,”isBlank”:false,”dropdownOpen”:”_blank”,”dropdownTitle”:””}\],”delay”:500,”richSearch”:{“more”:”false”,”abilityList”:[{“title”:”全部”,”hot”:”5356973”,”type”:”Default”},{“type”:”Domain”,”title”:”域名”},{“type”:”Brand”,”title”:”商标”},{“type”:”Company”,”title”:”公司”}],”placeHolder”:”建站模板”,”dialogTitle”:”需求选择”,”dialogDesc”:”请选择您的需求”},”serviceDomain”:{“productConfig”:{“maxProductNumber”:6,”freeTrial”:[{“title”:”计算型云服务器 ECS”,”authentication”:”企业认证”,”description”:”弹性可伸缩的计算服务,助您降低 IT 成本”,”tags”:[“营销标签”],”actionTitle”:”0 元试用”,”actionLink”:”https://www.aliyun.com”}\],”newPersonOnlyConfig”:{“title”:”新人推荐”,”buttons”:{“text”:”新人优惠”,”link”:”[https://www.aliyun.com/1111/new”,”backgroundImage”:”https://img.alicdn.com/tfs/TB14r633Yr1gK0jSZFDXXb9yVXa-100-84.png”},{“text”:” 爆款推荐 “,”link”:”https://www.aliyun.com/activity/daily/bestoffer","backgroundImage":"https://img.alicdn.com/tfs/TB1J6203.H1gK0jSZSyXXXtlpXa-100-84.png"}\]},”freeTrialConfig”:{“title”:”免费试用”,”buttons”:{“text”:”试用中心(100 + 款产品免费试用)”,”link”:”[https://free.aliyun.com/?spm=5176.19720258.J_2937333540.3.5dd62c4aXWAFRm”,”backgroundImage”:”https://img.alicdn.com/tfs/TB1J_LT31L2gK0jSZPhXXahvXXa-100-84.png”}\]}},”serviceConfig”:{“orderService”:”%5D%7D%7D,%22serviceConfig%22:%7B%22orderService%22:%22) 通过官网工单提供 7*24 小时的技术及业务咨询基础服务 “,”selfHelp”:” 通过智能,风险评估等自助工具,提供常见问题的自动诊断与云商业务健康性评估 “,”enterpriseService”:” 阿里云技术专家为您提供上云架构咨询、迁移及部署服务、云上运维和护航、架构优化、容灾建设等全周期专业技术服务。”,”feedbackText”:”“我的阿里云” 有奖调研 “,”feedbackBtnText”:” 立即参与 “,”feedbackLink”:”https://survey.aliyun.com/apps/zhiliao/ImVJFgO_n”},”double11Config”:{“hidden”:true,”icon”:”https://img.alicdn.com/tfs/TB1InrZ32b2gK0jSZK9XXaEgFXa-84-40.png”,”dueTime”:”2020-12-31”}},”basic”:{“choiceType”:” 运营活动页导航 “,”isTop”:false,”isCart”:false,”isLanguage”:true,”isInfoSearch”:true,”delay”:500,”isCartFloat”:true},”mobileConfig”:{“menuList”:[{“title”:” 热门产品 “,”poolId”:”10433381”},{“title”:” 云产品 “,”poolId”:”10404356”},{“poolId”:”10115954”,”title”:” 解决方案 “},{“title”:” 企业应用中心 “,”href”:”https://ac.aliyun.com/“},{“title”:” 云市场 “,”poolId”:”10818606”},{“title”:” 支持与服务 “,”poolId”:”10847728”},{“title”:” 云栖号 “,”poolId”:”10520549”},{“title”:” 阿里云大学 “,”poolId”:”10544724”},{“title”:” 帮助与文档 “,”href”:”https://help.aliyun.com/“},{“title”:” 聆听(提交建议)”,”href”:”https://www.aliyun.com/connect/home”}],”portalList”:[{“title”:” 我的订单 “,”href”:”https://m.aliyun.com/product/expense/orderList#/list/cloud”,”subTitle”:””},{“title”:”我的卡券”,”href”:”https://m.aliyun.com/product/expense/cards”},{“title”:”我的提货券”,”href”:”https://www.aliyun.com/page-source/website/buy/redeem#/home”},{“title”:”我的积分”,”href”:”https://club.aliyun.com/app/index.htm”,”subTitle”:”做任务,领积分”},{“title”:”推荐奖励”,”subTitle”:”赚现金”,”href”:”https://promotion.aliyun.com/ntms/yunparter/zhaomu.html”},{“title”:”管理控制台”,”href”:”https://promotion.aliyun.com/ntms/yunparter/zhaomu.html?utm_source=mmenu”}]},”rightFloat”:{“btn”:{“btnText”:”有奖调研”,”btnBgSatrt”:”#FF5685”,”btnBgMiddle”:”#FF7B00”,”btnBgEnd”:”#FF9B00”,”btnBg”:”https://img.alicdn.com/tfs/TB1bCEMoQ9l0K4jSZFKXXXFjpXa-84-192.png”,”btnClick”:”yes”},”card”:{“cardBgSatrt”:”#FF5685”,”cardBgMiddle”:”#FF7B00”,”cardBgEnd”:”#FF9B00”,”cardBgEt”:”https://img.alicdn.com/tfs/TB18Fa6jIieb18jSZFvXXaI3FXa-280-200.gif”,”cardBgEtBorder”:””,”title”:” 首页全新升级,邀您参与反馈 “,”subTitle”:” 新版首页增加了服务模块、企业应用模块等内容,满足您一站式上云需求,期待您的反馈!”,”cardBtnText”:” 我要反馈 “,”cardBtnAction”:”https://survey.aliyun.com/apps/zhiliao/V6HcNS2uo”,”cardBtnColor”:”#FF6A00”,”cardBtnBgStart”:”#FFFDF9”,”cardBtnBgEnd”:”#FFF5D5”,”cardBg”:”https://img.alicdn.com/tfs/TB1E2GHpP39YK4jSZPcXXXrUFXa-584-340.png”},”rightsContent”:{“title”:” 会员权益 “,”desc”:” 享专属优惠 / 兑定制礼品 “,”isRightsShow”:false},”myAliyun”:{“isMyAliyunShow”:true}},”hostList”:[{“host”:”homon.aliyun-inc.com”,”btn”:{“btnClick”:”yes”,”btnText”:” 调研返券 “,”btnBgSatrt”:”#FF5685”,”btnBgMiddle”:”#FF7B00”,”btnBgEnd”:”#FF9B00”},”card”:{“cardBgSatrt”:”#FF5685”,”cardBgMiddle”:”#FF7B00”,”cardBgEnd”:”#FF9B00”,”cardBg”:”https://img.alicdn.com/tfs/TB1ks7cY.Y1gK0jSZFMXXaWcVXa-584-340.png”,”cardBgEt”:”https://img.alicdn.com/tfs/TB1hR7bYWL7gK0jSZFBXXXZZpXa-280-200.gif”,”title”:” 新版首页上线,邀您反馈意见 “,”subTitle”:” 新版首页上线啦,本次改版我们新增了服务域模块,此处填写一段话的亮点介绍。”,”cardBtnText”:” 填写有奖问卷 “,”cardBtnAction”:”http://aliyun.com/“,”cardBtnColor”:”#FF6A00”,”cardBtnBgStart”:”#FFF5D5”,”cardBtnBgEnd”:”#FFFDF9”}}],”guide”:{“noLogin”:”https://img.alicdn.com/tfs/TB1EyEF4xv1gK0jSZFFXXb0sXXa-720-520.png”,”login”:”https://img.alicdn.com/tfs/TB1qo.n4AL0gK0jSZFtXXXQCXXa-720-520.png”,”guideType”:”newUser”,”register”:””,”registerLink”:””,”guidePage”:”all”},”rightsContent”:{“title”:” 会员权益 “,”desc”:” 享专属优惠 / 兑定制礼品 “,”link”:”https://club.aliyun.com/?spm=5176.19720258.J_8058803260.1282.3db82c4apFjrKY#/“}} {“recommend”:{“visibleMode”:”default”},”anchor”:{“visibleMode”:”all”},”pc”:{“background”:””,”horizontal”:” 通栏 “,”verticalNumber”:0,”marginTop”:”0”,”marginBottom”:”0”,”contentBackground”:””,”paddingHoz”:”0”,”paddingTop”:”0”,”paddingBottom”:”0”,”backgroundImage”:””,”autoHeight”:false},”h5”:{“background”:””,”horizontal”:”通栏”,”verticalNumber”:0,”marginTop”:”0”,”marginBottom”:”0”,”contentBackground”:””,”paddingHoz”:”0”,”paddingTop”:”0”,”paddingBottom”:”0”,”backgroundImage”:””,”autoHeight”:false}}

{“config”:{“moduleinfo”:{“question”:”//developer.aliyun.com/ask/new”,”rightTitle”:”个人中心”,”menu_count”:[{“count_phone”:8,”count”:8}],”article”:”//developer.aliyun.com/article/new”,”rightMenu_count”:[{“count_phone”:3,”count”:3}]},”menu”:[{“ismoreList”:false,”menuTitle”:”首页”,”menuLink”:”//developer.aliyun.com”},{“ismoreList”:false,”submenu”:{“submenuTitle”:”大数据”,”submenuLink”:”//developer.aliyun.com/community/bigdata”},{“submenuLink”:”//developer.aliyun.com/community/chip”,”submenuTitle”:”平头哥芯片”},{“submenuTitle”:”操作系统”,”submenuLink”:”[https://openanolis.org/“},{“submenuTitle”:” 云原生 “,”submenuLink”:”//developer.aliyun.com/community/cloudnative”},{“submenuTitle”:”ECS”,”submenuLink”:”//developer.aliyun.com/community/ecs”},{“submenuTitle”:” 数据库 “,”submenuLink”:”//developer.aliyun.com/community/database”},{“submenuTitle”:” 存储 “,”submenuLink”:”//developer.aliyun.com/group/storage”},{“submenuTitle”:” 容器服务 “,”submenuLink”:”//developer.aliyun.com/group/kubernetes”},{“submenuTitle”:” 中间件 “,”submenuLink”:”//developer.aliyun.com/group/aliware”},{“submenuTitle”:” 研发效能 “,”submenuLink”:”//developer.aliyun.com/group/yunxiao”},{“submenuTitle”:” 查看更多 >”,”submenuLink”:”[//developer.aliyun.com/group”}](https://openanolis.org/“},{“submenuTitle”:”云原生”,”submenuLink”:”//developer.aliyun.com/community/cloudnative”},{“submenuTitle”:”ECS”,”submenuLink”:”//developer.aliyun.com/community/ecs”},{“submenuTitle”:”数据库”,”submenuLink”:”//developer.aliyun.com/community/database”},{“submenuTitle”:”存储”,”submenuLink”:”//developer.aliyun.com/group/storage”},{“submenuTitle”:”容器服务”,”submenuLink”:”//developer.aliyun.com/group/kubernetes”},{“submenuTitle”:”中间件”,”submenuLink”:”//developer.aliyun.com/group/aliware”},{“submenuTitle”:”研发效能”,”submenuLink”:”//developer.aliyun.com/group/yunxiao”},{“submenuTitle”:”查看更多>”,”submenuLink”:”//developer.aliyun.com/group”})],”menuTitle”:”技术与产品”,”menuLink”:””},{“ismoreList”:false,”menuTitle”:”%5D,%22menuTitle%22:%22%E6%8A%80%E6%9C%AF%E4%B8%8E%E4%BA%A7%E5%93%81%22,%22menuLink%22:%22%22%7D,%7B%22ismoreList%22:false,%22menuTitle%22:%22) 社区 “,”menuLink”:””,”submenu”:[{“submenuLink”:”[https://developer.aliyun.com/indexFeed/“,”submenuTitle”:” 文章 “},{“submenuTitle”:” 活动 “,”submenuLink”:”//developer.aliyun.com/event/“},{“submenuTitle”:” 问答 “,”submenuLink”:”//developer.aliyun.com/ask/“},{“submenuLink”:”//developer.aliyun.com/ebook”,”submenuTitle”:” 藏经阁 “},{“submenuLink”:”//mvp.aliyun.com“,”submenuTitle”:”MVP”},{“submenuTitle”:”ACE”,”submenuLink”:”//developer.aliyun.com/group/ace”}\]},{“ismoreList”:false,”submenu”:{“submenuTitle”:”开发者直播年终盘点”,”submenuLink”:”//developer.aliyun.com/topic//lives/compilation”},{“submenuTitle”:”周二开源日”,”submenuLink”:”//developer.aliyun.com/topic/opensourceday”},{“submenuTitle”:”数据库大讲堂”,”submenuLink”:”//developer.aliyun.com/topic/database/lives”},{“submenuLink”:”//yqh.aliyun.com/live”,”submenuTitle”:”云栖号”},{“submenuTitle”:”查看更多%5D%7D,%7B%22ismoreList%22:false,%22submenu%22:%5B%7B%22submenuTitle%22:%22%E5%BC%80%E5%8F%91%E8%80%85%E7%9B%B4%E6%92%AD%E5%B9%B4%E7%BB%88%E7%9B%98%E7%82%B9%22,%22submenuLink%22:%22//developer.aliyun.com/topic//lives/compilation%22%7D,%7B%22submenuTitle%22:%22%E5%91%A8%E4%BA%8C%E5%BC%80%E6%BA%90%E6%97%A5%22,%22submenuLink%22:%22//developer.aliyun.com/topic/opensourceday%22%7D,%7B%22submenuTitle%22:%22%E6%95%B0%E6%8D%AE%E5%BA%93%E5%A4%A7%E8%AE%B2%E5%A0%82%22,%22submenuLink%22:%22//developer.aliyun.com/topic/database/lives%22%7D,%7B%22submenuLink%22:%22//yqh.aliyun.com/live%22,%22submenuTitle%22:%22%E4%BA%91%E6%A0%96%E5%8F%B7%22%7D,%7B%22submenuTitle%22:%22%E6%9F%A5%E7%9C%8B%E6%9B%B4%E5%A4%9A) >”,”submenuLink”:”[//developer.aliyun.com/live”}],”menuTitle”:”直播”,”menuLink”:”//developer.aliyun.com/live”},{“ismoreList”:false,”submenu”:{“submenuTitle”:”学习中心”,”submenuLink”:”//developer.aliyun.com/learning”,”tce_rule_count”:”1”},{“submenuTitle”:” 技能测试中心 “,”submenuLink”:”//developer.aliyun.com/exam”,”tce_rule_count”:”1”},{“submenuTitle”:” 考试认证 “,”submenuLink”:”//edu.aliyun.com/certification”,”tce_rule_count”:”1”},{“submenuLink”:”//edu.aliyun.com/recruit”,”submenuTitle”:” 找工作 “}],”menuTitle”:”开发者学院”},{“menuTitle”:”开发者云”,”menuLink”:””,”menuTag”:””,”submenu”:[{“submenuTitle”:”体验实验室”,”submenuLink”:”//developer.aliyun.com/adc/labs/“},{“submenuTitle”:”AI 体验中心”,”submenuLink”:”[//developer.aliyun.com/ai/“},{“submenuTitle”:”云开发平台”,”submenuLink”:”//workbench.aliyun.com/“}]},{“ismoreList”:false,”submenu”:{“submenuTitle”:”API”,”submenuLink”:”//developer.aliyun.com/tool#tab=api”,”tce_rule_count”:”1”},{“submenuTitle”:”SDK”,”submenuLink”:”https://developer.aliyun.com/sdk/java.html”,”tce_rule_count”:”1”},{“submenuTitle”:” 云产品工具 “,”submenuLink”:”//developer.aliyun.com/tool#tab=yuntool”,”tce_rule_count”:”1”},{“submenuTitle”:” 开源工具 “,”submenuLink”:”//developer.aliyun.com/tool#tab=opensource”,”tce_rule_count”:”1”},{“submenuTitle”:” 镜像站 “,”submenuLink”:”//developer.aliyun.com/mirror”,”tce_rule_count”:”1”},{“submenuTitle”:”Code Sample”,”submenuLink”:”https://developer.aliyun.com/codesample”,”tce_rule_count”:”1”},{“submenuLink”:”//start.aliyun.com/“,”submenuTitle”:”Java Initializr”}],”menuTitle”:”开发工具”,”menuLink”:””},{“ismoreList”:false,”menuTitle”:” 天池大赛 “,”menuLink”:”//tianchi.aliyun.com“,”menuTag”:””},{“menuTitle”:”扶持计划”,”menuLink”:””,”menuTag”:””,”ismoreList”:false,”submenu”:[{“submenuTitle”:”开发者成长计划”,”submenuLink”:”[//developer.aliyun.com/plan/promotion/1”},{“submenuTitle”:”阿里云创新中心”,”submenuLink”:”//chuangke.aliyun.com”}]}],”rightMenu”:{“menuTitle”:”个人设置”,”menuLink”:”//developer.aliyun.com/my#/settings”},{“menuTitle”:”我的问答”,”menuLink”:”//developer.aliyun.com/my#/ask”},{“menuTitle”:”我的文章”,”menuLink”:”//developer.aliyun.com/my#/article”},{“menuTitle”:”我的关注”,”menuLink”:”//developer.aliyun.com/my#/follow”},{“menuTitle”:”我的课程”,”menuLink”:”//developer.aliyun.com/my/courses/learning”},{“menuTitle”:”我的档案”,”menuLink”:”//developer.aliyun.com/myPortrait”}],”countinfo”:{“menu”:{“length_pc”:0,”length”:0},”rightMenu”:{“length_pc”:0,”length”:0}},”publicity”:{“img”:”https://img.alicdn.com/tfs/TB1RiMHqWNj0u4jSZFyXXXgMVXa-200-100.gif”,”link”:”https://developer.aliyun.com/plan/promotion/1?utm_content=g_1000199894”,”locaid”:”d100010001”,”id”:”1”,”ext”:”advertising”}},”settings”:{}}

{“moduleinfo”:{“question”:”//developer.aliyun.com/ask/new”,”rightTitle”:”个人中心”,”menu_count”:[{“count_phone”:8,”count”:8}],”article”:”//developer.aliyun.com/article/new”,”rightMenu_count”:[{“count_phone”:3,”count”:3}]},”menu”:[{“ismoreList”:false,”menuTitle”:”首页”,”menuLink”:”//developer.aliyun.com”},{“ismoreList”:false,”submenu”:{“submenuTitle”:”大数据”,”submenuLink”:”//developer.aliyun.com/community/bigdata”},{“submenuLink”:”//developer.aliyun.com/community/chip”,”submenuTitle”:”平头哥芯片”},{“submenuTitle”:”操作系统”,”submenuLink”:”[https://openanolis.org/“},{“submenuTitle”:” 云原生 “,”submenuLink”:”//developer.aliyun.com/community/cloudnative”},{“submenuTitle”:”ECS”,”submenuLink”:”//developer.aliyun.com/community/ecs”},{“submenuTitle”:” 数据库 “,”submenuLink”:”//developer.aliyun.com/community/database”},{“submenuTitle”:” 存储 “,”submenuLink”:”//developer.aliyun.com/group/storage”},{“submenuTitle”:” 容器服务 “,”submenuLink”:”//developer.aliyun.com/group/kubernetes”},{“submenuTitle”:” 中间件 “,”submenuLink”:”//developer.aliyun.com/group/aliware”},{“submenuTitle”:” 研发效能 “,”submenuLink”:”//developer.aliyun.com/group/yunxiao”},{“submenuTitle”:” 查看更多 >”,”submenuLink”:”[//developer.aliyun.com/group”}](https://openanolis.org/“},{“submenuTitle”:”云原生”,”submenuLink”:”//developer.aliyun.com/community/cloudnative”},{“submenuTitle”:”ECS”,”submenuLink”:”//developer.aliyun.com/community/ecs”},{“submenuTitle”:”数据库”,”submenuLink”:”//developer.aliyun.com/community/database”},{“submenuTitle”:”存储”,”submenuLink”:”//developer.aliyun.com/group/storage”},{“submenuTitle”:”容器服务”,”submenuLink”:”//developer.aliyun.com/group/kubernetes”},{“submenuTitle”:”中间件”,”submenuLink”:”//developer.aliyun.com/group/aliware”},{“submenuTitle”:”研发效能”,”submenuLink”:”//developer.aliyun.com/group/yunxiao”},{“submenuTitle”:”查看更多>”,”submenuLink”:”//developer.aliyun.com/group”})],”menuTitle”:”技术与产品”,”menuLink”:””},{“ismoreList”:false,”menuTitle”:”%5D,%22menuTitle%22:%22%E6%8A%80%E6%9C%AF%E4%B8%8E%E4%BA%A7%E5%93%81%22,%22menuLink%22:%22%22%7D,%7B%22ismoreList%22:false,%22menuTitle%22:%22) 社区 “,”menuLink”:””,”submenu”:[{“submenuLink”:”[https://developer.aliyun.com/indexFeed/“,”submenuTitle”:” 文章 “},{“submenuTitle”:” 活动 “,”submenuLink”:”//developer.aliyun.com/event/“},{“submenuTitle”:” 问答 “,”submenuLink”:”//developer.aliyun.com/ask/“},{“submenuLink”:”//developer.aliyun.com/ebook”,”submenuTitle”:” 藏经阁 “},{“submenuLink”:”//mvp.aliyun.com“,”submenuTitle”:”MVP”},{“submenuTitle”:”ACE”,”submenuLink”:”//developer.aliyun.com/group/ace”}\]},{“ismoreList”:false,”submenu”:{“submenuTitle”:”开发者直播年终盘点”,”submenuLink”:”//developer.aliyun.com/topic//lives/compilation”},{“submenuTitle”:”周二开源日”,”submenuLink”:”//developer.aliyun.com/topic/opensourceday”},{“submenuTitle”:”数据库大讲堂”,”submenuLink”:”//developer.aliyun.com/topic/database/lives”},{“submenuLink”:”//yqh.aliyun.com/live”,”submenuTitle”:”云栖号”},{“submenuTitle”:”查看更多%5D%7D,%7B%22ismoreList%22:false,%22submenu%22:%5B%7B%22submenuTitle%22:%22%E5%BC%80%E5%8F%91%E8%80%85%E7%9B%B4%E6%92%AD%E5%B9%B4%E7%BB%88%E7%9B%98%E7%82%B9%22,%22submenuLink%22:%22//developer.aliyun.com/topic//lives/compilation%22%7D,%7B%22submenuTitle%22:%22%E5%91%A8%E4%BA%8C%E5%BC%80%E6%BA%90%E6%97%A5%22,%22submenuLink%22:%22//developer.aliyun.com/topic/opensourceday%22%7D,%7B%22submenuTitle%22:%22%E6%95%B0%E6%8D%AE%E5%BA%93%E5%A4%A7%E8%AE%B2%E5%A0%82%22,%22submenuLink%22:%22//developer.aliyun.com/topic/database/lives%22%7D,%7B%22submenuLink%22:%22//yqh.aliyun.com/live%22,%22submenuTitle%22:%22%E4%BA%91%E6%A0%96%E5%8F%B7%22%7D,%7B%22submenuTitle%22:%22%E6%9F%A5%E7%9C%8B%E6%9B%B4%E5%A4%9A) >”,”submenuLink”:”[//developer.aliyun.com/live”}],”menuTitle”:”直播”,”menuLink”:”//developer.aliyun.com/live”},{“ismoreList”:false,”submenu”:{“submenuTitle”:”学习中心”,”submenuLink”:”//developer.aliyun.com/learning”,”tce_rule_count”:”1”},{“submenuTitle”:” 技能测试中心 “,”submenuLink”:”//developer.aliyun.com/exam”,”tce_rule_count”:”1”},{“submenuTitle”:” 考试认证 “,”submenuLink”:”//edu.aliyun.com/certification”,”tce_rule_count”:”1”},{“submenuLink”:”//edu.aliyun.com/recruit”,”submenuTitle”:” 找工作 “}],”menuTitle”:”开发者学院”},{“menuTitle”:”开发者云”,”menuLink”:””,”menuTag”:””,”submenu”:[{“submenuTitle”:”体验实验室”,”submenuLink”:”//developer.aliyun.com/adc/labs/“},{“submenuTitle”:”AI 体验中心”,”submenuLink”:”[//developer.aliyun.com/ai/“},{“submenuTitle”:”云开发平台”,”submenuLink”:”//workbench.aliyun.com/“}]},{“ismoreList”:false,”submenu”:{“submenuTitle”:”API”,”submenuLink”:”//developer.aliyun.com/tool#tab=api”,”tce_rule_count”:”1”},{“submenuTitle”:”SDK”,”submenuLink”:”https://developer.aliyun.com/sdk/java.html”,”tce_rule_count”:”1”},{“submenuTitle”:” 云产品工具 “,”submenuLink”:”//developer.aliyun.com/tool#tab=yuntool”,”tce_rule_count”:”1”},{“submenuTitle”:” 开源工具 “,”submenuLink”:”//developer.aliyun.com/tool#tab=opensource”,”tce_rule_count”:”1”},{“submenuTitle”:” 镜像站 “,”submenuLink”:”//developer.aliyun.com/mirror”,”tce_rule_count”:”1”},{“submenuTitle”:”Code Sample”,”submenuLink”:”https://developer.aliyun.com/codesample”,”tce_rule_count”:”1”},{“submenuLink”:”//start.aliyun.com/“,”submenuTitle”:”Java Initializr”}],”menuTitle”:”开发工具”,”menuLink”:””},{“ismoreList”:false,”menuTitle”:” 天池大赛 “,”menuLink”:”//tianchi.aliyun.com“,”menuTag”:””},{“menuTitle”:”扶持计划”,”menuLink”:””,”menuTag”:””,”ismoreList”:false,”submenu”:[{“submenuTitle”:”开发者成长计划”,”submenuLink”:”[//developer.aliyun.com/plan/promotion/1”},{“submenuTitle”:”阿里云创新中心”,”submenuLink”:”//chuangke.aliyun.com”}]}],”rightMenu”:{“menuTitle”:”个人设置”,”menuLink”:”//developer.aliyun.com/my#/settings”},{“menuTitle”:”我的问答”,”menuLink”:”//developer.aliyun.com/my#/ask”},{“menuTitle”:”我的文章”,”menuLink”:”//developer.aliyun.com/my#/article”},{“menuTitle”:”我的关注”,”menuLink”:”//developer.aliyun.com/my#/follow”},{“menuTitle”:”我的课程”,”menuLink”:”//developer.aliyun.com/my/courses/learning”},{“menuTitle”:”我的档案”,”menuLink”:”//developer.aliyun.com/myPortrait”}],”countinfo”:{“menu”:{“length_pc”:0,”length”:0},”rightMenu”:{“length_pc”:0,”length”:0}},”publicity”:{“img”:”https://img.alicdn.com/tfs/TB1RiMHqWNj0u4jSZFyXXXgMVXa-200-100.gif”,”link”:”https://developer.aliyun.com/plan/promotion/1?utm_content=g_1000199894”,”locaid”:”d100010001”,”id”:”1”,”ext”:”advertising”}}

{“MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图8page”:{“env”:”production”},”$context”:{“moduleinfo”:{“question”:”//developer.aliyun.com/ask/new”,”rightTitle”:”个人中心”,”menu_count”:[{“count_phone”:8,”count”:8}],”article”:”//developer.aliyun.com/article/new”,”rightMenu_count”:[{“count_phone”:3,”count”:3}]},”menu”:[{“ismoreList”:false,”menuTitle”:”首页”,”menuLink”:”//developer.aliyun.com”},{“ismoreList”:false,”submenu”:{“submenuTitle”:”大数据”,”submenuLink”:”//developer.aliyun.com/community/bigdata”},{“submenuLink”:”//developer.aliyun.com/community/chip”,”submenuTitle”:”平头哥芯片”},{“submenuTitle”:”操作系统”,”submenuLink”:”[https://openanolis.org/“},{“submenuTitle”:” 云原生 “,”submenuLink”:”//developer.aliyun.com/community/cloudnative”},{“submenuTitle”:”ECS”,”submenuLink”:”//developer.aliyun.com/community/ecs”},{“submenuTitle”:” 数据库 “,”submenuLink”:”//developer.aliyun.com/community/database”},{“submenuTitle”:” 存储 “,”submenuLink”:”//developer.aliyun.com/group/storage”},{“submenuTitle”:” 容器服务 “,”submenuLink”:”//developer.aliyun.com/group/kubernetes”},{“submenuTitle”:” 中间件 “,”submenuLink”:”//developer.aliyun.com/group/aliware”},{“submenuTitle”:” 研发效能 “,”submenuLink”:”//developer.aliyun.com/group/yunxiao”},{“submenuTitle”:” 查看更多 >”,”submenuLink”:”[//developer.aliyun.com/group”}](https://openanolis.org/“},{“submenuTitle”:”云原生”,”submenuLink”:”//developer.aliyun.com/community/cloudnative”},{“submenuTitle”:”ECS”,”submenuLink”:”//developer.aliyun.com/community/ecs”},{“submenuTitle”:”数据库”,”submenuLink”:”//developer.aliyun.com/community/database”},{“submenuTitle”:”存储”,”submenuLink”:”//developer.aliyun.com/group/storage”},{“submenuTitle”:”容器服务”,”submenuLink”:”//developer.aliyun.com/group/kubernetes”},{“submenuTitle”:”中间件”,”submenuLink”:”//developer.aliyun.com/group/aliware”},{“submenuTitle”:”研发效能”,”submenuLink”:”//developer.aliyun.com/group/yunxiao”},{“submenuTitle”:”查看更多>”,”submenuLink”:”//developer.aliyun.com/group”})],”menuTitle”:”技术与产品”,”menuLink”:””},{“ismoreList”:false,”menuTitle”:”%5D,%22menuTitle%22:%22%E6%8A%80%E6%9C%AF%E4%B8%8E%E4%BA%A7%E5%93%81%22,%22menuLink%22:%22%22%7D,%7B%22ismoreList%22:false,%22menuTitle%22:%22) 社区 “,”menuLink”:””,”submenu”:[{“submenuLink”:”[https://developer.aliyun.com/indexFeed/“,”submenuTitle”:” 文章 “},{“submenuTitle”:” 活动 “,”submenuLink”:”//developer.aliyun.com/event/“},{“submenuTitle”:” 问答 “,”submenuLink”:”//developer.aliyun.com/ask/“},{“submenuLink”:”//developer.aliyun.com/ebook”,”submenuTitle”:” 藏经阁 “},{“submenuLink”:”//mvp.aliyun.com“,”submenuTitle”:”MVP”},{“submenuTitle”:”ACE”,”submenuLink”:”//developer.aliyun.com/group/ace”}\]},{“ismoreList”:false,”submenu”:{“submenuTitle”:”开发者直播年终盘点”,”submenuLink”:”//developer.aliyun.com/topic//lives/compilation”},{“submenuTitle”:”周二开源日”,”submenuLink”:”//developer.aliyun.com/topic/opensourceday”},{“submenuTitle”:”数据库大讲堂”,”submenuLink”:”//developer.aliyun.com/topic/database/lives”},{“submenuLink”:”//yqh.aliyun.com/live”,”submenuTitle”:”云栖号”},{“submenuTitle”:”查看更多%5D%7D,%7B%22ismoreList%22:false,%22submenu%22:%5B%7B%22submenuTitle%22:%22%E5%BC%80%E5%8F%91%E8%80%85%E7%9B%B4%E6%92%AD%E5%B9%B4%E7%BB%88%E7%9B%98%E7%82%B9%22,%22submenuLink%22:%22//developer.aliyun.com/topic//lives/compilation%22%7D,%7B%22submenuTitle%22:%22%E5%91%A8%E4%BA%8C%E5%BC%80%E6%BA%90%E6%97%A5%22,%22submenuLink%22:%22//developer.aliyun.com/topic/opensourceday%22%7D,%7B%22submenuTitle%22:%22%E6%95%B0%E6%8D%AE%E5%BA%93%E5%A4%A7%E8%AE%B2%E5%A0%82%22,%22submenuLink%22:%22//developer.aliyun.com/topic/database/lives%22%7D,%7B%22submenuLink%22:%22//yqh.aliyun.com/live%22,%22submenuTitle%22:%22%E4%BA%91%E6%A0%96%E5%8F%B7%22%7D,%7B%22submenuTitle%22:%22%E6%9F%A5%E7%9C%8B%E6%9B%B4%E5%A4%9A) >”,”submenuLink”:”[//developer.aliyun.com/live”}],”menuTitle”:”直播”,”menuLink”:”//developer.aliyun.com/live”},{“ismoreList”:false,”submenu”:{“submenuTitle”:”学习中心”,”submenuLink”:”//developer.aliyun.com/learning”,”tce_rule_count”:”1”},{“submenuTitle”:” 技能测试中心 “,”submenuLink”:”//developer.aliyun.com/exam”,”tce_rule_count”:”1”},{“submenuTitle”:” 考试认证 “,”submenuLink”:”//edu.aliyun.com/certification”,”tce_rule_count”:”1”},{“submenuLink”:”//edu.aliyun.com/recruit”,”submenuTitle”:” 找工作 “}],”menuTitle”:”开发者学院”},{“menuTitle”:”开发者云”,”menuLink”:””,”menuTag”:””,”submenu”:[{“submenuTitle”:”体验实验室”,”submenuLink”:”//developer.aliyun.com/adc/labs/“},{“submenuTitle”:”AI 体验中心”,”submenuLink”:”[//developer.aliyun.com/ai/“},{“submenuTitle”:”云开发平台”,”submenuLink”:”//workbench.aliyun.com/“}]},{“ismoreList”:false,”submenu”:{“submenuTitle”:”API”,”submenuLink”:”//developer.aliyun.com/tool#tab=api”,”tce_rule_count”:”1”},{“submenuTitle”:”SDK”,”submenuLink”:”https://developer.aliyun.com/sdk/java.html”,”tce_rule_count”:”1”},{“submenuTitle”:” 云产品工具 “,”submenuLink”:”//developer.aliyun.com/tool#tab=yuntool”,”tce_rule_count”:”1”},{“submenuTitle”:” 开源工具 “,”submenuLink”:”//developer.aliyun.com/tool#tab=opensource”,”tce_rule_count”:”1”},{“submenuTitle”:” 镜像站 “,”submenuLink”:”//developer.aliyun.com/mirror”,”tce_rule_count”:”1”},{“submenuTitle”:”Code Sample”,”submenuLink”:”https://developer.aliyun.com/codesample”,”tce_rule_count”:”1”},{“submenuLink”:”//start.aliyun.com/“,”submenuTitle”:”Java Initializr”}],”menuTitle”:”开发工具”,”menuLink”:””},{“ismoreList”:false,”menuTitle”:” 天池大赛 “,”menuLink”:”//tianchi.aliyun.com“,”menuTag”:””},{“menuTitle”:”扶持计划”,”menuLink”:””,”menuTag”:””,”ismoreList”:false,”submenu”:[{“submenuTitle”:”开发者成长计划”,”submenuLink”:”[//developer.aliyun.com/plan/promotion/1”},{“submenuTitle”:”阿里云创新中心”,”submenuLink”:”//chuangke.aliyun.com”}]}],”rightMenu”:{“menuTitle”:”个人设置”,”menuLink”:”//developer.aliyun.com/my#/settings”},{“menuTitle”:”我的问答”,”menuLink”:”//developer.aliyun.com/my#/ask”},{“menuTitle”:”我的文章”,”menuLink”:”//developer.aliyun.com/my#/article”},{“menuTitle”:”我的关注”,”menuLink”:”//developer.aliyun.com/my#/follow”},{“menuTitle”:”我的课程”,”menuLink”:”//developer.aliyun.com/my/courses/learning”},{“menuTitle”:”我的档案”,”menuLink”:”//developer.aliyun.com/myPortrait”}],”countinfo”:{“menu”:{“length_pc”:0,”length”:0},”rightMenu”:{“length_pc”:0,”length”:0}},”publicity”:{“img”:”https://img.alicdn.com/tfs/TB1RiMHqWNj0u4jSZFyXXXgMVXa-200-100.gif”,”link”:”https://developer.aliyun.com/plan/promotion/1?utm_content=g_1000199894”,”locaid”:”d100010001”,”id”:”1”,”ext”:”advertising”}}}

提问题

发文章

个人中心

{“config”:{“moduleinfo”:{“searchLink”:”//m.aliyun.com/product/search”,”channels_count”:[{“count_phone”:12,”count”:12}],”searchText”:”ecs”,”noAppDownload”:true,”logo”:”//gw.alicdn.com/tps/TB11eICOFXXXXaLapXXXXXXXXXX-130-39.png”},”channels”:[{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:”//developer.aliyun.com/“,”title”:”首页”},{“spmId”:”0”,”maxShowNum”:”9”,”isOpenSubChannel”:false,”title”:”技术与产品”,”subChannels”:{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/bigdata”,”title”:” 大数据 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/chip”,”title”:” 平头哥芯片 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”[https://openanolis.org/“,”title”:” 操作系统 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/cloudnative”,”title”:” 云原生 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/ecs”,”title”:”ECS”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/database”,”title”:” 数据库 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/group/storage”,”title”:” 存储 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/group/kubernetes”,”title”:” 容器服务 “},{“title”:” 中间件 “,”link”:”//developer.aliyun.com/group/aliware”},{“title”:” 研发效能 “,”link”:”//developer.aliyun.com/group/yunxiao”},{“title”:” 查看更多 >”,”link”:”[//developer.aliyun.com/group”}](https://openanolis.org/","title":"操作系统"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/community/cloudnative","title":"云原生"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/community/ecs","title":"ECS"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/community/database","title":"数据库"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/group/storage","title":"存储"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/group/kubernetes","title":"容器服务"},{"title":"中间件","link":"//developer.aliyun.com/group/aliware"},{"title":"研发效能","link":"//developer.aliyun.com/group/yunxiao"},{"title":"查看更多>”,”link”:”//developer.aliyun.com/group”})]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:”%5D%7D,%7B%22spmId%22:%220%22,%22maxShowNum%22:%226%22,%22isOpenSubChannel%22:false,%22link%22:%22%22,%22title%22:%22) 社区 “,”subChannels”:[{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”[https://developer.aliyun.com/indexFeed/“,”title”:” 文章 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/event/“,”title”:” 活动 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/ask”,”title”:” 问答 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/ebook”,”title”:” 藏经阁 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//mvp.aliyun.com“,”title”:”MVP”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//mvp.aliyun.com/ace”,”title”:”ACE”}\]},{“spmId”:”0”,”isOpenSubChannel”:false,”link”:”//developer.aliyun.com/live”,”title”:”直播”,”subChannels”:{“title”:”玩转%5D%7D,%7B%22spmId%22:%220%22,%22isOpenSubChannel%22:false,%22link%22:%22//developer.aliyun.com/live%22,%22title%22:%22%E7%9B%B4%E6%92%AD%22,%22subChannels%22:%5B%7B%22title%22:%22%E7%8E%A9%E8%BD%AC) ECS”,”link”:”//developer.aliyun.com/topic/ecs/bestpractices”},{“title”:”云栖号”,”link”:”//yqh.aliyun.com/live”},{“title”:”查看更多 >”,”link”:”//developer.aliyun.com/live”}]},{“spmId”:”0”,”channelStr”:”频道描述”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:” 开发者学院 “,”subChannels”:[{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/learning”,”title”:” 学习中心 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/exam”,”title”:” 技能测试中心 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//edu.aliyun.com/certification”,”title”:” 考试认证 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//edu.aliyun.com/recruit”,”title”:” 找工作 “}]},{“spmId”:”0”,”channelStr”:”频道描述”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:” 开发者云 “,”subChannels”:[{“tce_rule_count”:”1”,”link”:”//developer.aliyun.com/adc/labs/“,”title”:” 体验实验室 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/ai/“,”title”:”AI 体验中心 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//workbench.aliyun.com“,”title”:” 云开发平台 “}]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:” 开发工具 “,”subChannels”:{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/api”,”title”:”API”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/sdk”,”title”:”SDK”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/tool#tab=yuntool”,”title”:” 云产品工具 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/tool#tab=opensource”,”title”:” 开源工具 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/mirror”,”title”:” 镜像站 “},{“title”:”Java Initializr”,”link”:”[//start.aliyun.com/“}]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:”//tianchi.aliyun.com”,”title”:”天池大赛”},{“title”:”扶持计划”,”link”:””,”isOpenSubChannel”:false,”subChannels”:[{“title”:”开发者成长计划”,”link”:”//developer.aliyun.com/plan/promotion/1”},{“title”:”阿里云创新中心”,”link”:”//chuangke.aliyun.com”}]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”title”:”个人中心”,”subChannels”:{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/my#/settings”,”title”:” 个人设置 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/my#/ask”,”title”:” 我的问答 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/my#/article”,”title”:” 我的文章 “},{“title”:” 我的关注 “,”link”:”[//developer.aliyun.com/my#/follow”}]}],”countinfo”:{“channels”:{“length_pc”:0,”length”:0}}},”settings“:{}}

{“moduleinfo”:{“searchLink”:”//m.aliyun.com/product/search”,”channels_count”:[{“count_phone”:12,”count”:12}],”searchText”:”ecs”,”noAppDownload”:true,”logo”:”//gw.alicdn.com/tps/TB11eICOFXXXXaLapXXXXXXXXXX-130-39.png”},”channels”:[{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:”//developer.aliyun.com/“,”title”:”首页”},{“spmId”:”0”,”maxShowNum”:”9”,”isOpenSubChannel”:false,”title”:”技术与产品”,”subChannels”:{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/bigdata”,”title”:” 大数据 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/chip”,”title”:” 平头哥芯片 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”[https://openanolis.org/“,”title”:” 操作系统 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/cloudnative”,”title”:” 云原生 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/ecs”,”title”:”ECS”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/database”,”title”:” 数据库 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/group/storage”,”title”:” 存储 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/group/kubernetes”,”title”:” 容器服务 “},{“title”:” 中间件 “,”link”:”//developer.aliyun.com/group/aliware”},{“title”:” 研发效能 “,”link”:”//developer.aliyun.com/group/yunxiao”},{“title”:” 查看更多 >”,”link”:”[//developer.aliyun.com/group”}](https://openanolis.org/","title":"操作系统"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/community/cloudnative","title":"云原生"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/community/ecs","title":"ECS"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/community/database","title":"数据库"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/group/storage","title":"存储"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/group/kubernetes","title":"容器服务"},{"title":"中间件","link":"//developer.aliyun.com/group/aliware"},{"title":"研发效能","link":"//developer.aliyun.com/group/yunxiao"},{"title":"查看更多>”,”link”:”//developer.aliyun.com/group”})]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:”%5D%7D,%7B%22spmId%22:%220%22,%22maxShowNum%22:%226%22,%22isOpenSubChannel%22:false,%22link%22:%22%22,%22title%22:%22) 社区 “,”subChannels”:[{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”[https://developer.aliyun.com/indexFeed/“,”title”:” 文章 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/event/“,”title”:” 活动 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/ask”,”title”:” 问答 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/ebook”,”title”:” 藏经阁 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//mvp.aliyun.com“,”title”:”MVP”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//mvp.aliyun.com/ace”,”title”:”ACE”}\]},{“spmId”:”0”,”isOpenSubChannel”:false,”link”:”//developer.aliyun.com/live”,”title”:”直播”,”subChannels”:{“title”:”玩转%5D%7D,%7B%22spmId%22:%220%22,%22isOpenSubChannel%22:false,%22link%22:%22//developer.aliyun.com/live%22,%22title%22:%22%E7%9B%B4%E6%92%AD%22,%22subChannels%22:%5B%7B%22title%22:%22%E7%8E%A9%E8%BD%AC) ECS”,”link”:”//developer.aliyun.com/topic/ecs/bestpractices”},{“title”:”云栖号”,”link”:”//yqh.aliyun.com/live”},{“title”:”查看更多 >”,”link”:”//developer.aliyun.com/live”}]},{“spmId”:”0”,”channelStr”:”频道描述”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:” 开发者学院 “,”subChannels”:[{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/learning”,”title”:” 学习中心 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/exam”,”title”:” 技能测试中心 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//edu.aliyun.com/certification”,”title”:” 考试认证 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//edu.aliyun.com/recruit”,”title”:” 找工作 “}]},{“spmId”:”0”,”channelStr”:”频道描述”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:” 开发者云 “,”subChannels”:[{“tce_rule_count”:”1”,”link”:”//developer.aliyun.com/adc/labs/“,”title”:” 体验实验室 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/ai/“,”title”:”AI 体验中心 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//workbench.aliyun.com“,”title”:” 云开发平台 “}]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:” 开发工具 “,”subChannels”:{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/api”,”title”:”API”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/sdk”,”title”:”SDK”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/tool#tab=yuntool”,”title”:” 云产品工具 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/tool#tab=opensource”,”title”:” 开源工具 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/mirror”,”title”:” 镜像站 “},{“title”:”Java Initializr”,”link”:”[//start.aliyun.com/“}]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:”//tianchi.aliyun.com”,”title”:”天池大赛”},{“title”:”扶持计划”,”link”:””,”isOpenSubChannel”:false,”subChannels”:[{“title”:”开发者成长计划”,”link”:”//developer.aliyun.com/plan/promotion/1”},{“title”:”阿里云创新中心”,”link”:”//chuangke.aliyun.com”}]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”title”:”个人中心”,”subChannels”:{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/my#/settings”,”title”:” 个人设置 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/my#/ask”,”title”:” 我的问答 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/my#/article”,”title”:” 我的文章 “},{“title”:” 我的关注 “,”link”:”[//developer.aliyun.com/my#/follow”}]}],”countinfo”:{“channels”:{“length_pc”:0,”length“:0}}}

{“MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图9page”:{“env”:”production”},”$context”:{“moduleinfo”:{“searchLink”:”//m.aliyun.com/product/search”,”channels_count”:[{“count_phone”:12,”count”:12}],”searchText”:”ecs”,”noAppDownload”:true,”logo”:”//gw.alicdn.com/tps/TB11eICOFXXXXaLapXXXXXXXXXX-130-39.png”},”channels”:[{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:”//developer.aliyun.com/“,”title”:”首页”},{“spmId”:”0”,”maxShowNum”:”9”,”isOpenSubChannel”:false,”title”:”技术与产品”,”subChannels”:{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/bigdata”,”title”:” 大数据 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/chip”,”title”:” 平头哥芯片 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”[https://openanolis.org/“,”title”:” 操作系统 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/cloudnative”,”title”:” 云原生 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/ecs”,”title”:”ECS”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/community/database”,”title”:” 数据库 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/group/storage”,”title”:” 存储 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/group/kubernetes”,”title”:” 容器服务 “},{“title”:” 中间件 “,”link”:”//developer.aliyun.com/group/aliware”},{“title”:” 研发效能 “,”link”:”//developer.aliyun.com/group/yunxiao”},{“title”:” 查看更多 >”,”link”:”[//developer.aliyun.com/group”}](https://openanolis.org/","title":"操作系统"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/community/cloudnative","title":"云原生"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/community/ecs","title":"ECS"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/community/database","title":"数据库"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/group/storage","title":"存储"},{"spmId":"0","tce_rule_count":"1","link":"//developer.aliyun.com/group/kubernetes","title":"容器服务"},{"title":"中间件","link":"//developer.aliyun.com/group/aliware"},{"title":"研发效能","link":"//developer.aliyun.com/group/yunxiao"},{"title":"查看更多>”,”link”:”//developer.aliyun.com/group”})]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:”%5D%7D,%7B%22spmId%22:%220%22,%22maxShowNum%22:%226%22,%22isOpenSubChannel%22:false,%22link%22:%22%22,%22title%22:%22) 社区 “,”subChannels”:[{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”[https://developer.aliyun.com/indexFeed/“,”title”:” 文章 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/event/“,”title”:” 活动 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/ask”,”title”:” 问答 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/ebook”,”title”:” 藏经阁 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//mvp.aliyun.com“,”title”:”MVP”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//mvp.aliyun.com/ace”,”title”:”ACE”}\]},{“spmId”:”0”,”isOpenSubChannel”:false,”link”:”//developer.aliyun.com/live”,”title”:”直播”,”subChannels”:{“title”:”玩转%5D%7D,%7B%22spmId%22:%220%22,%22isOpenSubChannel%22:false,%22link%22:%22//developer.aliyun.com/live%22,%22title%22:%22%E7%9B%B4%E6%92%AD%22,%22subChannels%22:%5B%7B%22title%22:%22%E7%8E%A9%E8%BD%AC) ECS”,”link”:”//developer.aliyun.com/topic/ecs/bestpractices”},{“title”:”云栖号”,”link”:”//yqh.aliyun.com/live”},{“title”:”查看更多 >”,”link”:”//developer.aliyun.com/live”}]},{“spmId”:”0”,”channelStr”:”频道描述”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:” 开发者学院 “,”subChannels”:[{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/learning”,”title”:” 学习中心 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/exam”,”title”:” 技能测试中心 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//edu.aliyun.com/certification”,”title”:” 考试认证 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//edu.aliyun.com/recruit”,”title”:” 找工作 “}]},{“spmId”:”0”,”channelStr”:”频道描述”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:” 开发者云 “,”subChannels”:[{“tce_rule_count”:”1”,”link”:”//developer.aliyun.com/adc/labs/“,”title”:” 体验实验室 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/ai/“,”title”:”AI 体验中心 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//workbench.aliyun.com“,”title”:” 云开发平台 “}]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:””,”title”:” 开发工具 “,”subChannels”:{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/api”,”title”:”API”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/sdk”,”title”:”SDK”},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/tool#tab=yuntool”,”title”:” 云产品工具 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/tool#tab=opensource”,”title”:” 开源工具 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/mirror”,”title”:” 镜像站 “},{“title”:”Java Initializr”,”link”:”[//start.aliyun.com/“}]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”link”:”//tianchi.aliyun.com”,”title”:”天池大赛”},{“title”:”扶持计划”,”link”:””,”isOpenSubChannel”:false,”subChannels”:[{“title”:”开发者成长计划”,”link”:”//developer.aliyun.com/plan/promotion/1”},{“title”:”阿里云创新中心”,”link”:”//chuangke.aliyun.com”}]},{“spmId”:”0”,”maxShowNum”:”6”,”isOpenSubChannel”:false,”title”:”个人中心”,”subChannels”:{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/my#/settings”,”title”:” 个人设置 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/my#/ask”,”title”:” 我的问答 “},{“spmId”:”0”,”tce_rule_count”:”1”,”link”:”//developer.aliyun.com/my#/article”,”title”:” 我的文章 “},{“title”:” 我的关注 “,”link”:”[//developer.aliyun.com/my#/follow”}]}],”countinfo”:{“channels”:{“length_pc”:0,”length“:0}}}}

ecs

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图10

注册 登录)

abc@aliyun.com 退出)

首页

技术与产品

大数据

平头哥芯片

操作系统

云原生

ECS

数据库

存储

容器服务

中间件

研发效能

查看更多 >

社区

文章

活动

问答

藏经阁

MVP

ACE

直播

玩转 ECS

云栖号

查看更多 >

开发者学院

学习中心

技能测试中心

考试认证

找工作

开发者云

体验实验室

AI 体验中心

云开发平台

开发工具

API

SDK

云产品工具

开源工具

镜像站

Java Initializr

天池大赛

扶持计划

开发者成长计划

阿里云创新中心

个人中心

个人设置

我的问答

我的文章

我的关注

{“config”:{“step1Config”:{“title”:”欢迎来到阿里云开发者社区”,”desc”:”为您推荐热门技术圈,掌握实时技术动态,成为技术达人!”,”list”:[{“name”:”数据库”,”code”:”aliyundb”},{“code”:”sc”,”name”:”实时计算”},{“name”:”ECS”,”code”:”ecs”},{“name”:”大数据计算”,”code”:”maxcompute”},{“name”:”平头哥芯片”,”code”:”t-headocc”},{“code”:”iot”,”name”:”IoT”},{“name”:”云原生”,”code”:”cloudnative”},{“name”:”存储”,”code”:”storage”},{“name”:”容器服务”,”code”:”kubernetes”},{“name”:”中间件”,”code”:”aliware”},{“name”:”研发效能”,”code”:”yunxiao”},{“name”:”Java”,”code”:”java”}]},”step2Config”:{“title”:”精选内容推荐”,”desc”:”最新、最热活动,都在这了”,”topConfig”:{“title”:””,”desc”:””,”link”:”[https://developer.aliyun.com/plan/grow-up?spm=a2c6h.13858375.1364563.39.1aea653fkdansD","backgroundImage":"https://img.alicdn.com/tfs/TB1VaAz0eH2gK0jSZJnXXaT1FXa-2880-700.png","color":"","backgroundImageH5":"https://img.alicdn.com/tfs/TB16VYTnSR26e4jSZFEXXbwuXXa-370-90.png"},"list":\[{"img":"https://img.alicdn.com/tfs/TB1IZm9DhD1gK0jSZFsXXbldVXa-2240-538.png","link":"#","articleList":\[{"title":"AI·OS 新探索:端到端算法工程平台”,”link”:”https://developer.aliyun.com/article/774640"},{"title":"架构制图:工具与方法论","link":"https://developer.aliyun.com/article/774446"}\]},{"img":"https://img.alicdn.com/tfs/TB1IZm9DhD1gK0jSZFsXXbldVXa-2240-538.png","link":"#","articleList":\[{"title":"运维大杀器来了,未来云上服务器或将实现无人值守","link":"https://developer.aliyun.com/article/774294"},{"title":"4](https://developer.aliyun.com/plan/grow-up?spm=a2c6h.13858375.1364563.39.1aea653fkdansD%22,%22backgroundImage%22:%22https://img.alicdn.com/tfs/TB1VaAz0eH2gK0jSZJnXXaT1FXa-2880-700.png%22,%22color%22:%22%22,%22backgroundImageH5%22:%22https://img.alicdn.com/tfs/TB16VYTnSR26e4jSZFEXXbwuXXa-370-90.png%22%7D,%22list%22:%5B%7B%22img%22:%22https://img.alicdn.com/tfs/TB1IZm9DhD1gK0jSZFsXXbldVXa-2240-538.png%22,%22link%22:%22#%22,%22articleList%22:%5B%7B%22title%22:%22AI%C2%B7OS%E6%96%B0%E6%8E%A2%E7%B4%A2%EF%BC%9A%E7%AB%AF%E5%88%B0%E7%AB%AF%E7%AE%97%E6%B3%95%E5%B7%A5%E7%A8%8B%E5%B9%B3%E5%8F%B0%22,%22link%22:%22https://developer.aliyun.com/article/774640%22%7D,%7B%22title%22:%22%E6%9E%B6%E6%9E%84%E5%88%B6%E5%9B%BE%EF%BC%9A%E5%B7%A5%E5%85%B7%E4%B8%8E%E6%96%B9%E6%B3%95%E8%AE%BA%22,%22link%22:%22https://developer.aliyun.com/article/774446%22%7D%5D%7D,%7B%22img%22:%22https://img.alicdn.com/tfs/TB1IZm9DhD1gK0jSZFsXXbldVXa-2240-538.png%22,%22link%22:%22#%22,%22articleList%22:%5B%7B%22title%22:%22%E8%BF%90%E7%BB%B4%E5%A4%A7%E6%9D%80%E5%99%A8%E6%9D%A5%E4%BA%86%EF%BC%8C%E6%9C%AA%E6%9D%A5%E4%BA%91%E4%B8%8A%E6%9C%8D%E5%8A%A1%E5%99%A8%E6%88%96%E5%B0%86%E5%AE%9E%E7%8E%B0%E6%97%A0%E4%BA%BA%E5%80%BC%E5%AE%88%22,%22link%22:%22https://developer.aliyun.com/article/774294%22%7D,%7B%22title%22:%224) 个场景揭秘,如何低成本让容器化应用 Serverless 化?”,”link”:”https://developer.aliyun.com/article/773203”}\]}],”imglist”:[{“img”:”https://img.alicdn.com/tfs/TB1vvmGn_M11u4jSZPxXXahcXXa-1362-238.jpg”,”link”:”https://developer.aliyun.com/course/1011”,”imgH5”:”https://img.alicdn.com/tfs/TB1DaNIYQL0gK0jSZFAXXcA9pXa-350-150.png”}\],”articlelist”:{“title”:”掌握云上技能,方法都在这”,”link”:”[https://developer.aliyun.com/plan/grow-up”},{“title”:” 创建你的专属开发者档案,获得更多干货推荐 “,”link”:”https://developer.aliyun.com/article/750012”},{“title”:” 中小企业创业来了,补贴资源免费申请 “,”link”:”https://chuangke.aliyun.com/special/workbench”},{“title”:”3 分钟上线一个 AI 应用,立领 10 元无门槛代金券 “,”link”:”https://workbench.aliyun.com/activities/coupon”},{“link”:”https://developer.aliyun.com/article/771414”,”title”:” 阿里云藏经阁,100 本好书免费领 “}\]}},”settings”:{“recommend”:{“visibleMode”:”default”},”anchor”:{“visibleMode”:”all”},”pc”:{“background”:””,”horizontal”:” 默认 “,”verticalNumber”:0,”marginTop”:”0”,”marginBottom”:”0”,”contentBackground”:””,”paddingHoz”:”0”,”paddingTop”:”0”,”paddingBottom”:”0”,”backgroundImage”:””,”autoHeight”:false},”h5”:{“background”:””,”horizontal”:”默认”,”verticalNumber”:0,”marginTop”:”0”,”marginBottom”:”0”,”contentBackground”:””,”paddingHoz”:”0”,”paddingTop”:”0”,”paddingBottom”:”0”,”backgroundImage”:””,”autoHeight”:false}}}

{“step1Config”:{“title”:”欢迎来到阿里云开发者社区”,”desc”:”为您推荐热门技术圈,掌握实时技术动态,成为技术达人!”,”list”:[{“name”:”数据库”,”code”:”aliyundb”},{“code”:”sc”,”name”:”实时计算”},{“name”:”ECS”,”code”:”ecs”},{“name”:”大数据计算”,”code”:”maxcompute”},{“name”:”平头哥芯片”,”code”:”t-headocc”},{“code”:”iot”,”name”:”IoT”},{“name”:”云原生”,”code”:”cloudnative”},{“name”:”存储”,”code”:”storage”},{“name”:”容器服务”,”code”:”kubernetes”},{“name”:”中间件”,”code”:”aliware”},{“name”:”研发效能”,”code”:”yunxiao”},{“name”:”Java”,”code”:”java”}]},”step2Config”:{“title”:”精选内容推荐”,”desc”:”最新、最热活动,都在这了”,”topConfig”:{“title”:””,”desc”:””,”link”:”[https://developer.aliyun.com/plan/grow-up?spm=a2c6h.13858375.1364563.39.1aea653fkdansD","backgroundImage":"https://img.alicdn.com/tfs/TB1VaAz0eH2gK0jSZJnXXaT1FXa-2880-700.png","color":"","backgroundImageH5":"https://img.alicdn.com/tfs/TB16VYTnSR26e4jSZFEXXbwuXXa-370-90.png"},"list":\[{"img":"https://img.alicdn.com/tfs/TB1IZm9DhD1gK0jSZFsXXbldVXa-2240-538.png","link":"#","articleList":\[{"title":"AI·OS 新探索:端到端算法工程平台”,”link”:”https://developer.aliyun.com/article/774640"},{"title":"架构制图:工具与方法论","link":"https://developer.aliyun.com/article/774446"}\]},{"img":"https://img.alicdn.com/tfs/TB1IZm9DhD1gK0jSZFsXXbldVXa-2240-538.png","link":"#","articleList":\[{"title":"运维大杀器来了,未来云上服务器或将实现无人值守","link":"https://developer.aliyun.com/article/774294"},{"title":"4](https://developer.aliyun.com/plan/grow-up?spm=a2c6h.13858375.1364563.39.1aea653fkdansD%22,%22backgroundImage%22:%22https://img.alicdn.com/tfs/TB1VaAz0eH2gK0jSZJnXXaT1FXa-2880-700.png%22,%22color%22:%22%22,%22backgroundImageH5%22:%22https://img.alicdn.com/tfs/TB16VYTnSR26e4jSZFEXXbwuXXa-370-90.png%22%7D,%22list%22:%5B%7B%22img%22:%22https://img.alicdn.com/tfs/TB1IZm9DhD1gK0jSZFsXXbldVXa-2240-538.png%22,%22link%22:%22#%22,%22articleList%22:%5B%7B%22title%22:%22AI%C2%B7OS%E6%96%B0%E6%8E%A2%E7%B4%A2%EF%BC%9A%E7%AB%AF%E5%88%B0%E7%AB%AF%E7%AE%97%E6%B3%95%E5%B7%A5%E7%A8%8B%E5%B9%B3%E5%8F%B0%22,%22link%22:%22https://developer.aliyun.com/article/774640%22%7D,%7B%22title%22:%22%E6%9E%B6%E6%9E%84%E5%88%B6%E5%9B%BE%EF%BC%9A%E5%B7%A5%E5%85%B7%E4%B8%8E%E6%96%B9%E6%B3%95%E8%AE%BA%22,%22link%22:%22https://developer.aliyun.com/article/774446%22%7D%5D%7D,%7B%22img%22:%22https://img.alicdn.com/tfs/TB1IZm9DhD1gK0jSZFsXXbldVXa-2240-538.png%22,%22link%22:%22#%22,%22articleList%22:%5B%7B%22title%22:%22%E8%BF%90%E7%BB%B4%E5%A4%A7%E6%9D%80%E5%99%A8%E6%9D%A5%E4%BA%86%EF%BC%8C%E6%9C%AA%E6%9D%A5%E4%BA%91%E4%B8%8A%E6%9C%8D%E5%8A%A1%E5%99%A8%E6%88%96%E5%B0%86%E5%AE%9E%E7%8E%B0%E6%97%A0%E4%BA%BA%E5%80%BC%E5%AE%88%22,%22link%22:%22https://developer.aliyun.com/article/774294%22%7D,%7B%22title%22:%224) 个场景揭秘,如何低成本让容器化应用 Serverless 化?”,”link”:”https://developer.aliyun.com/article/773203”}\]}],”imglist”:[{“img”:”https://img.alicdn.com/tfs/TB1vvmGn_M11u4jSZPxXXahcXXa-1362-238.jpg”,”link”:”https://developer.aliyun.com/course/1011”,”imgH5”:”https://img.alicdn.com/tfs/TB1DaNIYQL0gK0jSZFAXXcA9pXa-350-150.png”}\],”articlelist”:{“title”:”掌握云上技能,方法都在这”,”link”:”[https://developer.aliyun.com/plan/grow-up”},{“title”:” 创建你的专属开发者档案,获得更多干货推荐 “,”link”:”https://developer.aliyun.com/article/750012”},{“title”:” 中小企业创业来了,补贴资源免费申请 “,”link”:”https://chuangke.aliyun.com/special/workbench”},{“title”:”3 分钟上线一个 AI 应用,立领 10 元无门槛代金券 “,”link”:”https://workbench.aliyun.com/activities/coupon”},{“link”:”https://developer.aliyun.com/article/771414”,”title”:” 阿里云藏经阁,100 本好书免费领 “}\]}} {“recommend”:{“visibleMode”:”default”},”anchor”:{“visibleMode”:”all”},”pc”:{“background”:””,”horizontal”:” 默认 “,”verticalNumber”:0,”marginTop”:”0”,”marginBottom”:”0”,”contentBackground”:””,”paddingHoz”:”0”,”paddingTop”:”0”,”paddingBottom”:”0”,”backgroundImage”:””,”autoHeight”:false},”h5”:{“background”:””,”horizontal”:”默认”,”verticalNumber”:0,”marginTop”:”0”,”marginBottom”:”0”,”contentBackground”:””,”paddingHoz”:”0”,”paddingTop”:”0”,”paddingBottom”:”0”,”backgroundImage”:””,”autoHeight”:false}}

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误 - 阿里云开发者社区

开发者社区> 阿里云数据库> 正文

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误

db 匠 2016-05-23 3975 浏览量

简介: 问题描述 bug 触发条件如下: 优化器先选择了 where 条件中字段的索引,该索引过滤性较好; SQL 中必须有 order by limit 从而引导优化器尝试使用 order by 字段上的索引进行优化,最终因代价问题没有成功。 复现 case 表结构 create table t

问题描述

bug 触发条件如下:

  1. 优化器先选择了 where 条件中字段的索引,该索引过滤性较好;
  2. SQL 中必须有 order by limit 从而引导优化器尝试使用 order by 字段上的索引进行优化,最终因代价问题没有成功。

复现 case

表结构

  1. create table t1(
  2. id int auto_increment primary key,
  3. a int, b int, c int,
  4. key iabc (a, b, c),
  5. key ic (c)
  6. ) engine = innodb;

构造数据

  1. insert into t1 select null,null,null,null;
  2. insert into t1 select null,null,null,null from t1;
  3. insert into t1 select null,null,null,null from t1;
  4. insert into t1 select null,null,null,null from t1;
  5. insert into t1 select null,null,null,null from t1;
  6. insert into t1 select null,null,null,null from t1;
  7. update t1 set a = id / 2, b = id / 4, c = 6 - id / 8;

触发 SQL

  1. mysql> explain select id from t1 where a<3 and b in (1, 13) and c>=3 order by c limit 2\G
  2. *************************** 1. row ***************************
  3. id: 1
  4. select_type: SIMPLE
  5. table: t1
  6. type: index
  7. possible_keys: iabc,ic
  8. key: iabc
  9. key_len: 15
  10. ref: NULL
  11. rows: 32
  12. Extra: Using where; Using index; Using filesort

使用 force index 可以选择过滤性好的索引

  1. mysql> explain select id from t1 force index(iabc) where a<3 and b in (1, 13) and c>=3 order by c limit 2\G
  2. *************************** 1. row ***************************
  3. id: 1
  4. select_type: SIMPLE
  5. table: t1
  6. type: range
  7. possible_keys: iabc
  8. key: iabc
  9. key_len: 5
  10. ref: NULL
  11. rows: 3
  12. Extra: Using where; Using index; Using filesort

问题分析

optimizer_trace 可以帮助分析这个问题。

SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G

  1. "range_scan_alternatives": [
  2. {
  3. "index": "iabc",
  4. "ranges": [
  5. "NULL < a < 3"
  6. ],
  7. "index_dives_for_eq_ranges": true,
  8. "rowid_ordered": false,
  9. "using_mrr": false,
  10. "index_only": true,
  11. "rows": 3,
  12. "cost": 1.6146,
  13. "chosen": true
  14. },
  15. {
  16. "index": "ic",
  17. "ranges": [
  18. "3 <= c"
  19. ],
  20. "index_dives_for_eq_ranges": true,
  21. "rowid_ordered": false,
  22. "using_mrr": false,
  23. "index_only": false,
  24. "rows": 17,
  25. "cost": 21.41,
  26. "chosen": false,
  27. "cause": "cost"
  28. }
  29. ],

range_scan_alternatives 计算 range_scan,各个索引的开销,从上面的结果可以看出,联合索引 iabc 开销较小,应该选择 iabc。

  1. "considered_execution_plans": [
  2. {
  3. "plan_prefix": [
  4. ],
  5. "table": "`t1`",
  6. "best_access_path": {
  7. "considered_access_paths": [
  8. {
  9. "access_type": "range",
  10. "rows": 3,
  11. "cost": 2.2146,
  12. "chosen": true
  13. }
  14. ]
  15. },
  16. "cost_for_plan": 2.2146,
  17. "rows_for_plan": 3,
  18. "chosen": true
  19. }
  20. ]

considered_execution_plans 表索引选择过程,access_type 是 range,rows_for_plan=3,到这里为止,执行计划还是符合预期的。

  1. {
  2. "clause_processing": {
  3. "clause": "ORDER BY",
  4. "original_clause": "`t1`.`c`",
  5. "items": [
  6. {
  7. "item": "`t1`.`c`"
  8. }
  9. ],
  10. "resulting_clause_is_simple": true,
  11. "resulting_clause": "`t1`.`c`"
  12. }
  13. },
  14. {
  15. "refine_plan": [
  16. {
  17. "table": "`t1`",
  18. "access_type": "index_scan"
  19. }
  20. ]
  21. },
  22. {
  23. "reconsidering_access_paths_for_index_ordering": {
  24. "clause": "ORDER BY",
  25. "index_order_summary": {
  26. "table": "`t1`",
  27. "index_provides_order": false,
  28. "order_direction": "undefined",
  29. "index": "unknown",
  30. "plan_changed": false
  31. }
  32. }
  33. }

clause_processing 用于简化 order by,经过 clause_processing access_type 变成 index_scan(全索引扫描,过滤性较 range 差),此时出现了和预期不符的结果。

因此可以推测优化器试图优化 order by 时出现了错误:

  • 第一阶段,优化器选择了索引 iabc,采用 range 访问;
  • 第二阶段,优化器试图进一步优化执行计划,使用 order by 的列访问,并清空了第一阶段的结果;
  • 第三阶段,优化器发现使用 order by 的列访问,代价比第一阶段的结果更大,但是第一阶段结果已经被清空了,无法还原,于是选择了代价较大的访问方式(index_scan),触发了 bug。

问题解决

  1. 我们在索引优化函数SQL_SELECT::test_quick_select 最开始的时候保存访问计划变量(quick);
  2. 在索引没变的时候,还原这个变量;
  3. 在索引发生改变的时候,删除这个变量。

在不修改 mysql 源码的情况下,可以通过 force index 强制指定索引规避这个 bug。

SQL_SELECT::test_quick_select 调用栈如下

  1. #0 SQL_SELECT::test_quick_select
  2. #1 make_join_select
  3. #2 JOIN::optimize
  4. #3 mysql_execute_select
  5. #4 mysql_select
  6. #5 mysql_explain_unit
  7. #6 explain_query_expression
  8. #7 execute_sqlcom_select
  9. #8 mysql_execute_command
  10. #9 mysql_parse
  11. #10 dispatch_command
  12. #11 do_command

分享:

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图11

推荐关注:

· 手慢无!云服务器免费领取,实时计算净省3258元 · 速抢!限时最高6000元开发者新年大礼包 · 每周二看直播,学最新阿里开源技术 · 错过再等一年!Flink Forward Asia 2020线上进行时

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

关系型数据库 MySQL 索引

评论

登录后可评论

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图12

jason姜
2017-10-16

学习了

Shape Created with Sketch. Combined Shape Created with Sketch.

取消评论

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图13

阿里云数据库

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图14 使用钉钉扫一扫加入圈子

+ 订阅

帮用户承担一切数据库风险,给您何止是安心!

官方博客

展开 MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图15

链接

推荐

[

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图16

](https://www.aliyun.com/database/dbfirstbuy)

[

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图17

](https://www.aliyun.com/database/dbfirstbuy)

[

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图18

](https://www.aliyun.com/database/dbfirstbuy)

售前咨询

95187转1

专业技术咨询

全方位产品解读

成熟解决方案

成功客户案例分享

支持与服务联系我们支持计划新手学堂帮助文档自助工具咨询与设计迁移与部署运维与管理优化与提升公告聆听·建议反馈服务案例专家分享上云能力中心CMC

账户管理管理控制台备案管理域名控制台账号管理云分期充值付款线下汇款/电汇合同申请索取发票合规性

快速入口域名信息查询(WHOIS)云产品快报海外上云客户案例举报中心信任中心产品图标产品学习路径阿里云认证贡献者榜单

资源和社区开发者社区开发者学院公开课问答藏经阁天池平台阿里云创新中心阿里云大学在线学习开放实验室考试认证高校合作码上公益

关注阿里云企业决策必读MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图19 阿里云APPMySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图20 阿里云微信MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图21 阿里云微博MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图22 阿里云支持与服务MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图23

热门产品

数据传输服务服务网格多媒体AI访问控制运维编排视频监控智能外呼弹性容器实例ECI配置审计

用户热搜

云数据库RDSVPN网关云安全访问服务表格存储智能语音交互堡垒机prometheus云呼叫中心数据洞察

企业场景

企业上云企业建站企业营销创新创业直播间企业专场销量榜企业邮箱企业安全飞天会员企业数据

更多推荐

全站加速风险识别DDoS防护专有云安全管家视频审核块存储短信服务移动安全加固

关于我们法律声明及隐私权政策廉正举报联系我们加入阿里云

阿里巴巴集团淘宝网天猫聚划算全球速卖通阿里巴巴国际交易市场1688阿里妈妈飞猪阿里云计算AliOS阿里通信万网高德UC友盟虾米优酷钉钉支付宝达摩院阿里安全

© 2009-2021 Aliyun.com 版权所有 增值电信业务经营许可证: 浙B2-20080101

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图24 MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图25 浙公网安备 33010602009975号

{“webchat”:[],”showStyle”:”首页”,”recommendText”:”留下您的联系方式,专属客户经理会高效快速帮您解决上云问题,同时可获得专属优惠”,”blackPage”:[],”advantages”:[{“content”:”售前咨询”},{“content”:”95187转1”},{“content”:”专业技术咨询”,”link”:”https://www.aliyun.com/support/95187"},{"content":"全方位产品解读","link":"https://www.aliyun.com/support/95187"},{"content":"成熟解决方案","link":"https://www.aliyun.com/solution/all"},{"content":"成功客户案例分享","link":"https://help.aliyun.com/learn/case-studies.html"}\],"mainServices":\[{"subTitle":\[{"serviceText":"联系我们","serviceLink":"https://www.aliyun.com/contact"},{"serviceText":"支持计划","serviceLink":"https://www.aliyun.com/support/supportplans"},{"serviceText":"新手学堂","serviceLink":"https://help.aliyun.com/learn/getting-started.html"},{"serviceText":"帮助文档","serviceLink":"https://help.aliyun.com/"},{"serviceText":"自助工具","serviceLink":"https://help.aliyun.com/learn/tool.html"},{"serviceText":"咨询与设计","serviceLink":"https://www.aliyun.com/service/list#f1"},{"serviceText":"迁移与部署","serviceLink":"https://www.aliyun.com/service/list#f2"},{"serviceLink":"https://www.aliyun.com/service/list#f3","serviceText":"运维与管理"},{"serviceText":"优化与提升","serviceLink":"https://www.aliyun.com/service/list#f4"},{"serviceText":"公告","serviceLink":"https://help.aliyun.com/noticelist.html"},{"serviceText":"聆听·建议反馈","serviceLink":"https://www.aliyun.com/connect/home"},{"serviceText":"服务案例","serviceLink":"https://www.aliyun.com/service/customer-case"},{"serviceText":"专家分享","serviceLink":"https://cloudshare.aliyun.com/"},{"serviceLink":"https://www.aliyun.com/cmc","serviceText":"上云能力中心CMC"}\],"title":"支持与服务"},{"title":"账户管理","subTitle":\[{"serviceText":"管理控制台","serviceLink":"https://homenew.console.aliyun.com/"},{"serviceText":"备案管理","serviceLink":"https://beian.aliyun.com/order/selfBaIndex.htm"},{"serviceText":"域名控制台","serviceLink":"https://dc.console.aliyun.com/next/index"},{"serviceText":"账号管理","serviceLink":"https://account.console.aliyun.com/"},{"serviceText":"云分期","serviceLink":"https://www.aliyun.com/yunfenqi/promotion"},{"serviceText":"充值付款","serviceLink":"https://usercenter2.aliyun.com/home"},{"serviceText":"线下汇款/电汇","serviceLink":"https://help.aliyun.com/knowledge\_detail/37108.html"},{"serviceText":"合同申请","serviceLink":"https://help.aliyun.com/knowledge\_detail/37079.html"},{"serviceText":"索取发票","serviceLink":"https://help.aliyun.com/knowledge\_detail/37053.html"},{"serviceText":"合规性","serviceLink":"https://security.aliyun.com/trust"}\]},{"title":"快速入口","subTitle":\[{"serviceText":"域名信息查询(WHOIS)","serviceLink":"https://whois.aliyun.com/"},{"serviceText":"云产品快报","serviceLink":"https://www.aliyun.com/product/new"},{"serviceText":"海外上云","serviceLink":"https://www.aliyun.com/chinaglobal/home"},{"serviceText":"客户案例","serviceLink":"https://help.aliyun.com/learn/case-studies.html"},{"serviceText":"举报中心","serviceLink":"https://report.aliyun.com/"},{"serviceText":"信任中心","serviceLink":"https://security.aliyun.com/trust"},{"serviceText":"产品图标","serviceLink":"https://help.aliyun.com/knowledge\_detail/67830.html"},{"serviceText":"产品学习路径","serviceLink":"https://help.aliyun.com/learn/learningpath"},{"serviceText":"阿里云认证","serviceLink":"https://edu.aliyun.com/certification"},{"serviceText":"贡献者榜单","serviceLink":"https://mvp.aliyun.com/"}\]},{"title":"资源和社区","subTitle":\[{"serviceText":"开发者社区","serviceLink":"https://developer.aliyun.com/"},{"serviceText":"开发者学院","serviceLink":"https://developer.aliyun.com/learning"},{"serviceText":"公开课","serviceLink":"https://developer.aliyun.com/live"},{"serviceText":"问答","serviceLink":"https://developer.aliyun.com/ask"},{"serviceText":"藏经阁","serviceLink":"https://developer.aliyun.com/ebook"},{"serviceText":"天池平台","serviceLink":"https://tianchi.aliyun.com/home"},{"serviceText":"阿里云创新中心","serviceLink":"https://chuangke.aliyun.com/"},{"serviceText":"阿里云大学","serviceLink":"https://edu.aliyun.com/"},{"serviceText":"在线学习","serviceLink":"https://edu.aliyun.com/developer"},{"serviceText":"开放实验室","serviceLink":"https://edu.aliyun.com/lab/"},{"serviceText":"考试认证","serviceLink":"https://edu.aliyun.com/certification"},{"serviceText":"高校合作","serviceLink":"https://edu.aliyun.com/campus"},{"serviceText":"码上公益","serviceLink":"https://greencode.aliyun.com/"}\]}\],"focusUs":{"title":"关注阿里云","tips":\[{"tipsName":"企业决策必读","tipsLink":"","codeImgSrc":"https://img.alicdn.com/tfs/TB1kxFBNgHqK1RjSZFkXXX.WFXa-176-176.png"},{"tipsName":"阿里云APP","tipsLink":"","codeImgSrc":"https://img.alicdn.com/tfs/TB1UdKEM6TpK1RjSZKPXXa3UpXa-256-256.png"},{"tipsName":"阿里云微信","tipsLink":"","codeImgSrc":"https://img.alicdn.com/tfs/TB1AOdINW6qK1RjSZFmXXX0PFXa-258-258.jpg"},{"tipsName":"阿里云微博","tipsLink":"","codeImgSrc":"https://img.alicdn.com/tfs/TB1DMXjNgDqK1RjSZSyXXaxEVXa-260-260.png"},{"tipsName":"阿里云支持与服务","codeImgSrc":"https://img.alicdn.com/tfs/TB1Ra0oNhTpK1RjSZR0XXbEwXXa-260-260.png"}\]},"products":\[{"productList":\[{"productName":"数据传输服务","productLink":"https://www.aliyun.com/product/dts"},{"productName":"服务网格","productLink":"https://www.aliyun.com/product/servicemesh"},{"productName":"多媒体AI","productLink":"https://www.aliyun.com/product/multimediaai"},{"productName":"访问控制","productLink":"https://www.aliyun.com/product/ram"},{"productName":"运维编排","productLink":"https://www.aliyun.com/product/oos"},{"productName":"视频监控","productLink":"https://www.aliyun.com/product/vs"},{"productName":"智能外呼","productLink":"https://www.aliyun.com/product/outboundbot"},{"productName":"弹性容器实例ECI","productLink":"https://www.aliyun.com/product/eci"},{"productName":"配置审计","productLink":"https://www.aliyun.com/product/config"}\],"title":"热门产品"},{"title":"用户热搜","productList":\[{"productName":"云数据库RDS","productLink":"https://www.aliyun.com/product/rds/sqlserver"},{"productName":"VPN网关","productLink":"https://www.aliyun.com/product/vpn"},{"productName":"云安全访问服务","productLink":"https://www.aliyun.com/product/security/csas"},{"productName":"表格存储","productLink":"https://www.aliyun.com/product/ots"},{"productName":"智能语音交互","productLink":"https://ai.aliyun.com/nls"},{"productName":"堡垒机","productLink":"https://www.aliyun.com/product/bastionhost"},{"productName":"prometheus","productLink":"https://www.aliyun.com/product/developerservices/prometheus"},{"productName":"云呼叫中心","productLink":"https://www.aliyun.com/product/ccc"},{"productName":"数据洞察","productLink":"https://www.aliyun.com/product/bigdata/spark"}\]},{"title":"企业场景","productList":\[{"productName":"企业上云","productLink":"https://www.aliyun.com/activity/daily/cloudpro"},{"productName":"企业建站","productLink":"https://www.aliyun.com/activity/daily/startup"},{"productName":"企业营销","productLink":"https://www.aliyun.com/activity/daily/marketing"},{"productName":"创新创业直播间","productLink":"https://chuangke.aliyun.com/live/"},{"productName":"企业专场销量榜","productLink":"https://www.aliyun.com/activity/qy/top"},{"productName":"企业邮箱","productLink":"https://wanwang.aliyun.com/mail"},{"productName":"企业安全","productLink":"https://www.aliyun.com/activity/daily/security"},{"productName":"飞天会员","productLink":"https://www.aliyun.com/feitianvip"},{"productName":"企业数据","productLink":"https://www.aliyun.com/activity/daily/data"}\]},{"title":"更多推荐","productList":\[{"productName":"全站加速","productLink":"https://www.aliyun.com/product/dcdn"},{"productName":"风险识别","productLink":"https://www.aliyun.com/product/saf"},{"productName":"DDoS防护","productLink":"https://www.aliyun.com/product/security/ddos"},{"productName":"专有云","productLink":"https://apsara-stack.aliyun.com/"},{"productName":"安全管家","productLink":"https://www.aliyun.com/product/sos"},{"productName":"视频审核","productLink":"https://ai.aliyun.com/vi/censor"},{"productName":"块存储","productLink":"https://www.aliyun.com/product/disk"},{"productName":"短信服务","productLink":"https://www.aliyun.com/product/sms"},{"productName":"移动安全加固","productLink":"https://www.aliyun.com/product/mobilepaas/mpaas\_ppm\_public\_cn"}\]}\],"copyright":{"copyrightText":"© 2009-2021 Aliyun.com 版权所有 增值电信业务经营许可证: 浙B2-20080101“,”aboutList”:[{“aboutName”:”关于我们”,”aboutLink”:”https://www.aliyun.com/about"},{"aboutName":"法律声明及隐私权政策","aboutLink":"http://terms.aliyun.com/legal-agreement/terms/suit\_bu1\_ali\_cloud/suit\_bu1\_ali\_cloud201902141711\_54837.html"},{"aboutName":"廉正举报","aboutLink":"https://jubao.alibaba.com/"},{"aboutName":"联系我们","aboutLink":"https://www.aliyun.com/contact"},{"aboutName":"加入阿里云","aboutLink":"https://www.aliyun.com/careers"}\],"friendList":\[{"friendName":"阿里巴巴集团","friendLink":"https://www.alibabagroup.com/cn/global/home"},{"friendName":"淘宝网","friendLink":"https://www.taobao.com/"},{"friendName":"天猫","friendLink":"https://www.tmall.com/"},{"friendName":"聚划算","friendLink":"https://ju.taobao.com/"},{"friendName":"全球速卖通","friendLink":"https://www.aliexpress.com/"},{"friendName":"阿里巴巴国际交易市场","friendLink":"https://www.alibaba.com/"},{"friendName":"1688","friendLink":"https://www.1688.com/"},{"friendName":"阿里妈妈","friendLink":"https://www.alimama.com/index.htm"},{"friendName":"飞猪","friendLink":"https://www.alimama.com/index.htm"},{"friendName":"阿里云计算","friendLink":"https://www.aliyun.com/"},{"friendName":"AliOS","friendLink":"https://www.alios.cn/"},{"friendName":"阿里通信","friendLink":"https://aliqin.tmall.com/"},{"friendName":"万网","friendLink":"https://wanwang.aliyun.com/"},{"friendName":"高德","friendLink":"https://mobile.amap.com/"},{"friendName":"UC","friendLink":"https://www.uc.cn/"},{"friendName":"友盟","friendLink":"https://www.umeng.com/"},{"friendName":"虾米","friendLink":"https://www.xiami.com/"},{"friendName":"优酷","friendLink":"https://www.youku.com/"},{"friendName":"钉钉","friendLink":"https://www.dingtalk.com/"},{"friendName":"支付宝","friendLink":"https://www.alipay.com/"},{"friendName":"达摩院","friendLink":"https://damo.alibaba.com/"},{"friendName":"阿里安全","friendLink":"https://s.alibaba.com/?scene=clinks"}\],"recordText":"浙公网安备 33010602009975号”,”reportList”:[{“reportLink”:”http://idinfo.zjamr.zj.gov.cn/bscx.do?method=lzxx&id=3301963301080000025024","logoSrc":"//gw.alicdn.com/tfs/TB1GxwdSXXXXXa.aXXXXXXXXXXX-65-70.gif"},{"logoSrc":"//img.alicdn.com/tfs/TB1..50QpXXXXX7XpXXXXXXXXXX-40-40.png","reportLink":"http://www.beian.gov.cn/portal/registerSystemInfo"}\]},"h5HotProduct":\[{"title":"云服务器","href":"https://www.aliyun.com/product/ecs/detailmb"},{"title":"域名注册","href":"https://m.aliyun.com/product/domain"},{"href":"https://m.aliyun.com/act/api","title":"1分钱API服务"},{"title":"云虚拟主机","href":"https://m.aliyun.com/product/hosting"}\],"showConsultation":"隐藏"} {“recommend”:{“visibleMode”:”default”},”anchor”:{“visibleMode”:”all”},”pc”:{“background”:””,”horizontal”:”默认”,”verticalNumber”:0,”marginTop”:”0”,”marginBottom”:”0”,”contentBackground”:””,”paddingHoz”:”0”,”paddingTop”:”0”,”paddingBottom”:”0”,”backgroundImage”:””,”autoHeight”:false},”h5”:{“background”:””,”horizontal”:”默认”,”verticalNumber”:0,”marginTop”:”0”,”marginBottom”:”0”,”contentBackground”:””,”paddingHoz”:”0”,”paddingTop”:”0”,”paddingBottom”:”0”,”backgroundImage”:””,”autoHeight”:false}}

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图26

购物车

0

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图27 购物车

| 添加更多产品

弹性计算

存储与CDN

视频服务

互联网中间件

云安全

数据库

网络

数据计算与分析

大数据应用与可视化

应用服务

云通信

总配置费用:

¥0.00

去购物车结算

MySQL · 捉虫动态 · order by limit 造成优化器选择索引错误-阿里云开发者社区 - 图28

购物车还是空的,快去买点云产品吧!

购买云服务器ECS | 云数据库RDS | CDN
或者返回首页

加入成功!

去结算 https://developer.aliyun.com/article/51065 ```