MySQL Forums
Forum List  »  PHP

Re: PHP / MySQL Massively different speed differences between servers
Posted by: Mila Craig
Date: March 16, 2020 02:36AM

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?

Options: ReplyQuote

Written By
Re: PHP / MySQL Massively different speed differences between servers
March 16, 2020 02:36AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.