Site Slowness Issues

[Leon]

I am aware of the site hanging and being very slow the last day or two. A support ticket was just opened. Sorry for the inconvenience.

And a card...

Paid extra for the oversized borders...Centering isn't bad either.

[Brent G.]

Well that's fast service, Leon, because it's lightning-fast by comparison now!

[Leon]

Originally Posted by Brent G.

Well that's fast service, Leon, because it's lightning-fast by comparison now!

Bite your tongue . I haven't gotten a resoponse from the support company but sometimes they do stuff and then tell me....

and a Spencer Shoes Premium...

[Lucas00]

Seems to be fixed for me now

[rdwyer]

I noticed the slowness also. Was gonna report it, but thought it was on my end.

[kmac32]

Was trying to kill some time today and went to a shop in Logansville Georgia. Found an autographed ball from a former Atlanta Black Cracker Player Red Moore. Wonder if there are vintage cards from the negro league teams like the Black Crackers?

[Lucas00]

Seems to have slowed again. Can barely load threads

[Leon]

Originally Posted by Lucas00

Seems to have slowed again. Can barely load threads

The engineer checked last night and monitored it until today. He is very, very good and I have used him for a few years.

"The server was running high cpu but the wasn’t anything unusual. I’ve watched it over night and checked this AM and it seems to be running more smoothly."

It is still being monitored. Another member sent me a Database Error message last night...so that is probably the culprit. It's a very old forum so it's not surprising to get a few of these situations.
.

[BillyCoxDodgers3B]

The slowness is back.

[Leon]

Originally Posted by BillyCoxDodgers3B

The slowness is back.

That's you getting older...

seriously, I have been on quite a bit this morning and it hasn't happened to me (knock on wood)..still watching it.

.

[ValKehl]

Leon, I am experiencing the slowness right now.

[jayshum]

Originally Posted by ValKehl

Leon, I am experiencing the slowness right now.

So am I. Very slow getting to the home page or opening any of the forums or threads.

[Leon]

Originally Posted by jayshum

So am I. Very slow getting to the home page or opening any of the forums or threads.

Me too. It's running super slow and hanging up. So, the engineer asked if it was about normal traffic and I said, yes. However, when I look now, there are approximately +/- 10x the number that normally view it. And all sections are about the same in that respect. Now to find the fix...
.

[Scott L.]

Flying like usual now.....

[Leon]

Originally Posted by Scott L.

Flying like usual now.....

They said they might have to upgrade the DB server. We'll see. I doubt the pain is over yet.
Because of that, everyone gets a 10% discount off of their membership!!

and a few random cards...

[jingram058]

Much faster page loading today; like normal. Something that was done worked!

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

.