Announcement

Collapse
No announcement yet.

Server load shoots up on sundays!!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • George L
    replied
    Originally posted by M1th
    Sorry, the http://www.cosforums.com/info.php should be up now. So, besides the php/mysql/apache upgrade what would you recommend?

    Thanks


    sorry for creating this thread btw.
    the apache/mysql/php upgrades to latest stable versions would eliminate them as being the possible culprit to your server load issue due to bugs in older versions..

    then we can work from there as to seeing what the problem is .. systematic troubleshooting

    Leave a comment:


  • M1th
    replied
    Originally posted by eva2000
    you should keep the with the same thread at http://www.vbulletin.com/forum/showthread.php?t=91317 rather than posting again as all it does is slow down the response time for us

    from your top stats the load is going up due to using up all ram and swapping to disk ALOT by as much as 300+ MB swap!

    seems you url at http://www.cosforums.com/info.php is also missing now what's the valid link to your phpinfo url and mysqlinfo urls ?

    it could be that weekends your cpu is under powered to handle the load

    also upgrade to mysql 4.0.18, upgrade PHP to 4.3.4 and apache to 1.3.29 if you haven't already

    Sorry, the http://www.cosforums.com/info.php should be up now. So, besides the php/mysql/apache upgrade what would you recommend?

    Thanks


    sorry for creating this thread btw.
    Last edited by M1th; Wed 24 Mar '04, 9:30am.

    Leave a comment:


  • George L
    replied
    Originally posted by M1th
    Greetings,

    I've been having this problem since last month. The server load averages increase upto 40/30 every sunday afternoon. Therefore, accessing the site to the site is nearly impossible. I have to stop apache for a couple of minutes so the server loads can go back to their original state (below 1).

    I did a top on my server and found that the mysql process is what is causing this but I havent been able to figure out why. Any help or advice would be much appreciated.

    Regards,
    M1th
    you should keep the with the same thread at http://www.vbulletin.com/forum/showthread.php?t=91317 rather than posting again as all it does is slow down the response time for us

    from your top stats the load is going up due to using up all ram and swapping to disk ALOT by as much as 300+ MB swap!

    seems you url at http://www.cosforums.com/info.php is also missing now what's the valid link to your phpinfo url and mysqlinfo urls ?

    it could be that weekends your cpu is under powered to handle the load

    also upgrade to mysql 4.0.18, upgrade PHP to 4.3.4 and apache to 1.3.29 if you haven't already

    Leave a comment:


  • Steve Machol
    replied
    Not sure why you are bumping this. There is nothing in vB that would cause server load increases on a regular basis every Sunday. This is a server issue and needs to be resolved at that level.

    Leave a comment:


  • M1th
    replied
    er.. *bump* :|

    Leave a comment:


  • M1th
    replied
    Originally posted by Steve Machol
    Does your host have a regularly schedule backup script running?

    Nope, we do the backups ourselves.

    Leave a comment:


  • Lierduh
    replied
    I have a problem which might be related. Everytime I do a mysqldump, the MySQL server will have very high load after that (can be as high as 5.00 when busy and perhaps .5 when not busy). The only way I could bring it back to normal is to restart the MySQL server. I never had this problem before until recenly when I upgraded the hardware as well as now the MySQL is at version 4.018. The new hardware is more powerful than the old server. It is a dual Athlon MP with 2GB of RAM. I suspect it might be something to do with innodb, unfortunately I need innodb for another database.

    I am doing the back up dump now at the replicate Slave server, which has not given me any problem. The back up script stops Slave before the dump and starts the slave afterwards. First I thought it might be my my.cnf's memory related settings. I have since tried many different settings. I will have to study more into MySQL before trying other settings, it is a live server.

    Leave a comment:


  • Steve Machol
    replied
    Does your host have a regularly schedule backup script running?

    Leave a comment:


  • M1th
    replied
    Originally posted by Steve Machol
    Do you have any other users with root privileges? I would suspect a cron job if this happens at the same time on a regular basis.

    Nope, not that I know of.

    Leave a comment:


  • Steve Machol
    replied
    Do you have any other users with root privileges? I would suspect a cron job if this happens at the same time on a regular basis.

    Leave a comment:


  • M1th
    replied
    You sure this happens only on sunday?

    Good point.. im not really sure.


    And to add to this problem, everytime I try to update a template in admincp, the server screws up again (high mysql process)


    Steve, "no crontab for root"

    Leave a comment:


  • Floris
    replied
    You sure this happens only on sunday?
    You run apache 2 right ?

    Could you run the server with apache 1 and see if it makes a difference ?

    Leave a comment:


  • Steve Machol
    replied
    Check your root cronjobs to see what may be running on Sundays.

    Leave a comment:


  • M1th
    replied
    Okay, this is annoying. It's doing it again!

    45.18, 29.01, 12.36 !!!

    Leave a comment:


  • M1th
    replied
    Originally posted by Zachery
    You have a ton of sleeping processes, not sure if thats good or bad, but are you using usepconnect?

    Nope, its off.

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X