mysql query slow on ReadAheadInputStream.fill

I have a web app using tomcat, hibernate and mysql. a simple query is taking enormous amount of time (i.e. 30 sec). with profiling, I discovered that the time is chewed during

com.mysql.jdbc.util.ReadAheadInputStream.fill, which calls java.net.SocketInputStream.read. The profiler does not go deeper than that.

however, when doing the same query directly in a Windows prompt, the return is instant, so the problem can not be with mysql tuning.

what can be wrong with the mysql driver which causes this delay?Start Free Trial