we have froxlor since 2016 (current version 0.10.9, debian buster, mysql 8.x) and we log every minute the traffic. The table panel_traffic is very huge. So if you sign in as admin and open the customers the response is round about 2-4 minutes. We check with top and mysql consume everything of cpu power that is available (8 cores). Does any one else have same problems?
Login as admin and look on traffic, takes also long time. clicking on details ends in exception:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC, `month` DESC LIMIT 12' at line 4
Login as customer and click on traffic:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC, `month` DESC LIMIT 12' at line 4
Question
MeinerEiner
Hello,
we have froxlor since 2016 (current version 0.10.9, debian buster, mysql 8.x) and we log every minute the traffic. The table panel_traffic is very huge. So if you sign in as admin and open the customers the response is round about 2-4 minutes. We check with top and mysql consume everything of cpu power that is available (8 cores). Does any one else have same problems?
Query result 1 Page to last Page
Showing rows 8392875 - 8392897 (8392898 total, Query took 21.7778 seconds.)
Login as admin and look on traffic, takes also long time. clicking on details ends in exception:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC, `month` DESC LIMIT 12' at line 4
Login as customer and click on traffic:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC, `month` DESC LIMIT 12' at line 4
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now