Page 2 of 2
Posted: Thu May 15, 2014 5:54 pm
by GORDON
Still reading 110 MB on the forum database.
I am concerned that using the "Prune" function merely did away with the thread pointers but left all the data.
Posted: Thu May 15, 2014 6:00 pm
by TPRJones
It sounds like it.
The only way to test that I can think of without knowing the details of the database structure would be to load up the backup and find some unique text fragments from threads that should have been deleted, then do a broad query on the current post-deletion database to see if that stuff is still out there.
Not that I have any particular recommendations of what to do once it's proved that's what is happening.
Posted: Thu May 15, 2014 6:09 pm
by TheCatt
GORDON wrote:Still reading 110 MB on the forum database.
I am concerned that using the "Prune" function merely did away with the thread pointers but left all the data.
Quick, export the DB while the threads live!
Posted: Thu May 15, 2014 6:22 pm
by GORDON
I did an export right befor I pruned, in case I fucked something up.
Easiest thing to do might be to export now that I have pruned, wipe everything, and reload the forum from scratch, hoping that just the live threads get imported. And that aint easy, that I recall. It has been at least 5 years since the last forum reload.
Posted: Thu May 15, 2014 6:29 pm
by GORDON
Just went into database administration in the domain control panel... hitting the "optimize table" button in some of the big tables (like the one called ib_forum_posts) now has us down to 75MB.
So, mission accomplished, I reckon.
Posted: Thu May 15, 2014 7:09 pm
by thibodeaux
I don't about MySQL, but I know with postgresql, even though you "delete" a row, it's still there until a vacuum runs.
Posted: Thu May 15, 2014 8:14 pm
by GORDON
That's what I figgered.
Posted: Tue Jun 10, 2014 2:18 pm
by GORDON
Anyone else hitting the occasional lag spike today? Did anyone else see the forum as completely down earlier today? I think my host is having troubles.
Or is it just me?
Posted: Tue Jun 10, 2014 2:20 pm
by TheCatt
Yeah, it gave me a weird error earlier, and I've been having occasional lag spikes for a week or so.
Posted: Tue Jun 10, 2014 2:21 pm
by Malcolm
Me, too. Last night as well.
Posted: Tue Jun 10, 2014 2:34 pm
by GORDON
I bought the domain for 10 years... about 9 years ago. I don't even remember through what agency I am registered, and I know they changed how shit is done... used to be just one company selling domains. How do I find out?
Posted: Tue Jun 10, 2014 2:42 pm
by Malcolm
Domain Name: DTMAN.COM
Registrar: 1 1 INTERNET AG
Whois Server: whois.schlund.info
Referral URL: http://1and1.com
Name Server: NS57.1AND1.COM
Name Server: NS58.1AND1.COM
Status: ok
Updated Date: 11-nov-2013
Creation Date: 10-nov-1999
Expiration Date: 10-nov-2014
Posted: Tue Jun 10, 2014 2:43 pm
by TPRJones
(repeated data snipped, Malcolm is faster)
I used to use 1AND1.com. They were awful.
Even GoDaddy.com would be a better choice when you renew.
Edited By TPRJones on 1402425851
Posted: Tue Jun 10, 2014 2:44 pm
by GORDON
Ah.............. I can renew right through the host? I don't even remember the process. I think I originally did it through networksolutions.com.
Posted: Tue Jun 10, 2014 2:46 pm
by GORDON
TPRJones wrote:(repeated data snipped, Malcolm is faster)
I used to use 1AND1.com. They were awful.
Even GoDaddy.com would be a better choice when you renew.
I used several hosts before 1and1, and they were all terribler than what we are on now... 1and1. Been stable for many years, as far as I know. Also, the reason I have forgotten all this shit is because it has been working without my needing to touch it for many years, allowing me to forget the mechanics of it all.
Posted: Tue Jun 10, 2014 2:46 pm
by TPRJones
Oh, 1AND1 is the host as well? Then ignore what i said about GoDaddy, you wouldn't want to host there.
Posted: Tue Jun 10, 2014 2:50 pm
by TheCatt
I've been with 1and1 for several years, and their hosting has been great and stable for a pretty low cost. They are expensive as a registrar (more than godaddy), but I've never had performance issues with them.
Posted: Wed Jun 11, 2014 10:33 pm
by Malcolm
Our situation has not improved.
- Henry Jones, Sr.
Posted: Thu Jun 12, 2014 7:25 am
by GORDON
Emailed tech support yesterday when the site had been down for 20 minutes. Told them even if it was working when they read the ticket to check the server logs and it should show latency and downtime.
We will see.