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: 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 web

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

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 failover

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.

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

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 MySQL

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 Dan Vande More
To: 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 is supposed

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: