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.
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
Performance, 10k Visitors and 100% CPU #2683
Comments
Attachment: Server-Performance |
Attachment: Task Manager |
It looks like your CPU goes 100% during the archiving and is then nearly idle (tracking only). I agree that with 11cores and so much RAM, it should behave a lot better. How many pages do you track per day? How many rows in piwik_log_action (can you take screenshot of phpmyadmin overview of your tables with sizes + row count)? Finally, a "quick fix" solution is to set timeout to 100000 so that you effectively disable "real time" reporting for "today" and only access yesterday and before. Today will be archived in the first archiving run of the day in your website's timezone. |
How many pages do you track per day? |
Attachment: Phpmyadmin |
how many pages views do you track ?
|
how many pages views do you track ? |
Attachment: Page Views |
Attachment: |
Attachment: |
Is piwik able to handle 10 000 visitis in 12h ? Note: Why is the ticket closed? The issue is still there ... |
Piwik should handle tracking without problem, the problem is that you process "today" report and "current week" current month current year EVERY hour. This is too much. There is a new archiving script in development that will make things better but in the meantime, put archive timeout to 10000 par exemple (every 3 hours) and it will be better. Also please enable mysql slow query log to see if there any abnormal slow query. EDIT: see: https://piwik.org/docs/setup-auto-archiving/ |
Hello
My server (Windows 20088 R2;Fast-CGI;mysql) is using 100% of my CPU between 8h - 18 h. I already have installed the cronjob and increased the memory-limit to 1512MB but no change.
Can somebody help me to improve the performance ?
Note: Server has 11 cores and 8-12Gb RAM
The text was updated successfully, but these errors were encountered: