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

Logged In Members Getting Out of Memory Error, But Guests Can View The Site

Discussion in 'Server Configuration and Hosting' started by TheBigK, Jul 28, 2014.

  1. TheBigK

    TheBigK Well-Known Member

    We're under heavy traffic as of now, and the logged in members are being presented with Out Of Memory Zend/Db/Statement/Mysqli.php on line 294 error. The guests can see the site fine, and this could be because we use bd Cache plugin to cache our content.

    The server admin says that server isn't using all the memory and has not started using SWAP as of now.

    Could you please tell me what's the best way to fix such issues?
     
  2. Neal

    Neal Well-Known Member

    I'm a guest and just got this trying to open the forum via your nav bar:

    Fatal error: Out of memory (allocated 78643200) (tried to allocate 83 bytes) in /home/crazzzz/public_html/library/Zend/Db/Statement/Mysqli.php on line 304

    The home page is working fine and clicking links to the threads from the home page work.
     
  3. TheBigK

    TheBigK Well-Known Member

    Strange, we've asked our members and they confirmed that they can view the site as guests. Could you please recheck?
     
  4. Neal

    Neal Well-Known Member

    Yes I can see the forum now and view the content.
     
    TheBigK likes this.
  5. RoldanLT

    RoldanLT Well-Known Member

    Start disabling some heavy addons.
     
  6. RoldanLT

    RoldanLT Well-Known Member

  7. TheBigK

    TheBigK Well-Known Member

    Is there any definitive way of figuring out which addons are heavy? The debug mode tells me which add-on is eating lot of memory; but it requires a lot of trials.
     
  8. RoldanLT

    RoldanLT Well-Known Member

    Unread Post Count of Chris D can be one of them.
    XenTag
     
  9. TheBigK

    TheBigK Well-Known Member

  10. RoldanLT

    RoldanLT Well-Known Member

    BD Cache by xfrocks and Xen Cache works differently.
    BDCache is good for the guest mostly, but Xen Cache can really help both guest and logged members.
     
  11. TheBigK

    TheBigK Well-Known Member

    and it looks like you're using both BD cache and XenCache simultaneously. Have you noticed any significant difference with and without these addons?
     
  12. RoldanLT

    RoldanLT Well-Known Member

    Yes, Xen Cache save/cache queries both guest and members.
    So if you have BD Cache already installed, Xen Cache is useless for the guest on some pages that BD cache already cache it but still very good for logged members.
     
    TheBigK likes this.
  13. TheBigK

    TheBigK Well-Known Member

    I think I'd just uninstall the BD Cache addon and give XenCache a try.
     
  14. RoldanLT

    RoldanLT Well-Known Member

    No, just use them both.
    BD Cache Cache threads that Xen Cache is not capable of.
    Xen Cache only cache queries on major pages like:
    • Cache count thread in forum.
    • Cache list normal thread in forum.
    • Cache list sticky thread in forum.
    • Cache session activity records.
     
    TheBigK likes this.
  15. RoldanLT

    RoldanLT Well-Known Member

    BD Cache doesn't work on thread_view like Xen Cache ;)
     
  16. TheBigK

    TheBigK Well-Known Member

    The Server Admin got back saying this :-

    Can someone tell me what's happening?
     
  17. RoldanLT

    RoldanLT Well-Known Member

    To override that limit, in your config.php
     
  18. TheBigK

    TheBigK Well-Known Member

    Thanks, but are those limits deliberately set to lower? Why is php memory limit different for mysqli.php?
     
  19. Floren

    Floren Well-Known Member

    XenForo recommends you to use at least 128MB of memory allocated to PHP and recommends 256MB:
     
  20. TheBigK

    TheBigK Well-Known Member

    Thanks. Is PHP memory limit defined separately for mysqli.php?
     

Share This Page