Avatar of Ali Kayahan
Ali KayahanFlag for Türkiye

asked on 

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.

PHPWeb Servers

Avatar of undefined
Last Comment
Ali Kayahan
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

I consider myself a non-ignorant software developer and I do not really understand the origin of this question.

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.
Avatar of Ali Kayahan
Ali Kayahan
Flag of Türkiye image

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
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Blurred text
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.
See Pricing Options
Start Free Trial
Avatar of Ali Kayahan
Ali Kayahan
Flag of Türkiye image

ASKER

Thanks Ray i ll have a look at them .
Avatar of Ali Kayahan
Ali Kayahan
Flag of Türkiye image

ASKER

accidentally i chose close question , Ray's answer ID: 35760442 is the solution.
Avatar of Ali Kayahan
Ali Kayahan
Flag of Türkiye image

ASKER

accidentally i chose close question , Ray's answer ID: 35760442 is the solution.
PHP
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
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo