Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Ask a Question
Welcome To Ask or Share your Answers For Others

Categories

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

0 votes
514 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 OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

Just Browsing Browsing

2.1m questions

2.1m answers

60 comments

57.0k users

Most popular tags

Powered by Question2Answer
Donate
Theme by Q2A Market&&OStack.cn
...