Pipes Magazine » PipesMagazine.com

1. 

   Kevin
   

   Smoking a Pipe Right Now
   Joined: Nov 2008
   Posts: 4,719

   offline

   Login to Send PM

   I have removed the new programming we did last week in the forums for email notifications for private messages and favorites notifications.

   I suspect that is was causing a massive amount of database calls that maxed out the resources on the server.

   I don't think it's the programmers fault. I read somewhere that BBPress, the script we use, is inefficiently programmed from the core, and looks up every single database record for the email function, causing an overload.

   I read this in a developers forum, and a guy explained how he custom re-wrote it and fixed it.

   Now if I can only find that post again.

   I am speculating a bit, but the problems happened after the new programming. If the site continues to run fine now, then I was right.

   Check Out Our Sister Site - Cigar Chronicles
   
   Certified Master Tobacconist (CMT) #1858

   Posted 4 months ago #
2. 

   cyndi
   

   Preferred Member
   Joined: Nov 2009
   Posts: 1,194

   offline

   Login to Send PM

   Time to whip out the old google-fu!

   I'm chilling on a dirt road
   Laid back, swerving like I'm George Jones
   Smoke rolling out the window

   Posted 4 months ago #
3. 

   markw4mms
   

   Senior Member
   Joined: Jun 2011
   Posts: 2,219

   online

   Login to Send PM

   Thanks for the update, Kevin. I'll let you know if it hiccups on me again.

   "Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety."
   - Benjamin Franklin
   

   Posted 4 months ago #
4. 

   Kevin
   

   Smoking a Pipe Right Now
   Joined: Nov 2008
   Posts: 4,719

   offline

   Login to Send PM

   I found it.

   
   We re-architected part of this plugin. After a new post this plugin was loading every single user record, then iterating through them to check the metadata for each user and see if the user had flagged the topic as a favorite. Tens of thousands of database queries.

   Instead of using the stored list of favorite topic_ids in the user meta-dataspace, we solved the problem by adding functions that manage the storing of user_ids in the topic meta-space. So the number of database queries is 1.

   Pretty retarded. I guess the guys that wrote the original programming never had a very busy, high-traffic site.

   Having 10,000 database queries, when you should have only 1 is certainly going to be an issue.

   Posted 4 months ago #
5. 

   cyndi
   

   Preferred Member
   Joined: Nov 2009
   Posts: 1,194

   offline

   Login to Send PM

   Nice. So they're DDoS'ing themselves.

   Posted 4 months ago #
6. 

   Kevin
   

   Smoking a Pipe Right Now
   Joined: Nov 2008
   Posts: 4,719

   offline

   Login to Send PM

   LOL Cyndi! Yes!

   Posted 4 months ago #
7. 

   cyndi
   

   Preferred Member
   Joined: Nov 2009
   Posts: 1,194

   offline

   Login to Send PM

   Come to speak of DDoSing, I'm surprised we haven't been hit by one by the antis yet. *knocks on wood*

   Posted 4 months ago #
8. 

   Mick
   

   Member
   Joined: Dec 2011
   Posts: 1,184

   offline

   Login to Send PM

   Thanks for staying on top of it Kevin.

   I see too much bad database design... Even in software that costs 1,000's of $. Keeps me busy at least.

   "The fact is, squire, the moment a man takes to a pipe, he becomes a philosopher. It's the poor man's friend; it calms the mind, soothes the temper, and makes a man patient under difficulties. It has made more good men, good husbands, kind masters, indulgent fathers, than any other blessed thing on this universal earth."
   -"Sam Slick, the clockmaker" aka T.C.Haliburton

   Posted 4 months ago #
9. 

   Kevin
   

   Smoking a Pipe Right Now
   Joined: Nov 2008
   Posts: 4,719

   offline

   Login to Send PM

   I called the owner of the hosting company and said; "Sorry for being a dick yesterday." I really reamed him out big time.

   Posted 4 months ago #
10. 

    Chris
    

    Member
    Joined: Sep 2011
    Posts: 257

    offline

    Login to Send PM

    I see too much bad database design... Even in software that costs 1,000's of $. Keeps me busy at least.

    Very true. I like to think of efficient code as an art.

    I believe in Christianity as I believe that the sun has risen: not only because I see it, but because by it I see everything else. -- C. S. Lewis, Theologian, Philosopher, Professor, Pipe smoker.

    Posted 4 months ago #
11. 

    baronsamedi
    

    Preferred Member
    Joined: May 2011
    Posts: 2,752

    offline

    Login to Send PM

    I'm still having some trouble. It says "server error".

    BTW, I'm not a badass, I'm just socially awkward. – BillyZoom

    Posted 4 months ago #
12. 

    tobakenist
    

    Senior Member
    Joined: Jun 2011
    Posts: 510

    offline

    Login to Send PM

    Still takes ages for the site to boot up.

    Regards Ken,
    I am not young enough to know everything.

    Posted 4 months ago #
13. 

    Kevin
    

    Smoking a Pipe Right Now
    Joined: Nov 2008
    Posts: 4,719

    offline

    Login to Send PM

    Hmmm. PM has been flying for me since making the change, but I was off working on Cigar Chronicles and found it to still be timing out. I think it needed a database refresh, which we did, and it's flying now too.

    Perhaps the problem with CC was bogging down PM when you guy experienced the most recent problems.

    So let's watch it for this point on, and let me know if anything takes more than 6 - 7 seconds to load. Thanks.

    Posted 4 months ago #
14. 

    Anonymous
    

    Unregistered
    
    Posts: 2,437

    offline

    Login to Send PM

    Thanks for the update Kevin,

    It's actually been a little slow for me still as well.

    I get to the home page fine, hangs up getting into the forum.

    Posted 4 months ago #
15. 

    Brewshooter
    

    Senior Member
    Joined: Jun 2011
    Posts: 713

    offline

    Login to Send PM

    Down completely for me for about an hour this morning.

    Posted 4 months ago #
16. 

    baronsamedi
    

    Preferred Member
    Joined: May 2011
    Posts: 2,752

    offline

    Login to Send PM

    I got this "error establishing a database connection" about 15 minutes ago. It's only the forum, though.

    Posted 4 months ago #
17. 

    chopz
    

    Member
    Joined: Oct 2011
    Posts: 192

    offline

    Login to Send PM

    if i ever use the word "re-architected" in a sentence please someone shoot me for terminal douchebaggery.

    Posted 4 months ago #
18. 

    pipeinhand
    

    Senior Member
    Joined: Sep 2011
    Posts: 854

    offline

    Login to Send PM

    Kevin I think you broke the Internet. I can't get Yahoo to work worth a damn. What have you done!

    There is nothing like being left alone again, to walk peacefully with oneself in the woods.
    To boil one's coffee and fill one's pipe, and to think idly and slowly as one does it.

    Posted 4 months ago #
19. 

    Kevin
    

    Smoking a Pipe Right Now
    Joined: Nov 2008
    Posts: 4,719

    offline

    Login to Send PM

    I'm going offline for the next 12 hours or so.

    If the site breaks down while I'm away, please feel free to do me a favor and go here:

    https://www.rackco.com/support.php

    Enter your name in the chat box and tell them:

    pipesmagazine.com is down, or slow, or hanging, whatever the case may be.

    If you want to help with this, make a copy of this offline, as when the site is down, you obviously won't be able to see this.

    Posted 4 months ago #
20. 

    rickpal14
    

    Senior Member
    Joined: Jun 2011
    Posts: 1,084

    online

    Login to Send PM

    Sounds like Kevin has a HOT date lined up with his new hottie!!!

    Posted 4 months ago #

RSS feed for this topic

Reply

You must log in to post.

    Back To Top  | Back to Forum Home Page

   Members Online Now
   topd, jcsnaps, marmal4de, rickpal14, lonestar, bigvan, markw4mms, ssjones, elwin, portascat, photoman13, irishsmoker