• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

250,000 Database queries

Adam Howard

Well-known member
#1
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? :eek::confused::eek:o_O

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. :eek:

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

Active member
#2
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? :eek::confused::eek:o_O

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. :eek:

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

Well-known member
#3
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

Well-known member
#4
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

Active member
#6
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

Well-known member
#7
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

Well-known member
#8
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.