Jump to content
Froxlor Forum
  • 0
MeinerEiner

Exceptions while accessing traffic, huge panel_traffic tables has to ui performance

Question

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

 

 

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Traffic cron is meant to run once a day...it does not make sense to run it more often without patching as you will have duplicate and therefore totally wrong traffic data.

Still, it should not result in a SQL syntax error. Please open an issue on GitHub so I can dig into that

Share this post


Link to post
Share on other sites
  • 0

Hello,

 

thanks, so I reset the crojob settings to default for traffic and diskspace. Also delete all data for traffic and diskspace with reset autoincrement to 1. Now it feels like smoother and quicker. Do you calculate the stats while opening the customers live?

DELETE FROM `panel_traffic`;
ALTER TABLE `panel_traffic` AUTO_INCREMENT = 1;

DELETE FROM `panel_traffic_admins`;
ALTER TABLE `panel_diskspace` AUTO_INCREMENT = 1;
 
DELETE FROM `panel_diskspace`;
ALTER TABLE `panel_diskspace` AUTO_INCREMENT = 1;

DELETE FROM `panel_diskspace`;
ALTER TABLE `panel_diskspace_admins` AUTO_INCREMENT = 1;

 

Click on traffic detail still ends in a exception. So I will open an issue at git for your. Once o rethink about traffic and diskspace calculations (collect multiple times, for example 1 Minute and it is gruped per day) and once for the exception on traffic details.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...