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
If you can turn on the query log the amount of disk space it takes would be well worth troubleshooting the problem. Try and discern the last queries run on them, in order to help. Perhaps do this twice and you could check for consitency. How much disk space is in use on the drives related to it? R

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