mysql性能云服务器 ECS 的相关内容

问答 2024-04-24 来自：开发者社区

mysql性能很慢，但是数据库服务器的资源很空闲20%以下的利用率，这个可能是什么配置问题？

1、mysql整体的执行速度很慢，不是特定语句，是所有语句都慢，有些简单的insert语句执行就是10好几秒。表格本身数据量不大，几百万行，插入一行5个数字 2、硬件资源CPU、内存等的利用率都在20%以下。 3、从目前的特征来看，感觉是哪里的配置有问题请大神指点，谢谢！

共有7条

< 1 >

跳转至： GO

更新时间 2024-06-22 11:36:40

本页面内关键词为智能算法引擎基于机器学习所生成，如有任何问题，可在页面下方点击"联系我们"与我们沟通。

云服务器 ECS更多mysql相关

云服务器 ECS您可能感兴趣

产品推荐

{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":6,"count":6}]},"card":[{"des":"云服务器 ECS（Elastic Compute Service）是一种弹性可伸缩的计算服务，助您降低 IT 成本，提升运维效率，使您更专注于核心业务创新。","link1":"https://ecs-buy.aliyun.com/wizard#/prepay/cn-hangzhou","link":"https://www.aliyun.com/product/ecs","icon":"https://img.alicdn.com/tfs/TB1afahQpXXXXaAapXXXXXXXXXX-114-114.png","btn2":"了解价格","tip":"ECS精选产品特惠低至0.55折，<a href=\"https://www.aliyun.com/daily-act/ecs/activity_selection\" target=\"_blank\">立即查看</a>     高配云服务器免费试用，<a href=\"https://www.aliyun.com/daily-act/ecs/free\" target=\"_blank\">立即查看</a>","btn1":"立即开通","link2":"https://www.aliyun.com/price/product?spm=5176.8789780.1092586.1.2e8e57a8lGNDpl#/ecs/detail","title":"云服务器 ECS"}],"search":[{"txt":"云服务器精选特惠，低至0.45折","link":"https://www.aliyun.com/daily-act/ecs/activity_selection"},{"txt":"GPU算力开启AI时代","link":"https://www.aliyun.com/daily-act/ecs/s6_sales"},{"txt":"ECS免费试用最高12个月","link":"https://www.aliyun.com/daily-act/ecs/free"},{"txt":"ECS云服务器学习路径","link":"https://help.aliyun.com/learn/learningpath/ecs.html"},{"txt":"ECS云服务器入门","link":"https://help.aliyun.com/document_detail/25422.html"},{"txt":"ECS云服务器选型推荐","link":"https://help.aliyun.com/document_detail/58291.html"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"simplifiedDisplay":"newEdition","newCard":[{"link":"https://www.aliyun.com/product/ecs","icon":"ecs","title":"云服务器ECS","des":"云服务器 ECS（Elastic Compute Service）是一种弹性可伸缩的计算服务，助您降低 IT 成本，提升运维效率，使您更专注于核心业务创新。","btn1":"产品详情页","btn2":"ECS控制台","btn3":"新用户免费试用","link3":"https://free.aliyun.com/?goodsId=10000011871,10000011876","link1":"https://www.aliyun.com/product/ecs","link2":"https://ecs.console.aliyun.com/#/home","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"99计划延1年，优惠续享","firstContentLink":"https://www.aliyun.com/daily-act/ecs/99program","lastContentName":"","lastContentLink":""}},{"infoName":"产品入门","infoContent":{"firstContentName":"ECS选型推荐","firstContentLink":"https://help.aliyun.com/document_detail/58291.html","lastContentName":"ECS学习路径","lastContentLink":"https://help.aliyun.com/learn/learningpath/ecs.html"}},{"infoName":"热门产品","infoContent":{"firstContentName":"低价e实例，新老同享","firstContentLink":"https://www.aliyun.com/daily-act/ecs/activity_selection?spm=5176.28478213.J_4267641240.1.708832b4zorJSg","lastContentLink":"https://www.aliyun.com/daily-act/ecs/ecs-intel-9th","lastContentName":"第九代企业级产品"}},{"infoName":"最佳实践","infoContent":{"firstContentLink":"https://www.aliyun.com/benefit/scene/ainew","firstContentName":"助力AI，GPU算力1折起 ","lastContentLink":"https://help.aliyun.com/zh/ecs/user-guide/migrate-servers","lastContentName":"服务器迁移指引"}}],"contentLink":"https://www.aliyun.com/product/ecs"}]}

{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":6,"count":6}]},"card":[{"des":"云服务器 ECS（Elastic Compute Service）是一种弹性可伸缩的计算服务，助您降低 IT 成本，提升运维效率，使您更专注于核心业务创新。","link1":"https://ecs-buy.aliyun.com/wizard#/prepay/cn-hangzhou","link":"https://www.aliyun.com/product/ecs","icon":"https://img.alicdn.com/tfs/TB1afahQpXXXXaAapXXXXXXXXXX-114-114.png","btn2":"了解价格","tip":"ECS精选产品特惠低至0.55折，<a href=\"https://www.aliyun.com/daily-act/ecs/activity_selection\" target=\"_blank\">立即查看</a>     高配云服务器免费试用，<a href=\"https://www.aliyun.com/daily-act/ecs/free\" target=\"_blank\">立即查看</a>","btn1":"立即开通","link2":"https://www.aliyun.com/price/product?spm=5176.8789780.1092586.1.2e8e57a8lGNDpl#/ecs/detail","title":"云服务器 ECS"}],"search":[{"txt":"云服务器精选特惠，低至0.45折","link":"https://www.aliyun.com/daily-act/ecs/activity_selection"},{"txt":"GPU算力开启AI时代","link":"https://www.aliyun.com/daily-act/ecs/s6_sales"},{"txt":"ECS免费试用最高12个月","link":"https://www.aliyun.com/daily-act/ecs/free"},{"txt":"ECS云服务器学习路径","link":"https://help.aliyun.com/learn/learningpath/ecs.html"},{"txt":"ECS云服务器入门","link":"https://help.aliyun.com/document_detail/25422.html"},{"txt":"ECS云服务器选型推荐","link":"https://help.aliyun.com/document_detail/58291.html"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"simplifiedDisplay":"newEdition","newCard":[{"link":"https://www.aliyun.com/product/ecs","icon":"ecs","title":"云服务器ECS","des":"云服务器 ECS（Elastic Compute Service）是一种弹性可伸缩的计算服务，助您降低 IT 成本，提升运维效率，使您更专注于核心业务创新。","btn1":"产品详情页","btn2":"ECS控制台","btn3":"新用户免费试用","link3":"https://free.aliyun.com/?goodsId=10000011871,10000011876","link1":"https://www.aliyun.com/product/ecs","link2":"https://ecs.console.aliyun.com/#/home","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"99计划延1年，优惠续享","firstContentLink":"https://www.aliyun.com/daily-act/ecs/99program","lastContentName":"","lastContentLink":""}},{"infoName":"产品入门","infoContent":{"firstContentName":"ECS选型推荐","firstContentLink":"https://help.aliyun.com/document_detail/58291.html","lastContentName":"ECS学习路径","lastContentLink":"https://help.aliyun.com/learn/learningpath/ecs.html"}},{"infoName":"热门产品","infoContent":{"firstContentName":"低价e实例，新老同享","firstContentLink":"https://www.aliyun.com/daily-act/ecs/activity_selection?spm=5176.28478213.J_4267641240.1.708832b4zorJSg","lastContentLink":"https://www.aliyun.com/daily-act/ecs/ecs-intel-9th","lastContentName":"第九代企业级产品"}},{"infoName":"最佳实践","infoContent":{"firstContentLink":"https://www.aliyun.com/benefit/scene/ainew","firstContentName":"助力AI，GPU算力1折起 ","lastContentLink":"https://help.aliyun.com/zh/ecs/user-guide/migrate-servers","lastContentName":"服务器迁移指引"}}],"contentLink":"https://www.aliyun.com/product/ecs"}]}}

云服务器ECS

云服务器 ECS（Elastic Compute Service）是一种弹性可伸缩的计算服务，助您降低 IT 成本，提升运维效率，使您更专注于核心业务创新。

产品详情页

ECS控制台

新用户免费试用