Is Ajax SQL query depending on server ?
A PHP webpage is calling an AJAX script (querying DB) in pending.
I had to stop it because it was called 2 hours ago.
Whereas I tested it on another DigitalOcean server and it responded in 2 minutes.
The servers are similar (16GB RAM, 8CPU, etc..)
And the there is not much traffic.
I really don’t understand. The only differences I noticed are the servers are : MySQL versions and Ubuntu versions.
The 1st server : MySQL Server version: 5.5.52-0ubuntu0.14.04.1 (Ubuntu 14.04.2 LTS).
And the 2nd one : MySQL Server version: 5.7.13-0ubuntu0.16.04.2 (Ubuntu 16.04 LTS).
The tables got the same indexes on the same tables that are queried.
Still, I don’t get where is the problem ?
Maybe from the SQL query ?
(P.S. : the SQL query works on our 2nd server)