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

250,000 Database queries

Discussion in 'General XenForo Discussion and Feedback' started by Adam Howard, Oct 6, 2012.

  1. Adam Howard

    Adam Howard Well-Known Member

    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/
     
    leemy, wickedstangs, Xyphien and 2 others like this.
  2. Xyphien

    Xyphien Active Member

    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
     
  3. surfsup

    surfsup Well-Known Member

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

    Robbo Well-Known Member

    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 ;)
     
    Adam Howard and Insy like this.
  5. Xyphien

    Xyphien Active Member

    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.
     
  6. Xyphien

    Xyphien Active Member

    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.
     
    vVv and Adam Howard like this.
  7. Adam Howard

    Adam Howard Well-Known Member

    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.
     
    leemy and (deleted member) like this.
  8. Adam Howard

    Adam Howard Well-Known Member

    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.
     
    vVv likes this.

Share This Page