Site Slowness Issues

[horzverti]

Site fast, site slow. It happens. Just remain patient. I am just happy to have this site.

Thanks Leon

[Leon]

Originally Posted by horzverti

Site fast, site slow. It happens. Just remain patient. I am just happy to have this site.

Thanks Leon

Thanks Curt.

It's going to be this way for a few days or so, it looks like. Here is what the engineer said this morning...(And this is if all goes well....)



"I need to upgrade the db but first I had to take a backup. You have server level veam backups but we need to be able to take an up to the minute copy.

I took a copy last night and I restored it to the other server so I could test upgrading the databases. If it works, we will have to do it for real which require taking the site offline for at least 6-8.

It takes a long time to do a backup because the attachment table is now 46GB. A Mysqldump is single threaded, so I had to use a tool to thread it and get it down to 2-3 hours. But that is 2-3 hours to backup and 2-3 to restore and the site must be offline during.

I’m not finished testing the new db, but in the meantime there may be intermittent slowness."

.
So that is where we are...thanks for everyone's patience.

[Eric72]

Originally Posted by Leon

Thanks Curt.

It's going to be this way for a few days or so, it looks like. Here is what the engineer said this morning...(And this is if all goes well....)



"I need to upgrade the db but first I had to take a backup. You have server level veam backups but we need to be able to take an up to the minute copy.

I took a copy last night and I restored it to the other server so I could test upgrading the databases. If it works, we will have to do it for real which require taking the site offline for at least 6-8.

It takes a long time to do a backup because the attachment table is now 46GB. A Mysqldump is single threaded, so I had to use a tool to thread it and get it down to 2-3 hours. But that is 2-3 hours to backup and 2-3 to restore and the site must be offline during.

I’m not finished testing the new db, but in the meantime there may be intermittent slowness."

.
So that is where we are...thanks for everyone's patience.

veam backups

attachment table

Mysqldump is single threaded

I know the feeling. Sometimes when I back up from the table and go take a sqldump, it can take a while.

[brunswickreeves]

Not mine, but perhaps a fitting and very rare card for this rare occasion…T206 "Slow Joe" Doyle, N. Y. Nat'l (hands above head) error

[Leon]

Even though the site is running fine at this minute, the engineer said the database upgrade was unsuccessful. So, there is going to be some more pain, most likely, before it gets better. It's being worked on...thanks for everyone's patience.

.