The server becomes slow (or unreachable) in the evening hour

[sofos]

hi everyone, for a few months happens that the server becomes slow (or unreachable) in the evening hours. I can't understand the reason, what would you go to check?

Thanks and happy new year to all of you!

[Miss_B]

Do you have your own VPS/Dedicated Box or are you on a shared hosting plan? If the latter, you will have to ask your host about it.

[CoffeeCake]

In either case, create a support request in the client area. If you are a Community in the Cloud customer, then IPS will get you sorted. Otherwise, you may need to work with your hosting provider to determine how to allocate more resources during peak usage times.

[sofos]

So, I did a server analysis and the first two things I noticed are:
- there are over 500 concurrent connections to the web server
- mysql uses a lot of CPU quota and over half of the available RAM
 
The Apache web server seems to handle the load well.
MySQL is instead in enormous suffering: the log file is huge (over 16G) and reports a series of warnings on a series of tables as if they were corrupt, so much so that it is suggested to run the "mysql_upgrade" command.
Obviously I didn't run it not knowing the system well.

[bfarber]

Are any tasks running at that time of day? Server backups, or system tasks within our software?

[sofos]

hi @bfarber it does not seem. However by running "mysql_upgrade" the problem is solved. At least for now.