Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted January 2, 20214 yr 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!
January 2, 20214 yr Community Expert 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.
January 2, 20214 yr 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.
January 3, 20214 yr Author 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.
January 4, 20214 yr Are any tasks running at that time of day? Server backups, or system tasks within our software?
January 4, 20214 yr Author hi @bfarber it does not seem. However by running "mysql_upgrade" the problem is solved. At least for now.