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

2002-03-27 Thread Sam Iam
The good solution for this would be to put OOPS behind of apache. What is OOPS ? Is it like SQL Relay ? Others have said that we should be using a connection pooler that it's a PHP/Apache config problem that we're running into. We may also move to BSD from Redhat. P.S Are you using

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: Can you skip ORDER BY get rows back in inserted order ?

2002-03-05 Thread Sam Iam
Is there some way that I can avoid doing an ORDER BY and get my rows back ordered by album_id, rank they way I inserted them ? No That is the nature of relational databases Is this because the index cache in ram may not be loaded in order ? You might want to consider adding an