Topic: Slow Forum

Hi,

Several times recently in the early hours I have made a posting, but it apparently at the time has not been accepted.

The process seems to freeze with the "time bar" showing no green time sections...seemingly forever, certainly ten mins plus.........the forum still operates in that you can escape that process by choosing somewhere else and carry on.

If you do, and then look for your posting, it is NOT in the thread, so looks like it's not been accepted.

However, go away and do something else, and ten mins later come back, and the new posting IS there.

Happened yesterday around 07:00, and today around 06:30, and a couple of times over the Christmas period.

Apart from this, the forum is operating normally with normal load and speed times.

Dave

The server performs MYSQL backups in the early hours. This is vital so unfortunately we have to live with it.

Gerry

The server performs MYSQL backups in the early hours. This is vital so unfortunately we have to live with it.

Gerry

As late as 06:30-07:00 Gerry?

Unfortunately that's how long it takes. Backup process starts at midnight and there are several servers to backup. Your seeing the period that the MYSQL is done for RCMF there.

Gerry

That explains that, I always find it slow when I look at it around 6.30 to 7 ish

Simon

That explains that, I always find it slow when I look at it around 6.30 to 7 ish

Simon

I find just the same, could this not be scheduled for 03:00 for example? Could you not use volume shadow copy or similar? It really does grind to a halt when it's running, it would be good if a solution could be put in place.

Thanks for all of your hard work, Happy New Year.

J

I find just the same, could this not be scheduled for 03:00 for example? Could you not use volume shadow copy or similar? It really does grind to a halt when it's running, it would be good if a solution could be put in place.

Thanks for all of your hard work, Happy New Year.

J

Backup is started automatically at midnight every night. The process takes approx 7 hours to complete fully. There's no good time really to do it so it's a matter of the best of a bad bunch. Backup is handled by Webmins own MYSQL servers backup process.

Gerry

Backup is started automatically at midnight every night. The process takes approx 7 hours to complete fully. There's no good time really to do it so it's a matter of the best of a bad bunch. Backup is handled by Webmins own MYSQL servers backup process.

Gerry

IOt seems to go to a crawl at 06:30 and then back to normal at 07:00, whatever it is thats running at that time is the culprit. I have used the forum many times from 03:00 onwards without issue until 06:30.

J

I know but there is nothing showing running out of the ordinary except for backup 

IOt seems to go to a crawl at 06:30 and then back to normal at 07:00, whatever it is thats running at that time is the culprit. I have used the forum many times from 03:00 onwards without issue until 06:30.

J

Seems to be getting later now. Not back to normal until after 8-00am.
Two pages I opened this morning after 7-30: First page created in 685.827seconds and the other page created in 676.508 seconds.



   Tom

Yes, I had that this morning.

Yes, I had that this morning.

ditto....... from me too....

and me....

Why are you guys getting up in the middle of the night?   

Why are you guys getting up in the middle of the night?   

So we can get down to the field and get some aviating done.

Regards - J

Why are you guys getting up in the middle of the night?   

To go for a pee perhaps. 

Why are you guys getting up in the middle of the night?   

Well someone has to put 3 smileys after each and every joke that's posted 

Well someone has to put 3 smileys after each and every joke that's posted 

 

PDR

Gerry has posted in another thread that the data from the forum is backed up early morning.

My suggestion would be to have a lie in

Gerry has posted in another thread that the data from the forum is backed up early morning.

My suggestion would be to have a lie in

I am aware of that. However, it is getting later and later.

  Tom

I am aware of that. However, it is getting later and later.

  Tom

The backup will depend on how much info has been posted in the previous 24hrs. Therefore if the forum has been busy it will take longer.

right now forum is fine, come half 6 then it falls over for me till well after 7, its then hit or miss if i can get on it. error 504 always comes up, or cannot find the database, or i get gateway timeout. Other morning it took me nearly an hour to get on here. Kept coming up bad request.

It is certainly getting worse at the mo.

The backup will depend on how much info has been posted in the previous 24hrs. Therefore if the forum has been busy it will take longer.

The data to be backed up from here will be miniscule in relative terms to most corporate establishments, the backup no matter how busy a day it's been should be a metter of minutes rather than hours. The backup service that apparent brings it to it's knees should be scheduled to run at it's least busy time which I wouldn't have thout was 06:30 - 07:00. Knowing the team involved I'm sure there will be more to it than the face value, but it is annoying.

J

I've shifted the backup order around a tad to see if that helps 

Gerry

It did seem to this morning, thanks.

J

I've shifted the backup order around a tad to see if that helps 

Gerry

Thanks Gerry!
Has been fine last couple of days.


   Tom

Spot on now Gerry.
Thanks

  "Perfik" Gerry

  Stuart

"Perfik" Gerry

  Stuart

It wasn't at 06:25, got a load of SQL errors.

J

That would have been SQL restarting. I have set up a cron job to do that every morning. It would only take a matter of seconds to restart.

Gerry

That would have been SQL restarting. I have set up a cron job to do that every morning. It would only take a matter of seconds to restart.

Gerry

I tried over a period of about 5 minutes and then went to work, tried at work and went straight on.

J

Its a bit strange, but I have been on at all times of the day and night, and have never noticed a problem?

Its a bit strange, but I have been on at all times of the day and night, and have never noticed a problem?

You have to time it just right for it to be wrong 

J