访问速度贼慢.... 使用 IP 和域名都慢

teavmac

www.teavamc.com
访问速度贼慢....主要是 waiting ttfb 和 Content download 是服务器的原因吗?

teavmac

[arthas@14676]$ trace run.halo.app.controller.content.ContentContentController content Press Q or Ctrl+C to abort. Affect(class count: 2 , method count: 12) cost in 359 ms, listenerId: 6---ts=2020-09-05 17:13:57;thread_name=XNIO-4 task-14;id=18be;is_daemon=false;priority=5;TCCL=org.springframework.boot.loader.LaunchedURLClassLoader@31cefde0
---[6675.647773ms] run.halo.app.controller.content.ContentContentController$$EnhancerBySpringCGLIB$$bbb1016f:content()---[6675.255155ms] org.springframework.cglib.proxy.MethodInterceptor:intercept()
---[6672.853072ms] run.halo.app.controller.content.ContentContentController:content() +---[0.1076ms] run.halo.app.service.OptionService:getArchivesPrefix() #84---[6672.557352ms] run.halo.app.controller.content.model.PostModel:archives() #85

[arthas@14676]$ trace run.halo.app.controller.content.ContentIndexController index
Press Q or Ctrl+C to abort.
Affect(class count: 2 , method count: 4) cost in 278 ms, listenerId: 7
---ts=2020-09-05 17:15:21;thread_name=XNIO-4 task-4;id=18b4;is_daemon=false;priority=5;TCCL=org.springframework.boot.loader.LaunchedURLClassLoader@31cefde0---[1980.75808ms] run.halo.app.controller.content.ContentIndexController$$EnhancerBySpringCGLIB$$c7cebf4d:index()
---[1980.668359ms] org.springframework.cglib.proxy.MethodInterceptor:intercept()---[1980.242113ms] run.halo.app.controller.content.ContentIndexController:index()
+---[0.137685ms] run.halo.app.service.OptionService:getPostPermalinkType() #53
+---[0.013593ms] run.halo.app.model.enums.PostPermalinkType:equals() #55
---[1980.006353ms] run.halo.app.controller.content.ContentIndexController:index() #60---[1979.970498ms] run.halo.app.controller.content.ContentIndexController:index()
---[1979.89844ms] run.halo.app.controller.content.model.PostModel:list() #73

Ryan Wang 🚀

teavmac 试试最新beta。

teavmac

arthas 工具trace 到了卡在 org.springframework.cglib.proxy.MethodInterceptor:intercept() 方法占用了大量耗时, 工作时间抽空看的

teavmac

teavmac 跟进, run.halo.app.controller.content.model.PostModel 内的 list 和 archives 慢

teavmac

Ryan Wang 🚀 最新的 beta 版本吗? 还是直接更换jar吗

Ryan Wang 🚀

teavmac 嗯，另外，你是使用的 MySQL 吗？

teavmac

Ryan Wang 🚀 是的 aliyun rds

Ryan Wang 🚀

teavmac 内网连接还是外网。

teavmac

Ryan Wang 🚀 公网

Ryan Wang 🚀

teavmac 那连接和查询慢应该很正常哦。

teavmac

Ryan Wang 🚀 可是都是 5秒以上哇...

teavmac

Ryan Wang 🚀 我试试内网稍等

Ryan Wang 🚀

teavmac 我也不清楚怎么回事，反正遇到查询慢的全是使用的 MySQL，目前还没有检查出来问题。而且也不是所有使用 MySQL 的都慢。

teavmac

Ryan Wang 🚀 哈阿里云的 ESC 和 RDS 不在同一个地域不能只用内网我再看看吧

teavmac

Ryan Wang 🚀 无解....折腾了一下没结果..我试下BETA 版本吧

teavmac

2020-09-05 17:54:33.244 DEBUG 25837 --- [XNIO-1 task-13] run.halo.app.filter.LogFilter : Starting url: [http://www.teavamc.com/archives], method: [GET], ip: [124.160.65.50] 2020-09-05 17:54:33.244 DEBUG 25837 --- [XNIO-1 task-13] r.h.a.s.f.AbstractAuthenticationFilter : Got access key from parameter: [ott: null] 2020-09-05 17:54:33.245 DEBUG 25837 --- [XNIO-1 task-13] r.h.a.c.HaloRequestMappingHandlerMapping : Looking path: [/archives] 2020-09-05 17:54:33.246 DEBUG 25837 --- [XNIO-1 task-13] r.h.a.c.HaloRequestMappingHandlerMapping : Mapped to run.halo.app.controller.content.ContentContentController#content(String, Model) 2020-09-05 17:54:33.249 DEBUG 25837 --- [XNIO-1 task-13] run.halo.app.core.ControllerLogAop : Request URL: [http://www.teavamc.com/archives], URI: [/archives], Request Method: [GET], IP: [124.160.65.50] 2020-09-05 17:54:33.249 DEBUG 25837 --- [XNIO-1 task-13] run.halo.app.core.ControllerLogAop : ContentContentController.content Parameters: [["archives",{}]] 2020-09-05 17:54:33.250 DEBUG 25837 --- [XNIO-1 task-13] run.halo.app.core.ControllerLogAop : Request URL: [http://www.teavamc.com/archives], URI: [/archives], Request Method: [GET], IP: [124.160.65.50] 2020-09-05 17:54:33.251 DEBUG 25837 --- [XNIO-1 task-13] run.halo.app.core.ControllerLogAop : PostModel.archives Parameters: [[1,{}]] 2020-09-05 17:54:39.915 DEBUG 25837 --- [XNIO-1 task-13] run.halo.app.core.ControllerLogAop : PostModel.archives Response: ["themes/ghost_casper/archives"], usage: [6664]ms 2020-09-05 17:54:39.915 DEBUG 25837 --- [XNIO-1 task-13] run.halo.app.core.ControllerLogAop : ContentContentController.content Response: ["themes/ghost_casper/archives"], usage: [6666]ms 2020-09-05 17:54:49.934 DEBUG 25837 --- [XNIO-1 task-13] run.halo.app.filter.LogFilter : Ending url: [http://www.teavamc.com/archives], method: [GET], ip: [124.160.65.50], status: [200], usage: [16690] ms

teavmac

16690ms .....

teavmac

想了个办法, 改天抽空自己拉一个分支,加个日志打jar发上去看日志