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