Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17
  1. #11
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: Queries Overloading Server

    If your host is chocking your connection,

    do you have SSH access?

    If so can you run

    the following and post the information here...
    this is just info on the CPU and RAM nothing critical

    cat /proc/cpuinfo
    then
    cat /proc/meminfo
    Zen cart PCI compliant Hosting

  2. #12
    Join Date
    May 2004
    Posts
    44
    Plugin Contributions
    0

    Idea or Suggestion Re: Queries Overloading Server

    I've rolled back a copy of the 1.26 version and have both 1.3 and .126 running on the server with separate databases and files..

    It would seem that for each option on a product, 2 queries get fired. one for the option_value and one for the option_name?

    This particular product has 96 potential option values for Colour - giving us 200 queries on that page?

  3. #13
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: Queries Overloading Server

    Did you run the CPU and MEM tests for me?
    Zen cart PCI compliant Hosting

  4. #14
    Join Date
    May 2004
    Posts
    44
    Plugin Contributions
    0

    Default Re: Queries Overloading Server

    The host isn't choking the connection with any particular quotas or limits, but manually suspends the account if they determine that a script is using too much processor or memory.

    CPU:
    processor : 3
    vendor_id : GenuineIntel
    cpu family : 15
    model : 2
    model name : Intel(R) Xeon(TM) CPU 2.80GHz
    stepping : 9
    cpu MHz : 2791.709
    cache size : 512 KB
    physical id : 3
    siblings : 2
    fdiv_bug : no
    hlt_bug : no
    f00f_bug : no
    coma_bug : no
    fpu : yes
    fpu_exception : yes
    cpuid level : 2
    wp : yes
    flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
    bogomips : 5570.56

    cat /proc/meminfo
    MemTotal: 2074920 kB
    MemFree: 64508 kB
    Buffers: 127012 kB
    Cached: 1431516 kB
    SwapCached: 32 kB
    Active: 1344748 kB
    Inactive: 523116 kB
    HighTotal: 1179520 kB
    HighFree: 2176 kB
    LowTotal: 895400 kB
    LowFree: 62332 kB
    SwapTotal: 819304 kB
    SwapFree: 819244 kB
    Dirty: 2880 kB
    Writeback: 0 kB
    Mapped: 264552 kB
    Slab: 126188 kB
    CommitLimit: 1856764 kB
    Committed_AS: 916896 kB
    PageTables: 4060 kB
    VmallocTotal: 118776 kB
    VmallocUsed: 3528 kB
    VmallocChunk: 113848 kB
    HugePages_Total: 0
    HugePages_Free: 0
    Hugepagesize: 2048 kB

  5. #15
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: Queries Overloading Server

    they are running a high end processor,
    and 2 GB of ram,

    they need to put less accounts on a server.

    I run celeron 2.4 with 2 GB ram and dont have this issue
    Zen cart PCI compliant Hosting

  6. #16
    Join Date
    May 2004
    Posts
    44
    Plugin Contributions
    0

    Default Re: Queries Overloading Server

    Yeah, I'm seriously considering moving in a couple months when we have another application to justify the cost of a dedicated server.

    In the meantime, you don't have any ideas on the 1.3 errors do you?


    Thanks again for all your help!

  7. #17
    Join Date
    May 2004
    Location
    Hong Kong
    Posts
    1,291
    Plugin Contributions
    1

    Default Re: Queries Overloading Server

    There is a short term work around, please refer to it.

    Rotating Db Users

    .
    A New Starter again

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Replies: 1
    Last Post: 14 Feb 2015, 08:37 PM
  2. Queries
    By mprough in forum General Questions
    Replies: 8
    Last Post: 6 Nov 2012, 01:59 PM
  3. blank page due to spider scans overloading the server ?
    By dlg_ie in forum General Questions
    Replies: 7
    Last Post: 19 Jul 2009, 11:37 AM
  4. HELP! Define Pages Editor Process Overloading Server
    By y2caye in forum General Questions
    Replies: 3
    Last Post: 12 Jun 2009, 06:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR