Is Ajax SQL query depending on server ?

October 13, 2016 45 views
MySQL Server Optimization Ubuntu

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)

Be the first one to answer this question.