Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?

Chris Drake schrieb:
I'm expanding, and adding extra web servers to handle my load. My Apache/mod_perl environment maintains a new connection for each process, and these processes seem to chew up a lot of server resources.

What is the normal acceptable way to maintain large numbers of simultaneous connections?

I have enabled "shared server" support in my database, but I suspect it's not being utilized, since I only get a few hundred connections before hitting the "too many connections" error.

Am I supposed to be passing a switch in with my initical "connection" requests to request a shared (instead of dedicated) connection maybe ?

Thanks all
- Chris.



Actually, this has nothing to with Perl, at least my answer :-}

Using shared server means additional CPU overhead per call. If your clients are "lazy", meaning they produce a lot of idle time, it may help. If the more sluggish response of the DB connection doues not disturb, use it (Orace 9iR2 or newer).

To find out, if your sessions are shared: V$session is your friend - the column SERVER is NULL on shared connections.

To force shared connections you should force them in tnsnames.ora by setting (SERVER=SHARED).

HTH
Johannes Gritsch

Relevant Pages

  • Re: Do I want an ACK in my high-level protocol when using TCP?
    ...   for { ... have those 2 connections to B at once. ... application A will hold back sending requests ... other network I/O in the application. ...
    (comp.unix.programmer)
  • Re: Socket Programming
    ... * Single threaded application that multiplexes concurrent connections ... Some requests may be served within millisecond time scale. ... On a single cpu system, ... do is keep some rolling counter of number of connections accepted in ...
    (comp.lang.lisp)
  • Re: IOCP Across Threads - Error 995
    ... The problem is that when a thread exits with outstanding overlapped ... send requests in progress all of those requests are cancelled - See: ... I have created an additional thread that initiates connections to the ... I placed a Sleepat the end of the outgoing connection ...
    (microsoft.public.win32.programmer.networks)
  • zombies with AMD64 and 32 bit userspace with 2.6
    ... the test is a simple forking proxy that receives connections from one ... machine (running apache benchmark) and forwards them to anothr machine ... to do a test with more then about 30,000 requests in it the box starts to ... the smaller tests leave no zombies at all and can be run multiple times ...
    (Linux-Kernel)
  • Re: Network Firewall/Routing Solution
    ... >> firewall combo boxes that linksys sells, and I really don't want to run ... >> not working properly at all with multiple network cards. ... >> like Unicode and header information for http requests, ... >> non-pasv connections. ...
    (comp.security.firewalls)