Not sure if right spot for this, but I got this message from my host provider that i exceeded some limits

The maximum number of concurrent MySQL connections per user is 10.

The maximum number of database queries per user is 75,000/hr.

I understand the database queries per/hr but not the top concurrent MySQL connections.

now is 75,000 database queries/hr alot or should i be looking for a host that allows more. I get my database optimized all the time and always have programmers redo the scripts i have so they function better with the new php.

any suggestions or help is appriciated.

thanks in advance

    msnhockey wrote:

    I understand the database queries per/hr but not the top concurrent MySQL connections.

    If your site was serving ten requests at the same time, and each of those requests used the database, then that would be ten concurrent connections for one user (where "user" refers to the account the server connects to the database with).

    msnhockey wrote:

    now is 75,000 database queries/hr alot

    Impossible to say without knowing a lot more about what sort of business you were operating than is appropriate; for some organisations it would be normal or even low - but those organisations would be the sort to would have their own network infrastructure.

    If you were slashdotted or otherwise targeted, there might have been a one-off spike in traffic that brought your hosting provider's systems down to a crawl - but would probably have maxed out the maximum connections limit as well, limiting the rate at which queries being made.

    Since you aren't in direct control of how many queries get made in an hour, it's more useful to know how many queries you make to process a request - you're in a better position to adjust that.

      ah ok..i understand now.

      my site is a stats site for a hockey simulation league. not overly busy, but busy enough.

      Will check alittle more into things and see if any files have changed that might be causing it

        Write a Reply...