All about Php & Mysql optimization / benchmark
Hi Experts ;
I built an ebay clone with ZendFrameWork & MYSQL that will work under heavy load . I serve this website from a cloud vps that has ;
Cpu : 6Ghz Dedicated (Can increase up to 10.2 Ghz)
Ram : 3760Mb (Can increase up to 6392Mb)
Web Server : Apache 2.x
My current topology without any optimization is simple ; i have a vps for web server and a vps for database server.
What i ask for ; what are your topologies , optimization techniques and benchmark tools for such a web site.
P.S : In some cases there are 4+ depth nested ajax request over 2000 records.And there are 1m + product records , 10.000 + simultaneous connections.
I built an ebay clone with ZendFrameWork & MYSQL that will work under heavy load . I serve this website from a cloud vps that has ;
Cpu : 6Ghz Dedicated (Can increase up to 10.2 Ghz)
Ram : 3760Mb (Can increase up to 6392Mb)
Web Server : Apache 2.x
My current topology without any optimization is simple ; i have a vps for web server and a vps for database server.
What i ask for ; what are your topologies , optimization techniques and benchmark tools for such a web site.
P.S : In some cases there are 4+ depth nested ajax request over 2000 records.And there are 1m + product records , 10.000 + simultaneous connections.
ASKER
Ray thanks for your reply ,my question is ; what are your optimization techniques for mysql (like memcached , sphinx , lucene) and for apache (like load balancing , server farms ect..) and which tools should i use to benchmark those enhancements .
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks Ray i ll have a look at them .
ASKER
accidentally i chose close question , Ray's answer ID: 35760442 is the solution.
ASKER
accidentally i chose close question , Ray's answer ID: 35760442 is the solution.
App performance is like Ohm's Law. There are three co-dependent variables: the system under test, the workload and the resultant performance. Fix any two variables and the third is determined. Building on that foundation, here is how I optimize...
1. All performance problems appear in the I/O subsystem. In web apps, this is the data base. Use normalized table structures (hire a DBA) and index all the columns used in a WHERE, JOIN, ORDER BY, GROUP BY clauses, etc.
2. Make a few Google searches for PHP performance and pay attention to the detailed responses.
If you are not having performance problems now we cannot really help you correct performance problems. If you can show us more about your performance problems, we can help you find the specific "viagra" you need for your web site.