blocks|key|788804|text|您能否验证DNS配置正确且响应速度快？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|788805|在对用户进行身份验证时，MySQL需要执行反向DNS查找，以将客户端IP地址解析为主机名并在其mysql.user数据库中匹配。|788806|要检查这一点，您可以尝试类似于mysql服务器的dig+-x+<client_ip_address>+(如果在Windows上运行nslookup+<client_ip_address>+)。|offset|length|style|CODE|788807|如果这个请求没有足够快的响应，就会有很多解决方案(我现在不能把它们全部写下来)。|entityMap^0|0|0|O|Q|1T|S|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@$F|P|G|Q|H|I]|$F|R|G|S|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|T|8|@]|9|@]|A|$]]]|L|$]]

Can you verify that your DNS is configured correctly and responding fast?

When authenticating a user, MySQL needs to do a reverse DNS lookup to resolve the client IP address to a host name and match it in its mysql.user database.

To check this, you can try something like <code>dig -x &lt;client_ip_address&gt;</code> from your mysql server (or <code>nslookup &lt;client_ip_address&gt;</code> if you run it on Windows).

If that request doesn't respond fast enough, there are plenty of solutions (I can't afford to write all them down right now).

blocks|key|788701|text|一些想法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|788702|可以签入MySQL的慢速查询日志。|unordered-list-item|788703|您是否尝试过在同一个web服务器上使用数据库运行应用程序？|788704|您可以使用iftop检查两个服务器之间的通信量，以确定网络是否是瓶颈。|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|K|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|M|8|@]|9|@]|A|$]]]|I|$]]

Some ideas:

<ul>
<li>You can check in the slow query log of MySQL</li>
<li>Have you tried to run the application with the database in the same web server?</li>
<li>You can check the traffic between the two servers with iftop to see if the network is the bottleneck.</li>
</ul>

blocks|key|4528465|text|脑海中闪现的一个猜测是，也许查询是被缓冲到一个结果中，而不是按找到的方式发送数据？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

A guess that pops to mind is that perhaps the query is being buffered into one result rather than sending data as it's found?

blocks|key|4528485|text|你的应用程序是用什么语言开发的？我知道你说过它与编码无关，但是你能在里面放一些断点或调试点来找出它在哪里延迟吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4528486|我在一种不支持远程调试的语言中做过类似的事情。在每个主要函数之前和之后，我将时间(毫秒)写入日志文件，然后当它完成时，检查日志，找到时间戳中的空白，深入研究该函数，做类似的事情，最终发现延迟是在调用身份验证服务时造成的。|4528487|如果遇到所有时间戳都有可接受限制的情况，那么延迟很可能发生在web服务器守护进程/服务中。它可能是配置错误的Apache，也可能是IIS中的坏筛选器，任何事情.|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|H|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|I|8|@]|9|@]|A|$]]]|F|$]]

What language is your application developed in? I realise you've said it's not coding related, but can you put some breakpoints or debug points in to find out where it is stalling?

I've done similar things in a language that didn't support remote debugging. Before and after every major function I wrote the time (to the millisecond) into a log file, then when it had finished, checked the log, found the gap in the timestamps, delved into that function, did a similar thing, and eventually found that the delay was caused when calling an authentication service.

If you run into the scenario where all your timestamps are with acceptible limits, then the delay is most likely happening at the web server daemon/service. It could be a misconfigured Apache, or a bad filter in IIS, any number of things...

blocks|key|4528535|text|不可忽视的是物理网络基础设施。我以前也见过类似的问题，后来被追踪到了一条糟糕的网络电缆。查询运行得足够快，但通过该电缆的网络吞吐量却慢得令人难以置信。换了电缆，一切都很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

Something that should not be overlooked is the physical network infrastructure. I've seen similar problems before that were eventually traced to a bad network cable. Queries ran fast enough but the network throughput over that cable was unbelievably slow. Replaced the cable and all was well.

I have a web application running on an internal network for a client of ours. This question slightly overlaps my other active question about <a href="https://serverfault.com/questions/52529/tuning-a-remote-mysql-server">tuning a remote MySQL install</a>. The issue is speed, the app is painfully slow. The app runs beautifully in another environment, so I have ruled out coding.

<ul>
<li>Refreshing a particular page will take minutes (literally) to load. </li>
<li>The MySQL server is on a separate box, but its a single 4ms hop from the web server.</li>
<li>Its not a slow query, checking the processlist when waiting for the page to load shows no hung queries at all.</li>
</ul>

What is the next step? Could MySQL still be the problem? Maybe it is retrieving quickly but not returning the data fast enough? Where else can I look?

Thanks very much for any assistance.

Web Application speed Issues

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我有一个web应用程序运行在一个内部网络为我们的客户。这个问题与我关于优化远程MySQL安装的另一个主动问题略有重叠。问题是速度，这款应用程序速度慢得令人痛苦。这个应用程序在另一个环境中运行得很好，所以我已经排除了编码。刷新一个特定的页面需要几分钟(字面上)才能加载。MySQL服务器位于一个单独的盒子上，但它从web服务器上跳到了一个4ms。这不是一个缓慢的查询，在等待页面加载时检查处理列表显示根

问Web应用程序速度问题
EN

回答 5

Server Fault用户

Server Fault用户

Server Fault用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Web应用程序速度问题EN

回答 5

Server Fault用户

Server Fault用户

Server Fault用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Web应用程序速度问题
EN