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.

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

Matomo keep on fluctuating with in 2 weeks #16635

Closed
revathi-muthana123 opened this issue Oct 30, 2020 · 1 comment
Closed

Matomo keep on fluctuating with in 2 weeks #16635

revathi-muthana123 opened this issue Oct 30, 2020 · 1 comment
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@revathi-muthana123
Copy link

Hello, We have Matomo running with 3.12.0 version with MySQL DB in different server from AWS. But from Last 3 months for every 2 weeks RDS alerts reached high, RDS CPU reached 100 %, then we were not able to login even server also application went down.
When i try to restart server from console manually then it came up. But it keep on fluctuating. when i went through the logs, i saw errors relates to MySQL. Then i come to know that "max_allocated_package" has been changed. I have couple of questions on this.

  1. Where exactly we can add this value to reflect for application. Earlier we added in the RDS parameter group. But now that value is not fetching from that. To change /etc/my.conf we have not configured in this way.
  2. How we can finalize page views for all websites to decide on the server configurations. Based on which parameters we can decide either app server & DB.
    Errors: [php7:notice] [pid 4727] [client 172.16.86.0:54498] Error in Matomo (tracker): SQLSTATE[HY000] [2006] MySQL server has gone away,
    [php7:notice] [pid 4229] [client 172.16.64.33:19116] Error in Matomo: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away - in plugin Goals, referer:

image

image

Thanks & Regards
Revathi
@tsteur
Copy link
Member

tsteur commented Nov 1, 2020

Hi @revathi-muthana123 do you mind asking this question in our forum? https://forum.matomo.org/ We generally don't answer questions/support here. We also can't really give any specific support for AWS here unfortunately but maybe in the forum someone can help. You might then also maybe clarify what you mean here as I didn't quite understand what you were trying to achieve

How we can finalize page views for all websites to decide on the server configurations. Based on which parameters we can decide either app server & DB.

Thank you @revathi-muthana123

@tsteur tsteur closed this as completed Nov 1, 2020
@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Nov 1, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@tsteur @revathi-muthana123