MySQL and Apache.....
 

Hey guys for a very High traffic server how are you tweaking MySQL and Apache (I am on a Redhat Server) Also are you caching PHP for better performance?

bump

bump

Very high?

For a VERY high traffic site you can't use PHP or MySQL.

-Ben

Well lets dsay 100-200k per day

I've been told PHP limits out at about 500k. That'd be page views
and not uniques.

MySQL isn't a real database server, it works, it's fast for small
stuff. However it doesn't do all the true database server stuff
that Oracal and others do.

It would all depend on the number of records and the queries. If
you design the database correctly and only hit it when it's
actually needed then you should be able to do it. If you are
running huge queries on tens of thousands of records on every
hit then MySQL will probably become the bottleneck before
anything else.

Spend a lot of time planning the code so as to reduce the amount
of DB work, records, and queries.

If you need to do a lot of work on a lot of hits then C and RAM are
the go.

-Ben