Bug #76565 [Opn]: Very slow DB queries

Edit report at https://bugs.php.net/bug.php?id=76565&edit=1 ID: 76565 User updated by: gilperon at gmail dot com Reported by: gilperon at gmail dot com Summary: Very slow DB queries Status: Open Type: Bug Package: MySQL related Operating System: CENTOS 7 PHP Version: 7.2.7 Block user comment: N Private report: N New Comment: I can run the test using different php version on the same machine if you want. BUT I dont know how to install php 5.4.16 on my centos and later remove it to install 7.2. I tried many methods online and I couldnt find an updated one that works. Any suggestion/link where I can try that? Previous Comments: ------------------------------------------------------------------------ [2018-07-03 23:06:05] yohgaki@php.net You cannot get reliable results from virtual environment. In general, benchmarks should be taken by using dedicated machine. At least, you should execute benchmark on the same virtual machine. i.e. Install php 5.4 and 7.2 on the same machine and take benchmark. Make sure you use the same disk/database also, and see what you get. ------------------------------------------------------------------------ [2018-07-03 13:53:14] gilperon at gmail dot com cmb@php.net I think my problem is similar to the one you referenced to. That other guys looks having the same problem as me BUT I am running a CENTOS 7 server (intead of linux). My Centos is 2GB RAM and 2vCPU (AMD EPYC). ------------------------------------------------------------------------ [2018-07-03 11:44:48] cmb@php.net Is this a duplicate of bug #76442? ------------------------------------------------------------------------ [2018-07-03 09:09:57] celestinoxp at hotmail dot com I think you should show more details, like the mysql configuration file. In addition, the details of your system are also essential, cpu, ram. ------------------------------------------------------------------------ [2018-07-03 04:47:15] remi@php.net I cannot reproduce such difference. You seems to have some very big table / row, as I have to increase the loop to 10000 to have 1/2 second, on a small RHEL-7.5 VM PHP Version 5.4.16 en 0.55 (using php-mysql and libmysqlclient) PHP Version 5.4.16 en 0.65 (using php-mysqlnd) PHP Version 5.5.38 en 0.66 PHP Version 5.6.36 en 0.65 PHP Version 7.0.30 en 0,67 PHP Version 7.1.19 en 0,67 PHP Version 7.2.7 en 0,69 PHP Version 7.3.0alpha2 en 0.55 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=76565 -- Edit this bug report at https://bugs.php.net/bug.php?id=76565&edit=1