AW: [PHP-DB] Limit number of persistent oci8-connections?
MaxClients in httpd.conf reduces your total server performance in case you have not only db-actions but also images and plain files ... if you use something other than ocilogon you open a persistant link that might not be closed. (try using ocilogon instead of eg ociplogon) close every connection with ocilogoff If you are running heavy traffic try to configure your NET8 Listener to work as MTS. This does not create and destroy a process every time you query the server, but delivers all incoming queries to some worlking-server-processes, starting and stopping them when needed, just like apache handles its childs. Increase the Global System Area by incresing the Shared Pool Size of your DB : this will inspire the db to consume more caching ram. On the other site check the ram consumption of oracle... maybe it swaps! If you want to limit your PHP-Scripts connections there is the problem with the synchronisation of the counter: sessions, a file, shared memory/IPC System V. It all doesn't sound very satisfing. Maybe you can place your db-phpscripts into a virtual host or another apache and configure that with a lower maxCLients directive, but this will simply lock out your visitors not giving you a chance to intercept the error message. Another Idea: can you limit the number of concurrent sessions created by one DB-User ? if possible you could assign your scripts a special user and therefore allowing connections with higher priority from e.g. your admin account > On Thu, Jan 25, 2001 at 08:22:07PM +0100, Matthias Kopolt wrote: > > Are you useing persistent connections (I had no real luck > with them)? > > > > How do you connect to your DB over Multi Threaded Server > (MTS) or Dedicated > > Server ? > > I am just using phplib for the dirty stuff :) So I don't know > exactly how > this works under the hood.. > > > I think Oracles NET8 Config has a Parameter to limit this. > > Check out the MasterIndex at > > Well it is limited to 200 connections right now, but I would > like to limit > that on the PHP side rather than on the Oracle side. Although I don't > exactly know why. It just seems right :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Limit number of persistent oci8-connections?
MaxClients inyour httpd.conf is a nice way to limit it. :) Karsten Dambekalns wrote: > > On Thu, Jan 25, 2001 at 08:22:07PM +0100, Matthias Kopolt wrote: > > Are you useing persistent connections (I had no real luck with them)? > > > > How do you connect to your DB over Multi Threaded Server (MTS) or Dedicated > > Server ? > > I am just using phplib for the dirty stuff :) So I don't know exactly how > this works under the hood.. > > > I think Oracles NET8 Config has a Parameter to limit this. > > Check out the MasterIndex at > > Well it is limited to 200 connections right now, but I would like to limit > that on the PHP side rather than on the Oracle side. Although I don't > exactly know why. It just seems right :) > > Karsten > -- > Why do we have to hide from the police, daddy? > Because we use emacs, son. They use vi. > - > mailto:[EMAIL PROTECTED] w³: http://www.k-fish.de/ > gpg: http://www.k-fish.de/mykeys.gpg > > >Part 1.2Type: application/pgp-signature -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Limit number of persistent oci8-connections?
On Thu, Jan 25, 2001 at 08:22:07PM +0100, Matthias Kopolt wrote: > Are you useing persistent connections (I had no real luck with them)? > > How do you connect to your DB over Multi Threaded Server (MTS) or Dedicated > Server ? I am just using phplib for the dirty stuff :) So I don't know exactly how this works under the hood.. > I think Oracles NET8 Config has a Parameter to limit this. > Check out the MasterIndex at Well it is limited to 200 connections right now, but I would like to limit that on the PHP side rather than on the Oracle side. Although I don't exactly know why. It just seems right :) Karsten -- Why do we have to hide from the police, daddy? Because we use emacs, son. They use vi. - mailto:[EMAIL PROTECTED] w³: http://www.k-fish.de/ gpg: http://www.k-fish.de/mykeys.gpg PGP signature
AW: [PHP-DB] Limit number of persistent oci8-connections?
Are you useing persistent connections (I had no real luck with them)? How do you connect to your DB over Multi Threaded Server (MTS) or Dedicated Server ? I think Oracles NET8 Config has a Parameter to limit this. Check out the MasterIndex at http://technet.oracle.com/doc/server.815/a68826/toc.htm mk > -Ursprüngliche Nachricht- > Von: Karsten Dambekalns [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 25. Januar 2001 20:09 > An: PHP Database > Betreff: [PHP-DB] Limit number of persistent oci8-connections? > > > Hi! > > I am using PHP to connect to an Oracle 8.1.5 database. > Everything works > fine, but the load on the oracle server is insanely high. So > I would like to > limit the number of connections. Is there something like the mysql > max_persistent_connections statement? > > TIA, > Karsten > > BTW: Has some used sqlrelay and would like to share the experience? > -- > Why do we have to hide from the police, daddy? > Because we use emacs, son. They use vi. > - > mailto:[EMAIL PROTECTED] w³: http://www.k-fish.de/ > gpg: http://www.k-fish.de/mykeys.gpg > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Limit number of persistent oci8-connections?
Hi! I am using PHP to connect to an Oracle 8.1.5 database. Everything works fine, but the load on the oracle server is insanely high. So I would like to limit the number of connections. Is there something like the mysql max_persistent_connections statement? TIA, Karsten BTW: Has some used sqlrelay and would like to share the experience? -- Why do we have to hide from the police, daddy? Because we use emacs, son. They use vi. - mailto:[EMAIL PROTECTED] w³: http://www.k-fish.de/ gpg: http://www.k-fish.de/mykeys.gpg PGP signature
