Re[4]: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-28 Thread Peter Zaitsev
Hello Sam, Thursday, March 28, 2002, 10:21:39 AM, you wrote: SI> > The good solution for this would be to put OOPS behind of apache. SI> What is OOPS ? The OOPS is squid-like PROXY application which mostly used as WEB accelerator (server side proxy). The main idea of using it with PHP/MYSQL

Re[2]: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-11 Thread Peter Zaitsev
Hello Michael, Monday, March 11, 2002, 3:38:28 PM, you wrote: I had a close problem once - then having many active connections (and so threads) mysql speed may degrade a lot because of scheduling and convergency problem. This does not explain the mysql lock itself, but may be the reason (i.e t

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-11 Thread Michael Widenius
Hi! Sam> We have a very high volume site (3 million page views a day) that's run Sam> on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with Sam> persistent connections. Each MySQL serves 8 web servers & is supposed to Sam> act as a failover machine for the other group of 8 w

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-07 Thread Sam Iam
On Thursday, March 7, 2002, at 12:38 AM, Jeremy Zawodny wrote: > Are the Web servers doing write operations on the database, or > read-only? read-only now. Can you talk a bit about how Yahoo Finance does it as far as # of web servers to MySQL servers ? Apache & PHP tuning ? - Sam.

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-07 Thread Jeremy Zawodny
On Wed, Mar 06, 2002 at 11:06:18AM -0800, Sam Iam wrote: > > We have a very high volume site (3 million page views a day) that's > run on 16 Apache / PHP web servers & 2 MySQL servers. We are using > PHP with persistent connections. Each MySQL serves 8 web servers & > is supposed to act as a failo

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread Steven Roussey
Also, I forgot these questions: - What is Apache's http.conf value of MinSpareServers? - What is Apache's http.conf value of MaxSpareServers? Steven Roussey Network54.com sql,query - Before posting, please check: http://w

RE: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread Dan Vande More
: MySQL List Subject: RH 7.2 connections problems w 16 web servers to 2 MySQL servers We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers &

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread James Housley
Sam Iam wrote: > > We have a very high volume site (3 million page views a day) that's run > on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with > persistent connections. Each MySQL serves 8 web servers & is supposed to > act as a failover machine for the other group of 8 web

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread Steven Roussey
> We pay for MySQL support but haven't had much help from them. You could pay me, I need work... :) Seriously... > We have a very high volume site (3 million page views a day) that's run > on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with > persistent connections. Each My

RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread Sam Iam
We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers & is supposed to act as a failover machine for the other group of 8 web servers. The failover