On Sat, Feb 08, 2003 at 01:13:28PM -0500, pthes wrote:
> Here are some claims from the hosting service:
> It is exceptionally PHP and MySQL heavy and unfortunately not the kind of
> application you can safely run in a shared-hosting environment.

It is never safe to allow customers to upload their own scripts in a
shared hosting environment.  I can't count the number of times I've had
to step in and disable an account (or at least a CGI) because a customer
wrote or uploaded something that consumed too many resources.

> So you suggest leaving the db open? What happens when someone bails out
> before the end? Would that then cause another problem?
> - You should be able to initiate a db close after a certain amount of time.

Without seeing the code, it's hard to determine what you're doing wrong;
if you're using a CREATE TEMPORARY TABLE, the table will automatically
be deleted shortly after the database connection is closed.  This would
obviously consume memory in the database server for every temporary
table created.

> Are concurrent connects with mysql the problem?
> - They certainly don't help. The MySQL server is shared amongst other sites
> on this same server and obviously can only handle so much happening at once.

If you're using mysql_pconnect() to talk to the server, remember that
each persistent connection is tied to just one web server process.  If
the web server has "MaxClients 150" set, then there can be a maximum of
150 persistent database connections, even if there's just one PHP script
opening them all.

> Comment 5: response to I don't believe php is worse than perl
> CGI scripts are called once a form has been completed, the script then runs
> quickly and closes itself. A pHp page May open a connection to mySQL at the
> opening of the page, or later in it: either way instead of having the
> information passed to mysql in a separate place, it is done in the same
> place.
> It gives the impression of being more efficient(since a step is skipped) but
> for high traffic operations it can bog down a mySQL server, Especially if it
> is a shared one.

This is legitimate.  I've seen serious degradation of MySQL performance
with much lower load than you're generating, always caused by
programming with a complete lack of regard for the database server's
resource limits.  If you don't know how to make your code more database
friendly, you might want to consider hiring a programmer to do it for
you.  Or if you prefer, spend the money on a dedicated server, and watch
*it* grind to a halt as well.  :)

> I wondering if anyone has an opinion of whether I'm dealing with people who
> don't know what they're doing. Do any of their comments make sense.
> I'd be glad to provide further clarification if desired. I just have a real
> feeling that I'm not getting knowledgable answers.

You are, they do, and you are.

  Paul Chvostek                                             <[EMAIL PROTECTED]>
  Operations / Abuse / Whatever
  it.canada, hosting and development                   http://www.it.ca/

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to