Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

日志数据量较大时数据库查询超时 #32

Open
J6666 opened this issue May 14, 2019 · 5 comments
Open

日志数据量较大时数据库查询超时 #32

J6666 opened this issue May 14, 2019 · 5 comments
Labels
enhancement New feature or request

Comments

@J6666
Copy link

J6666 commented May 14, 2019

日志数据量较大时首页打不开，数据库查询超，还需要优化
J6666 referenced this issue in J6666/LogDashboard May 14, 2019
@hayoudotnet
Fix#32
4d78f63
J6666 referenced this issue in J6666/LogDashboard May 14, 2019
@hayoudotnet
Fix#32 big data,sql time out.
5823b45
J6666 pushed a commit to J6666/LogDashboard that referenced this issue May 14, 2019
@hayoudotnet
realLiangshiwei#32 big data,sql time out.
ca46505
J6666 referenced this issue in J6666/LogDashboard May 14, 2019
@hayoudotnet
Fix#32,big log data,sql time out.
688bda9
@realLiangshiwei
Copy link
Owner

你好，可以提供数据量吗

@J6666
Copy link
Author

J6666 commented May 16, 2019

短短几天总日志 100多万条，大约每小时增加15000条。在这种情况统计不重复的数据会超时，首页直接挂掉了。建议去掉对不重复日志的统计。另外把统计图的数据全部放到异步取。

@realLiangshiwei
Copy link
Owner

OK，我会检查一下。对此做一些优化

@realLiangshiwei
Copy link
Owner

#27 不过我之前做过测试，一百多万不至于这么慢

@realLiangshiwei realLiangshiwei added the enhancement New feature or request label Jul 30, 2019
@realLiangshiwei
Copy link
Owner

3.0会重新设计

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@realLiangshiwei @J6666