On Wednesday 14 August 2002 09:54 am, Thomas Seifert wrote: I disagree entirely....
Persistent connections have little or nothing to do with increasing load! Given that you mention you are using PHP I'll assume you have mod_php running in Apache. Each Apache child process in this configuration will maintain ONE open database handle, so 100k pageviews per day I would expect you might max at like 30k in one hour, or around 10/second, so you might top out at roughly 100 Apache child processes at any one time, thus 100 database connections. Each DB connection is not a huge overhead, but creating and destroying 10 database handles PER SECOND is a large overhead!!! Remember, every time mysql creates a connection it has to do internal queries on the grant tables. I don't know exactly what the overhead of that is going to be, but ANYTHING that creates 10 queries per second is putting some strain on your database server! One of the main goals of using Apache modules for scripting was to allow persistent database connections. There is really NO reason to give up that advantage. Remember, MySQL is multi-threaded, with one thread per connection, so the resources for a database connection are on the order of under 100k of memory per connection. > it will reduce the load for sure! > MySQL is very fast in opening and closing connections at least if the > database-server and webserver are on the same machine. > I don't know how it will perform on different machines. > > > Thomas > > On Wed, 14 Aug 2002 14:40:31 +0100 > > "John Wards" <[EMAIL PROTECTED]> wrote: > > I am running a website which generates around 100,000 pageviews a day and > > I am wondering if I stop using persistent conections to the MySQL > > database and use > > normal open and close conections this would reduce the load onto my > > server? > > > > Most conections are either made through my "main" file or the phorum > > message board system. > > > > Thanks in advance > > John Wards > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
