Performance drop after 5 days running web applicat

Question

I've developed a web application using the following tech stack:

• Java
• Mysql
• Scala
• Play Framework
• DavMail integration (for calender and exchange server)
• Javamail
• Akka actors

On the first days, the application runs smoothly and without lags. But after 5 days or so, the application gets really slow! And now I have no clue how to profile this, since I have huge dependencies and it's hard to reproduce this kind of thing. I have looked into the memory and it seems that everything its okay.

Any pointers on the matter?

Answer 1

Try using VisualVM - you can monitor gc behaviour, memory usage, heap, threads, cpu usage etc. You can use it to connect to a remote VM.

Answer 2

To eliminate your database you can monitor slow queries (and/or queries that are not using an index) using the slow query log see: http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html

I would hazard a guess that you have a missing index, and it has only become apparent as your data volumes have increased.