Site Slowness Issues

[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.