sofos Posted January 2, 2021 Share Posted January 2, 2021 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! Link to comment Share on other sites More sharing options...
Miss_B Posted January 2, 2021 Share Posted January 2, 2021 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. sofos 1 Link to comment Share on other sites More sharing options...
CoffeeCake Posted January 2, 2021 Share Posted January 2, 2021 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 1 Link to comment Share on other sites More sharing options...
sofos Posted January 3, 2021 Author Share Posted January 3, 2021 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. Link to comment Share on other sites More sharing options...
bfarber Posted January 4, 2021 Share Posted January 4, 2021 Are any tasks running at that time of day? Server backups, or system tasks within our software? Link to comment Share on other sites More sharing options...
sofos Posted January 4, 2021 Author Share Posted January 4, 2021 hi @bfarber it does not seem. However by running "mysql_upgrade" the problem is solved. At least for now. Link to comment Share on other sites More sharing options...
Recommended Posts