Re: PHP / MySQL Massively different speed differences between servers

[Mila Craig]

Jeremy James Wrote:
-------------------------------------------------------
> Hi there
>
> Really stuck on this one
>
> I've got five different windows servers all
> running PHP 5.6.40, on mysql 5.6 here
>
> all with the same settings in php.ini
> all with the same OI
> all with the same RAM
> all with the same mysql configs
> all on IIS for web server
>
> two servers massively fast
> one massively slow
> the other two relatively slow
>
> when running the exact same PHP script / mysql
> database query
>
> how can that be possible?
>
> how can there be such massive differences in php /
> mysql performance?
>
> what possible setting am I missing?
>
> literally 1 minute loading a report that on
> another server is loaded within 4 seconds
>
> another server loads it in about 15 seconds
> another 40 seconds
> another within 5 seconds
>
> all the same PHP / Mysql setups as far as I can
> tell (copy paste php.ini, same versions and same
> mysql configs)
>
> what could be making such radically different
> performance issues here?

I had huge server issues in the past when running different SQL queries and the issue was background processes and other loads on the server - all 5 of your servers definitely aren't running anything else?