Results 1 to 13 of 13

Thread: Avoiding site suspensions because of large queries?

  1. #1
    Registered
    Join Date
    Apr 2011
    Location
    UK
    Posts
    12
    Rep Power
    0

    Avoiding site suspensions because of large queries?

    I have been a powweb member for several years now and my Joomla site has been slowly growing over the years. There is weekly organic growth mainly from entries in the forum and the occasional comment.

    The site is using the latest Jooml1 1.5 and I am trying to upgrade to 2.5 when all the extensions have versions available.

    My total site size is around 5GB. New posts per day about 10.

    Out of the blue I keep receiving site suspension notices that inform me that my site has been suspended because large queries are being executed and this is consuming disc space and affecting performance.

    I seek to stay within my hosting agreement but I am struggling to understand the reason for the suspensions so that I can take appropriate action to remedy them. I have altered my site in a few ways to try to mitigate the problems but, without understanding the root cause, these efforts represent guesses at best and, given the continuing suspensions, are evidently not solving the problem.

    Requests to powweb for more information to help me on this result in the suggestion to upgrade my site. That's not really helping.

    I wondered if others are in this situation and what actions have been taken the remedy issues such as large queries or tools that have been used to identify the problem/component etc?

    With thanks
    David

  2. #2
    Mod.. with bite.. Croc Hunter's Avatar
    Join Date
    Sep 2002
    Location
    Australia
    Posts
    7,332
    Rep Power
    26
    Joomla is a resource hog. Uprading may help. Old installs quicky become targets for automated attacks. Just because spam posts don't appear does not always mean they are not generating queries. Check whats happenng in your logs upto an hour before each suspension.
    Croc Hunter MSC :

  3. #3
    Registered
    Join Date
    Apr 2011
    Location
    UK
    Posts
    12
    Rep Power
    0
    Croc Hunter,

    Thank you for this. Are the logs to check the files with the name 'access_log_20120503.gz' etc?

    Regards
    David

  4. #4
    Mod.. with bite.. Croc Hunter's Avatar
    Join Date
    Sep 2002
    Location
    Australia
    Posts
    7,332
    Rep Power
    26
    Yes unzip and check those, haven't really checked in awhile but I think Powweb still offers both HTTP and MySQL logs. The MySQL logs are what you really want if there are bogus queries. Your stats may also give an indication, perhaps you have just grown to popular for shared hosting like Powweb.

    EDIT:

    HTTP logs: http://www.powweb.com/webControl/LogFiles.bml
    MySQL error logs: http://www.powweb.com/member/cgiMana...giErrorLog.bml

    Keep in mind the MySQL logs only show errors not all traffic.
    Croc Hunter MSC :

  5. #5
    Registered
    Join Date
    Apr 2011
    Location
    UK
    Posts
    12
    Rep Power
    0
    Thank you. That's really helpful. I will investigte the logs.

    What are the criteria for looking for a new host?

  6. #6
    Former Spam Filter (EU) IanS's Avatar
    Join Date
    Mar 2004
    Location
    Washington (THE original UK one!)
    Posts
    12,964
    Rep Power
    30
    We can't really advise on what is the best alternative host for you as this is a Powweb sponsored forum area. Look carefully at reviews, especially those citing the speed with Joomla and MySql query limits.
    This is a Powweb customer
    helping Powweb customer forum.

    I am a customer just like you!!

    Some matters can only be answered by staff or support.
    Give it a go - ask here first!

  7. #7
    Registered
    Join Date
    Apr 2011
    Location
    UK
    Posts
    12
    Rep Power
    0
    IanS,

    Rather than alternative hosts I was thinking more about the criteria that might be applied for different hosting providers. For example, that powweb is ideal if your site is of type x, average visits < y, ...

    I'm sure that would be a difficult and subjective list to compile but it would help people like me who are struggling with a hosting agreement.

    With thanks
    David

  8. #8
    Former Spam Filter (EU) IanS's Avatar
    Join Date
    Mar 2004
    Location
    Washington (THE original UK one!)
    Posts
    12,964
    Rep Power
    30
    Any referrence here to other hosts names are removed by very zealous moderators so posting that <<removed>> is great wouldn't help. This isn't the place for that type of comparison.
    This is a Powweb customer
    helping Powweb customer forum.

    I am a customer just like you!!

    Some matters can only be answered by staff or support.
    Give it a go - ask here first!

  9. #9
    target='_blank' snowmaker's Avatar
    Join Date
    Nov 2002
    Location
    Not in Solomons anymore.
    Posts
    3,442
    Rep Power
    21
    Quote Originally Posted by IanS View Post
    Any referrence here to other hosts names are removed by very zealous moderators so posting that <<removed>> is great wouldn't help. This isn't the place for that type of comparison.
    I agree.
    Hosting - PowWeb Community Forums
    -bruce /* somdcomputerguy */
    'If you change the way you look at things, the things you look at change.'

  10. #10
    Registered
    Join Date
    Apr 2011
    Location
    UK
    Posts
    12
    Rep Power
    0
    IanS, Snowmaker - Just to clarify, I am not seeking the names of alternate hosts. Instead to better understand how the current host meets my requirements.

    Croc Hunter - I asked for the logs but was told these are not available on a shared platform. All Support could say was the size of my largest table and that the incident was connected to the registration. That information did not really help.

    Something else that happened on my site recently was that I exceeded the MySQL query limit. Exceeding this limit meant that my site was again unavailable. I don't know what is generating these queries and have asked Support for more information. Luckily the limit is reset hourly so the site was not down for too long but my inability to measure/control this usage means the problem is likely to recur.

    Regards
    David

  11. #11
    Former Spam Filter (EU) IanS's Avatar
    Join Date
    Mar 2004
    Location
    Washington (THE original UK one!)
    Posts
    12,964
    Rep Power
    30
    You need to remember, if looking for alternative hosts, that many different 'names' of hosting companies are really the same company. Powweb is one of around 10 (or more) 'properties' (ie hosting companies) owned by one group. This pattern applies to many hosting 'names'. Shared hosting will come with similar issues no matter which company or 'group' you're with.
    This is a Powweb customer
    helping Powweb customer forum.

    I am a customer just like you!!

    Some matters can only be answered by staff or support.
    Give it a go - ask here first!

  12. #12
    Registered
    Join Date
    Apr 2011
    Location
    UK
    Posts
    12
    Rep Power
    0
    I didn't realise that. Thank you Ian

  13. #13
    Seawitchartist's Avatar
    Join Date
    Apr 2006
    Location
    London
    Posts
    222
    Rep Power
    12
    Quote Originally Posted by IanS View Post
    You need to remember, if looking for alternative hosts, that many different 'names' of hosting companies are really the same company. Powweb is one of around 10 (or more) 'properties' (ie hosting companies) owned by one group. This pattern applies to many hosting 'names'. Shared hosting will come with similar issues no matter which company or 'group' you're with.
    Flag of Convenience shipping springs to mind!
    Never trust statistics unless you fiddled the figures yourself!

    www.seawitchartist.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •