Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a strange behaviour in my application

The application normally starts in 30 seconds but sometimes it takes 7 minutes to start.

It starts in 30 minutes again only when I restart mysql.

Mysql is installed using

apt-get install mysql-server

and I did not change any of its default settings.

Can anyone please just guide me where to look and what should I suspect here?

Thnx

share|improve this question
    
Have you shut down things cleanly? –  Ed Heal Sep 8 '11 at 10:47
1  
You don't seem to accept answers, so why should we bother helping you? –  opyate Sep 8 '11 at 10:52
add comment

migrated from stackoverflow.com Sep 8 '11 at 16:44

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 0 down vote accepted

I believe this might be something to do with uncommited transactions. As I have had something similar to this.

Another option might to look at any dead locking happening.

Im assuming when the application starts it immediately accesses the database.

First will usually be successful, then because of uncommited transactions, the second and subsequent starts of the Application will result in it hanging for a period of time.

share|improve this answer
add comment

Get your Tomcat's PID with jps and check what your threads do (or waiting for) with jstack.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.