Welcome toVigges Developer Community-Open, Learning,Share
Ask a Question
Welcome To Ask or Share your Answers For Others

Categories

mysql远程数据库如何提高查询效率？

0 votes
477 views
in Technique[技术] by (71.8m points)

mysql远程数据库如何提高查询效率？

执行了相同的47条sql查询语句，连接本地数据库执行时用时167毫秒，连接远程数据库执行用时2秒，正常吗？如何才能提高查询效率？

  • 远程数据库所在服务器带宽1M
  • 查询总数据量大概30k
  • 数据库服务器ping值正常，40~60ms
  • 数据库配置加入skip-name-resolve无效

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share

Just Browsing Browsing

2.1m questions

2.1m answers

63 comments

56.6k users

Most popular tags

Snow Theme by Q2A Market
Powered by Question2Answer
...