RE: [PHP] [JOB OFFER] contractor wanted for PHP project!

AOLserver offers connection pooling to Oracle built in. There are several people who run PHP with AOLserver and I believe I once saw a FAQ on how to install. AOLserver comes with a powerful Tcl interface as well and there is a great Tcl-based library availble for free from arsdigita.com. Seeing your numbers, you might want to evaluate to switch to AOLserver (now open source and free to use too). I'd prefer learning a new server then implementing connection pooling myself. ;-) Cheers Marc > -----Original Message----- > From: Adam Powell [SMTP:adam@powlex.com] > Sent: Tuesday, September 26, 2000 4:24 PM > To: cameron@cameron.co.nz; mysql; php-general@lists.php.net > Subject: Re: [PHP] [JOB OFFER] contractor wanted for PHP project! > > > Hi there, thanks for the reply. > > We originally did start with mySQL last November, and it worked great. In > fact I did not want to move to Oracle at all, however there were some > issues > with mySQL that meant we could not use it any more... and if these were > sorted out we would love to change back :) > > When I say 300 connections, its 300 connections per web server and we have > around 24 of them... our first problem was that we had problems getting > mySQL to manage more than 1000 connections due to the number of open files > in a 32 bit system. We changed this max from 1024 to 2048, but then ran > into some other linux kernel based problems that gave us really bad > performance. > > The biggest problem however was table locking. We currently do around > 6500 > sql executions per second at peak, on tables with over 3 million rows in, > and because mySQL uses table locking the entire database would just hit a > deadlock, and that was in February, so that was at around 1,000 executions > per second. We had a table called market_stock that would hold all the > items a person had in their shop, then we had to split this into 8 sub > tables market_stock_1 to 8. This wasnt the perfect scenario because of > the > increased maintenace, and the lack of scalability. We were told that > Oracle > handled tables that did UPDATEs and SELECTs at the same times better due > to > the fact it used row locking. > > We are currently offloading a lot of the work onto mySQL also, all the > stats, chat boards, and neomessages on the site are handled by two dual > 700s > running mysql 3.23. Each page connects to like 4 database machines now, > its > getting a bit ridiculous :) > > Anyway, so the aim is to build a connection pooling into the PHP OCI8 > module > to reduce the overhead generated by all these connections into Oracle, so > if > anybody has any idea let us know :) > > Thanks, > Adam Powell, > Neopets.Com > > ----- Original Message ----- > From: "Martin Cameron" <cameron@cameron.co.nz> > To: "Adam Powell" <adam@powlex.com>; "mysql" > <mysql@lists.mysql.com> > Sent: Tuesday, September 26, 2000 1:37 AM > Subject: Re: [PHP] [JOB OFFER] contractor wanted for PHP project! > > > > Hi Adam > > > > You need to give a bit more detail. > > > > Is the database application that you are running, dependent on > "transactions". > > If not, are you hell-bent on sticking with Oracle. > > > > One of the claims to fame of MySQL is its speed. You talk about > persistent > > connections of 300. MySQL comes stock standard set for 100. > > > > Before embarking on getting an Oracle programmer on board, I would > consider > > whether or not you have the right tools for the job. If the pages you > are > > serving are a regurgitation of data from the database, then you are > probably > > not using the right engine. My query, if I were you, would not be to > find > an > > Oracle programmer, but to find someone who can deal to your real problem > - > > delivery of data from a database to web pages at the rate demanded. I > suspect > > that at the end of the day you will opt for someone who can convert your > > current database over to MySQL - only because it appears that speed is > your > > problem abd MySQL delivers results much faster than any other database > engine - > > so I am led to believe. > > > > If you want some real direction from this mailing list as to the > solution > to > > your problem, I suggest that you post a few more details about the data > being > > served up, the hardware that you have delivering it, and the supporting > > programs around it. You will find this list more than accommodating in > steering > > you in the right direction. > > > > Regards > > Martin Cameron > > > > Adam Powell wrote: > > > > > Hi, we are looking for a PHP contractor (possibly not just one) to > help > us > > > with a current project. > > > > > > We have a large oracle database, and we are using OCI8 to connect from > > > PHPv4.0.0, and our database is dying due to the sheer number of > connections. > > > The current OCI module does not have connection pooling, so each of > our > > > apache servers is making 300 persistant connections to Oracle. The > site > in > > > question does over 50 million pageviews a day, and connections are > proving > > > to be a MAJOR bottleneck in our growth. > > > > > > Basically, we need people who have experience in this area to help us > create > > > a OCI8/apache connection pooling module. If anybody is interested > please > > > get in touch. We are located in Glendale, LA, and will pay for > > > travel/accomodation expenses plus generous compensation. > > > > > > Thanks a lot, > > > Adam Powell, > > > Neopets.Com > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-general-help@lists.php.net > > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > > > -- > > --------------------------------------------------------------------- > > Please check "N > > ‚kÆM ¥d.Ólhttp://www.mysql.com/documentation/manual.php" before > > posting. To request this thread, e-mail > mysql-thread51653@lists.mysql.com > > > > To unsubscribe, send a message to: > > <mysql-unsubscribe-noirotr=forges-courcelles.fr@lists.mysql.com> > > > > If you have a broken mail client that cannot send a message to > > the above address (Microsoft Outlook), you can use: > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >