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)
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
