litespeed - database connections errors

Discussion in 'General' started by mecho, Dec 5, 2008.

  1. mecho

    mecho New Member

    Hi ,

    few days ago my datacenter support suggested me to use litespeed instead of apache and as we tried i'm happy with it . speed is great and pages loads much faster . but in one of our websites we have database connection errors !

    we have few rewrite rules for these websites , first i thought those lines are the reasons and i removed them but still we get errors :

    and here are the lines (18 & 27):
    Any help would be more than great .

    thanks :)
  2. PSS

    PSS Member

    My guess is that first query result does not fit to allocated PHP memory (memory_limit) and it crashes the PHP process. I don't think Litespeed has anything to do it.
  3. mecho

    mecho New Member

    didn't fix it. Although raising it "helped" a little or seemed to. I would say thats not the problem. and i'm sure script is fine becuase we had no problem with it before litespeed. i'm not saying that litespeed is the reason . i guess some configs are not correct which i have no idea what it can be .

    any idea ?
  4. mecho

    mecho New Member

    Anyone ??? any suggestion ?
  5. PSS

    PSS Member

    1. Do CHECK TABLE for all tables with phpmyadmin. If you see corrupted .MYI files repair those tables at least twice (yes!).
    2. if above does not help, increase max temporary table size in my.cnf, e.g. : tmp_table_size=128M
    3. check mysql error log for clues
    4. Again, the result set must fit into php memory, if you do SELECT * make sure you know how much data you get.
  6. mistwang

    mistwang LiteSpeed Staff

    If you are using cPanel, you can try 3.3.23 package, cPanel impose a memory limit of 256MB, which will be passed to PHP processes running in non-suEXEC mode, it has been fixed in 3.3.23 release. Just change the version number in the download link to get it.

Share This Page