250,000 Database queries

[Adam Howard]

I was going to post this in the proper add-on thread, but I know a lot of people do not follow those threads (I don't for example).

I recently helped someone who could not figure out why their server was locking up and freezing on them. They had a power server that would make any tech geek sing with joy

12 Core CPU @ 3Ghz
64 GB or Ram
2 TB on SSD Hard Drives

So what was the problem? Well how about 250,000 ( 1/4 of a Million) database queries?

There is an old add on which adds 1 database query per tag word. So if you have 5 tags, you have 5 queries. Or if you have 250,000+ tags you have 250,000+ queries.

With all the people browsing their site... Well into the thousands... This became an issue. The grand total of queries running with everyone online is unknown (kept locking up).

For those of you who may have the following add-on installed

http://xenforo.com/community/resources/thread-tag-for-xenforo.625/

It maybe a good idea, as a suggestion, to un-install it.

Upon removal you should also be able to drop the following tables from your database

******_tags
******_tagcontent

I would suggest this (the following) as the alternative to replace it with the following

http://xenforo.com/community/resources/tinhte-xentag.770/

 

[Xyphien]

I was going to post this in the proper add-on thread, but I know a lot of people do not follow those threads (I don't for example).

I recently helped someone who could not figure out why their server was locking up and freezing on them. They had a power server that would make any tech geek sing with joy

12 Core CPU @ 3Ghz
64 GB or Ram
2 TB on SSD Hard Drives

So what was the problem? Well how about 250,000 ( 1/4 of a Million) database queries?

There is an old add on which adds 1 database query per tag word. So if you have 5 tags, you have 5 queries. Or if you have 250,000+ tags you have 250,000+ queries.

With all the people browsing their site... Well into the thousands... This became an issue. The grand total of queries running with everyone online is unknown (kept locking up).

For those of you who may have the following add-on installed

http://xenforo.com/community/resources/thread-tag-for-xenforo.625/

It maybe a good idea, as a suggestion, to un-install it.

Upon removal you should also be able to drop the following tables from your database

******_tags
******_tagcontent

I would suggest this as the alternative to replace it with the following

http://xenforo.com/community/resources/tinhte-xentag.770/

That is crazy, thanks for the read. Luckily upon making my new XF site I used Tinhte's instead as a mistake :3 Luckily it was one that would benefit me in the long run. I would have never known that a simple tag would be the cause of several Terra bites to freeze up :0

 

[surfsup]

That is crazy, thanks for the read. Luckily upon making my new XF site I used Tinhte's instead as a mistake :3 Luckily it was one that would benefit me in the long run. I would have never known that a simple tag would be the cause of several Terra bites to freeze up :0

Do you still use the tinhte's tag addon? hows that working out for you?

 

[Robbo]

Lol at how you went about telling everyone this. Guess it pissed you off or something.

Looked at the code. It is pretty bad and this is why I don't recommend add-ons to people except from the authors I know.

Look at the bright side, with this add-on installed you can get up to the vb5 query count and have a real forum

 

[Xyphien]

Do you still use the tinhte's tag addon? hows that working out for you?

It works fine, I like it honestly very easy and simple. Click the *add tag* on topics without a tag and give tags, boosts up SEO a lot faster than without tags.

 

[Xyphien]

Lol at how you went about telling everyone this. Guess it pissed you off or something.

Looked at the code. It is pretty bad and this is why I don't recommend add-ons to people except from the authors I know.

Look at the bright side, with this add-on installed you can get up to the vb5 query count and have a real forum

Well something like that can be devastating to a forum so since it does that much queries he was helping out everyone who may have the same problem, or who are using the plugin so they can decide if they want to continue to use it or not. Most people I know don't come close to using even half a Terrabite so a site that froze up with 2TB can be devastating to any other forum.

 

[Adam Howard]

Small clarification

I would recommend Tinhe XenTag http://xenforo.com/community/resources/tinhte-xentag.770/

^^ Does not seem to have this problem

It is only vinavb's version that does seem to have this problem http://xenforo.com/community/resources/thread-tag-for-xenforo.625/

This post is not meant to hate upon anyone. Just a word of caution as there is an add-on which seems to cause large problems and the developer seems to be unreachable (I tried).

I just do not want to see anyone else run into this problem. Most shared host or vsp host would have pulled the plug with little notice if they had to many database queries.

 

[Adam Howard]

yeah, i'd rather be in the know of something like this, before having the site yanked offline for any issues. And considering I just moved to a shared host from semi-dedicated hosting... Something doing that many queries might have gotten my site yanked offline (without much notice) till "fixed".

I had something happen to me in the past on another site.....

My site was running smoothly and I went on vacation for a full 1 week. Upon my return I discovered that my site had been offline for 6 1/2 days. About 1/2 a day into my vacation an add-on which I had installed kicked in a few things and loaded the cpu and ram so high that it was knocking other sites down.

This was back when I was using IPB for another project.

A simple notice like this would have been helpful to me.