对 sym 系统压测,10 个并发下, 页面需要 3 秒以上才能打开

本贴最后更新于 2274 天前,其中的信息可能已经时移世异

1,对 sym 压测,10 并发后台日志:

[INFO ]-[2018-01-06 02:23:39]-[org.b3log.symphony.SymphonyServletListener:258]: Stopwatch: 
[100]%, [7429]ms [Request initialized [/article/1515141092284]]
  [0]%, [0]ms [Resolve skin]
  [77.25]%, [5739]ms [Request URI [/article/1515141092284]]
    [0.1615]%, [12]ms [Get article by id]
      [0.04038]%, [3]ms [Meta Desc]
    [0.06730]%, [5]ms [Fills header]
      [0]%, [0]ms [Fills personal nav]
      [0]%, [0]ms [Fills lang]
      [0]%, [0]ms [Fills domain nav]
    [0]%, [0]ms [Fills footer]
    [0.04038]%, [3]ms [Revision count]
    [0]%, [0]ms [Process content]
      [0]%, [0]ms [Link article]
      [0]%, [0]ms [Link tag]
      [0]%, [0]ms [ToC]
    [39.33]%, [2922]ms [Fills relevant articles]
      [0.5115]%, [38]ms [Organize articles]
    [27.15]%, [2017]ms [Fills random articles]
      [3.823]%, [284]ms [Organize articles]
        [0.2019]%, [15]ms [Meta Desc]
          [0.1615]%, [12]ms [Md to HTML]
    [7.053]%, [524]ms [Fills hot articles]
      [0.5923]%, [44]ms [Organize articles]
    [0.06730]%, [5]ms [Fills article thank]
    [0.05384]%, [4]ms [Get previous]
    [0.04038]%, [3]ms [Get next]
    [0.04038]%, [3]ms [Gets nice comments]
      [0]%, [0]ms [Organizes comments]
    [0.1077]%, [8]ms [Get comments]
      [0.02692]%, [2]ms [Query comments]
      [0.02692]%, [2]ms [Organizes comments]
        [0.01346]%, [1]ms [Organize comment]
          [0]%, [0]ms [Link article]
          [0]%, [0]ms [Link tag]
        [0.01346]%, [1]ms [Organize comment]
          [0]%, [0]ms [Link article]
          [0]%, [0]ms [Link tag]
      [0.05384]%, [4]ms [Revision, paging, original]
        [0.02692]%, [2]ms [Revision count]
        [0.02692]%, [2]ms [Revision count]
    [0.06730]%, [5]ms [Fills comment thank]
    [3.042]%, [226]ms [Grant permissions]

2, mysql 慢查询日志:

Time: 2018-01-05T18:17:09.508669Z

User@Host: root[root] @ [39.106.78.43] Id: 35

Query_time: 5.560814 Lock_time: 0.000081 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515176229;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.21450857517680555 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:23:18.729260Z

User@Host: root[root] @ [39.106.78.43] Id: 65

Query_time: 5.237147 Lock_time: 0.000052 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515176598;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.12630730197992168 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:23:46.333046Z

User@Host: root[root] @ [39.106.78.43] Id: 70

Query_time: 4.794911 Lock_time: 0.000057 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515176626;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.20396525536362364 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:26:43.887586Z

User@Host: root[root] @ [39.106.78.43] Id: 65

Query_time: 3.347473 Lock_time: 0.000084 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515176803;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.061069666775466436 and articleStatus=0) limit 0,10;

相关帖子

欢迎来到这里!

我们正在构建一个小众社区,大家在这里相互信任,以平等 • 自由 • 奔放的价值观进行分享交流。最终,希望大家能够找到与自己志同道合的伙伴,共同成长。

注册 关于
请输入回帖内容 ...