[Solved] Database for realtime web application (Low latency response) [closed]

Question

You’ve given very little in the way of details. I’ll provide an answer here that’s as simple as possible:

Use SSD

If you’re not already using SSD that’s probably the issue. Conventional hard drives are terrible at random I/O and will bog down on occasion when too busy to service requests in a timely manner. MySQL seems to fly into an absolute panic when out of I/O cycles and performance falls off a cliff.

Accepted Answer

You’ve given very little in the way of details. I’ll provide an answer here that’s as simple as possible:

Use SSD

If you’re not already using SSD that’s probably the issue. Conventional hard drives are terrible at random I/O and will bog down on occasion when too busy to service requests in a timely manner. MySQL seems to fly into an absolute panic when out of I/O cycles and performance falls off a cliff.