Re: 回复： PHP Performance/Scalability

Hello Torsten Some thoughts: 1. We are using a simple SQL Query in the code $data = $this->db->select('user_id,email') ->where(array('email' => $email_address)) ->order_by('user_id', 'DESC') ->limit(1) ->get('users') ->row_array(); 2. We are using mysqli 3. The SQL Query takes time in msec. And the Database is not a performance bottleneck 4. We use mostly images with <img src=""> 5. We have seen fpm outperform mod_php 6. The Java code accesses the same database (The database is on a seperate physical server). Also the queries are the same in Java as well PHP 7. I will try instrumenting the entire PHP code and see where the bottleneck is. Deepak "The greatness of a nation can be judged by the way its animals are treated - Mahatma Gandhi" +91 73500 12833 deicool@gmail.com Facebook: https://www.facebook.com/deicool LinkedIn: www.linkedin.com/in/deicool "Plant a Tree, Go Green" Make In India : http://www.makeinindia.com/home On Thu, Oct 28, 2021 at 11:23 AM Torsten Rosenberger <rosenberger@taoweb.at> wrote: > Hello Deepak > > I think PHP-FPM had heavily reduce the concurrency of PHP. > > PHP should immediately implement a API like WSGI/ASGI in python. It > > is very simple but very useful. > > > > ------------------ 原始邮件 ------------------ > > 发件人: "Deepak Goel" <deicool@gmail.com>; > > 发送时间: 2021年10月26日(星期二) 晚上11:15 > > 收件人: "Alex"<al-php@none.at>; > > 抄送: "php-general General List"<php-general@lists.php.net>;"Deepak > > Sharma"<deepak@techxp.tech>; > > 主题: Re: PHP Performance/Scalability > > > > Hi > > > > The code is fairly simple. It contains a few images and a simple SQL > > query (The same code in Java gives superb performance). We have an > > Apache Web Server in front of php as of now. And I will try out this > > (https://github.com/spiral/roadrunner). > > We are talking about a blackbox. > The code is simple ? > > How long take's > the sql query ? > What do you use to access the database PDO or mysqli ? > Y > ou wrote java is faster. Your java code access the same database ? > > You wrote a few images ? > Do you only show the images with <img src=""> > or are you converting them for thumbnails etc. > > A long time ago there was a great presentation from Rasmus about PHP > Performance. > > So a simple query on my Server's with mod_php and mysql > takes 0.0001 to 0.0008 seconds. If the simple query takes 0.01 Second > which looks fast but php have to wait for the DB. So there you can > loose factor 100 in the req/sec. > > Why are you using fpm and not the mod_php part in apache ? > OPcache is > active ? > > There are a lot of parameters we don't know. > > If you benchmark > your code with an easy microtime(true) call to see how long your script > takes. > If you store the data in a file when you run your benchmark you > can maybe see if a code part is waiting for the database or something > else. > So that the bottleneck ist not php. > > So i would go through the code > with microtime() an look what takes long and then go deepter. > > if the > code is heavy and the result dosen't change or a refresh after 5 min is > ok you can use the APCu cache or so on. > > If your code is super fast an still slow requests then you have to > strace the apache process to see if there is something miss configured. > > > So as a PHP developer we cann't accept that Java is faster :) > > BR/Torsten > > > Thanks. > > > > Deepak > > "The greatness of a nation can be judged by the way its animals are > > treated - Mahatma Gandhi" > > > > +91 73500 12833 > > deicool@gmail.com > > > > Facebook: https://www.facebook.com/deicool > > LinkedIn: www.linkedin.com/in/deicool > > > > "Plant a Tree, Go Green" > > > > Make In India : http://www.makeinindia.com/home > > > > > > On Tue, Oct 26, 2021 at 5:15 PM Alex <al-php@none.at> wrote: > > > Hi. > > > > > > On 26.10.21 11:53, Deepak Goel wrote: > > > > Hello > > > > > > > > I have a very simple PHP application which I develop on Apache- > > > Web-Server. However the application does > > > > not scale beyond 1500 concurrent users (150 requests/sec), even > > > though there is plenty of hardware > > > > available (CPU is getting utilized 15%, Memory is getting > > > utilized 15%). > > > > > > > > On a similar note, when I develop the same application in Java, > > > it scales to more than 6000 concurrent > > > > users (600 requests/sec) on the same hardware. > > > > > > > > Any pointers on how to address this scalability issue? > > > > > > The question is how "simple" is the PHP Code? > > > Maybe you can tune the Code or use another Server in front of PHP > > > FPM like haproxy, Caddy, nginx? > > > Maybe you can try to run 1�8+��E�� > > > ���n�https://github.com/spiral/roadrunner to > > > execute the PHP Code. > > > > > > Jm2c > > > > > > Regards > > > Alex > > > > > > > Thanks! > > > > > > > > Deepak > > > > "The greatness of a nation can be judged by the way its animals > > > are treated - Mahatma Gandhi" > > > > > > > > +91 73500 12833 > > > > deicool@gmail.com > > > > <mailto:deicool@gmail.com> > > > > > > > > Facebook: https://www.facebook.com/deicool < > > > https://www.facebook.com/deicool> > > > > LinkedIn: www.linkedin.com/in/deicool < > > > http://www.linkedin.com/in/deicool> > > > > > > > > "Plant a Tree, Go Green" > > > > > > > > Make In India : http://www.makeinindia.com/home > > > > < > > > http://www.makeinindia.com/home> > > > > >