Board hiccups

[jimnyc]

Received a few calls that the board was down about half an hour ago. I came home, and although it was loading, it was VERY slow, and is still loading slowly for me. I can load images and HTML pages fine, just the board is slow, which means the SQL server is having issues or is overloaded.

I have already opened a support ticket. Hopefully they'll fix it ASAP. Likely another site on the server hogging the resources and they will terminate them or temporarily suspend.

Thanks for your patience as I get this fixed.

[red states rule]

Received a few calls that the board was down about half an hour ago. I came home, and although it was loading, it was VERY slow, and is still loading slowly for me. I can load images and HTML pages fine, just the board is slow, which means the SQL server is having issues or is overloaded.

I have already opened a support ticket. Hopefully they'll fix it ASAP. Likely another site on the server hogging the resources and they will terminate them or temporarily suspend.

Thanks for your patience as I get this fixed.

Right now everything is fine Jim. Thanks for the update

[jimnyc]

Yes, support sent me a reply about 10 mins ago that the SQL server was in fact overloaded. They have temporarily suspended the users account until they can sort their issues. Supposedly all is now returned to normal, but still seems a little slow to me. Then again, I think it's been slow for quite some time now.

Just an Fyi - I am looking for an alternative host for better performance and lower fees. It's a pain in the ass to move but we'll all be better off in the long run. I'll make an announcement down the road prior to any changes.

[glockmail]

In the admin panel go to maintenance/ Repair Optimize Tables and it should speed things up.

[red states rule]

The board was off line for about 15 minutes this morning Jim

[jimnyc]

In the admin panel go to maintenance/ Repair Optimize Tables and it should speed things up.

I do that sometimes, but the tables don't need to be repaired, and none of the tables are really large enough to where an optimization will make a difference. The problem here is that there are about 20 sites on this IP address, and one of them must be a popular site. When it gets real busy at that site, the SQL gets overloaded and everyone is fighting for requests.

The board was off line for about 15 minutes this morning Jim

Yep, saw that. I opened a ticket a little while back explaining the issues and asked them to find and not "suspend" the offender this time, but either terminate them for going over the appropriate usage, or to move them to a different server.

[red states rule]

I find the board running abit slow right now

[jimnyc]

I find the board running abit slow right now

Yep, it is, and it pisses me off for $30 monthly when I see so many faster sites on $5 plans. Once I can get back on my feet financially I will be making changes to both the server environment (move) and to the board.

[red states rule]

Yep, it is, and it pisses me off for $30 monthly when I see so many faster sites on $5 plans. Once I can get back on my feet financially I will be making changes to both the server environment (move) and to the board.

I would rather have it a little slow rather then down period. Seems to be fine right now Jim

[glockmail]

I do that sometimes, but the tables don't need to be repaired, and none of the tables are really large enough to where an optimization will make a difference. ....

I've got a board with this same software that is very small, and when it gets slow it speeds things right back up. The IP suggested it to me. I use Startlogic, which is very cheap, and has provided decent support, way more than I figured I'd get.

[jimnyc]

My apologies for the down time in the past half an hour. I figured it couldn't hurt to do what Glock suggested, but I picked an inappropriate time to do so. It took about 15 minutes to repair all the tables - and that's only because it failed. It failed while it had the "post" table open - so some of you may have opened posts and saw no contents. I re-ran the repair again and this time I did the others separate, then the posts table, and it appears to be fixed now.

My apologies, and please let me know in here if you see any other issues.

[Mr. P]

My apologies for the down time in the past half an hour. I figured it couldn't hurt to do what Glock suggested, but I picked an inappropriate time to do so. It took about 15 minutes to repair all the tables - and that's only because it failed. It failed while it had the "post" table open - so some of you may have opened posts and saw no contents. I re-ran the repair again and this time I did the others separate, then the posts table, and it appears to be fixed now.

My apologies, and please let me know in here if you see any other issues.

Yeah, just one...HIRE a maintenance guy cuz the one ya got now ain't worth a chit!

[jimnyc]

Yeah, just one...HIRE a maintenance guy cuz the one ya got now ain't worth a chit!

But he's affordable as he's the only one who will work for free!

[Mr. P]

But he's affordable as he's the only one who will work for free!

Yeah, and ya see, you get what you pay for.

[glockmail]

My apologies for the down time in the past half an hour. I figured it couldn't hurt to do what Glock suggested, but I picked an inappropriate time to do so. It took about 15 minutes to repair all the tables - and that's only because it failed. It failed while it had the "post" table open - so some of you may have opened posts and saw no contents. I re-ran the repair again and this time I did the others separate, then the posts table, and it appears to be fixed now.

My apologies, and please let me know in here if you see any other issues.

If you haven't done it in a while best to close the board while being done. Sorry I didn't point that out. Has it improved performance? It appears to on this end.