Site Slowness Issues

Eric72 · #1 07-18-2025, 06:09 PM

Quote:

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 · #2 07-19-2025, 05:24 AM

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 · #3 07-19-2025, 09:16 AM

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.

.

Leon · #4 07-21-2025, 07:56 AM

Obviously, the site is still running a little slow. We are trying to figure out where all of the BOT viewers and active users are coming from. That is what is slowing the site. This morning it showed (publicly at bottom of the screen) there were over 66 thousand active users There should be around 600 or so....
.

Leon · #5 07-23-2025, 08:30 AM

Quote:

Originally Posted by Leon

Obviously, the site is still running a little slow. We are trying to figure out where all of the BOT viewers and active users are coming from. That is what is slowing the site. This morning it showed (publicly at bottom of the screen) there were over 66 thousand active users There should be around 600 or so....
.

Same thing is still happening. It's being worked on. Thanks everyone...
.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Site Issues & Maintenance - Update 2/14/21 Site Down 7pm CST	Leon	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	9	02-14-2021 06:16 PM
Site Issues & Maintenance - Update 2/14/21 Site Down 7pm CST	Leon	Net54baseball Sports (Primarily) Vintage Memorabilia Forum incl. Game Used	9	02-14-2021 06:16 PM
Site slowness 7/20/16	Leon	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	8	07-21-2016 03:47 AM
Site slowness	Leon	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	3	06-22-2016 04:37 PM
Legendary Web site slowness?	Archive	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	31	04-29-2009 09:46 PM