UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Teething Problems

I think my threads-from-classic upgrade is up and running in a fairly reasonable manner, but I have a couple more questions, if I may.... The first is threads is loading reeeal slow, I have had inquiries from several members asking if this will get better, will it? Also, during the SQL installation several member's member# was changed and some got duplicate registrations (xxx_dup1, etc) and some lost the original registration entirely. Is there some way I can safely edit user names, post count, and other entries? Thanks Again, Tim

See this post regarding member #s

https://www.ubbcentral.com/forums/u...ber_numbers_after_import.html#Post182467

So...the member# is the primary key, but when a member id deleted and the database is reindexed the numbers will compact and filll the empty spaces? I see that threads no longer displays the member number, which is great with me 'cause some were getting it mixed up with our club membership number. To be sure I get it.... our member#'s are up to around 4000, but many haven't posted or visited for some time('tho I cant really tell with a lot of them because the 'last post/visit' didn't import and shows only the registration date), I want to go thru the member list and weed out non-club members who have been inactive for a couple of years or so, then optimize the database and the member#'s should fill in? I'm probably just confusing myself, too... Thanks, Tim

The member numbers were renumbered during the import. Any new ones will just auto-increment. For example if you now delete member #23. That member number will no longer exist and won't be used in the future.

As for the slowness. More than likely it's the MySQL server. If you turn on debug information in the control panel, down at the bottom you should get some information like you see here:

Generated in 0.081 seconds in which 0.005 seconds were spent on a total of 12 queries. Zlib compression enabled.

That will tell you where the slowdown is coming from, either the processing time of the scripts or from MySQL.

If it's MySQL, then there are a variety of questions to come after.

Cool on the member#'s.

It probably is the MySQL server, here is what it sez.....

"Generated in 22.815 seconds in which 22.747 seconds were spent on a total of 16 queries. Zlib compression disabled."

..... ready for questions. Thanks, Tim

Ok, definitely MySQL related. First question would be if you are on your own server or if this is a shared server. If it's shared your somewhat at the mercy of your host. It could be that they just have too many customers utilizing the MySQL server so it's slow.

I just visited your forum and it's pretty small, so really there is no reason for it to be slow at all. If this is your own server then even the default MySQL config with little memory and CPU should be running that just fine.

So, I'm going to guess your on a shared host and you might consider inquiring about the number of customers utilizing the MySQL server. If they can move you to one that isn't overloaded, or if you need to go to a new plan/provider.

If this is your own server, then we'd need some info on the server specs.

Just an update, I contacted my host (iPower) and was informed how to optimize my database (which I did again) but no info on my SQL server, then I enabled Zlib compression (?), and finally (which seemed to help) I set the forums to only load the last 6 months of posts. I feel some progress, thanks again, Tim

I still have issues (and complaints from my BB members) about UBB loading slowly. It varies. according to the time of day, from about 4 seconds to a minute or more.

I opened a trouble ticket with my web host about the slow MySQL access and the tech told me they couldn't move me to a different server, but said that they knew this is an ongoing problem and they were busy balancing the traffic (??). Then I called sales and asked the same questions and was told that for more money (a lot more) that I could upgrade my hosting plan and get a private server.

This is simply a fairly small (car) club site and forum and I can't get into the $100+ a month range, and would like to keep it ad free. Could someone suggest possible solutions for me?

I don't know if this is related, but I just did a couple of tracert's to your domain and the requests time out for the two hops right before your server...

That could actually be normal as some sites don't respond to tracert but other traffic would still flow.

What size is your database and how many NEW posts or Replies to posts per day do you get?

If it's small as you say then you're probably just with one of the hundreds of crappy host providers and need to find a new better one.

Well after a bit more of reviewing the site (at least this morning) the PHP/MySQL appear to be operating at normal speed, i.e. very fast queries.

The time delay appears to be when the actual page is rendered back to the client. There are a few hops in between that are slow. So without more detailed analysis it could be the host provider or some site it's having to go through to get back to the client. Though odd that people in different locations around the World would get that if it was due to a hop in between, would seem to be more related to the host providers network in my opinion.

The most amazing thing... Right after I posted here this morning the BB started loading every page in less than a second and has been doing so for a few hours. Maybe my call to the host provider did some good, or maybe it's an anomoly (sp), or maybe it's all the support I get from everyone on this forum. Thanks, Tim

Good, glad to hear it's working okay for you now. Moving to a new host is a PITA

Likely, they're simply doing what most webhosts do; overselling their resources. IMHO you should move.

BTW, a VPS will give you guarenteed resources at a fraction of the cost of a dedicated server; you should check out Web Intellects

webintellects has been having performance issues recently. Hopefully they'll get them straightened out. I've been with them nearly 2 1/2 years now.

Have you had your VPS that long? my god, seems like only yesterday I set the initial install up.. lol...

I wasn't having any problems with my VPS over there; but unfortunately funding didn't permit for me to keep paying on it.

Well,I'm back. Come to find out my performance boost was due to the fact they had a problem with one of their servers, somehow causing enhanced performance for me, now it is back to loading in 20 - 40 seconds. Our small club really doesn't have the funding to support a VPS right now. I was wondering if maybe my database is screwed up from the import process, I really don't know enough to start messing with it, I can't even figure out how to back it up. Is there someone available I could hire to check out the MySQL database? Thanks, Tim

WOW - That doesn't look good.

Generated in 19.432 seconds in which 19.308 seconds were spent on a total of 10 queries. Zlib compression unavailable.

Here is a result from the site here:
Generated in 0.061 seconds in which 0.027 seconds were spent on a total of 11 queries. Zlib compression enabled.

Just getting to the Forum page.
The normal Web pages load very quickly so I would have to say that something for sure is up with the PHP/MySQL that is running there.

I don't think it is an upgrade or import issue otherwise it just would not work.

Do you have access to a Server Control Panel like CPANEL or similar that allows you to run phpMyAdmin or some MySQL Admin tools?

But if it loads that slow all the time then you really need to check with your host provider support and let them know and have them check the logs and fix it or show you the logs to see what is going on.

It's definitely a MySQL bottleneck; it should never take ~20 seconds to run 10 small queries...

Really, there isn't much that could be wrong with the database itself, beyond table corruption. And if that were the case you'd get database errors. So there isn't anything you need to do on that end.

Since the temporary "problem" they had resulted in better performance for you, then it's definitely their MySQL server and the way it's being utilized.

The size of your forum definitely doesn't require a VPS. It sounds like it might just take a better host. We have many customers running boards larger than yours on hosts such as godaddy, just using their standard plan with no problems.