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
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.
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
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
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
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
> 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