MySQL and Apache..... - GoFuckYourself.com

RainMailer · 04-15-2004, 05:50 PM

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?

RainMailer · 04-15-2004, 06:11 PM

RainMailer · 04-15-2004, 06:21 PM

mryellow · 04-15-2004, 06:23 PM

Very high?

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

-Ben

RainMailer · 04-15-2004, 06:25 PM

Quote:

Originally posted by mryellow
Very high?

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

-Ben

Well lets dsay 100-200k per day

mryellow · 04-15-2004, 06:55 PM

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

04-15-2004, 05:50 PM	#1
RainMailer Confirmed User Join Date: Feb 2003 Location: Portland Posts: 826	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? __________________ harbinc at gmail dot com

04-15-2004, 06:11 PM	#2
RainMailer Confirmed User Join Date: Feb 2003 Location: Portland Posts: 826	bump __________________ harbinc at gmail dot com

04-15-2004, 06:21 PM	#3
RainMailer Confirmed User Join Date: Feb 2003 Location: Portland Posts: 826	bump __________________ harbinc at gmail dot com

04-15-2004, 06:23 PM	#4
mryellow Confirmed User Industry Role: Join Date: May 2001 Location: Australia Posts: 934	Very high? For a VERY high traffic site you can't use PHP or MySQL. -Ben __________________ Cyberwurx Hosting After trying 5 different hosts, I found the best. Since 1997 I've had 2 hours of downtime. Fast support, great techs, no hype, no gimmicks. <- I in no way endorse whatever just got stuck on the left of my post.

04-15-2004, 06:55 PM	#6
mryellow Confirmed User Industry Role: Join Date: May 2001 Location: Australia Posts: 934	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 __________________ Cyberwurx Hosting After trying 5 different hosts, I found the best. Since 1997 I've had 2 hours of downtime. Fast support, great techs, no hype, no gimmicks. <- I in no way endorse whatever just got stuck on the left of my post.