certain web ui URLs slow after upgrade to 7.1 AND move to MySQL db

I recently upgraded us from 7.0.something to 7.1 then moved our db from the internal HSQL to MySQL.  Now I'm getting reports that certain URLs are slow - very slow - to render.  URLs that look like:

http://teamcity.oggifinogi.com/viewType.html?buildTypeId=bt29
http://teamcity.oggifinogi.com/viewType.html?buildTypeId=bt31

I suspectd the problem is the DB move as it was internal and is now on an RDS instance in AWS.  The TC server is on a machine in our colo so not "close" to the DB server now.

How can I ascertain what's causing the slowdown?

TIA,
Jerry

3 comments
Comment actions Permalink

I decided to try moving the db from RDS to a MySQL instance running on the TC server and it's back to being snappy again.

0
Comment actions Permalink

Hi Jerry,

After this change, you confirm your server's performance is comeback normal?
Actually, I have the same problem than you.

Is there some implications to change the database format? any cons?

0
Comment actions Permalink

Yes, after moving the db to a MySQL instance running on the same machine as the TC server, perf is back to "normal".  Or at least the complaints stopped :)  I suspect the issue was just latency between our colo and AWS.

0

Please sign in to leave a comment.