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.
Last Comment
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
PHP
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
125K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.