I have a web application running on an internal network for a client of ours. This question slightly overlaps my other active question about tuning a remote MySQL install. The issue is speed, the app is painfully slow. The app runs beautifully in another environment, so I have ruled out coding.
- Refreshing a particular page will take minutes (literally) to load.
- The MySQL server is on a separate box, but its a single 4ms hop from the web server.
- Its not a slow query, checking the processlist when waiting for the page to load shows no hung queries at all.
What is the next step? Could MySQL still be the problem? Maybe it is retrieving quickly but not returning the data fast enough? Where else can I look?
Thanks very much for any assistance.