Java never recieves data from mysql

Hi Lately i have been having some trouble with connecting to mysql from java. Mostly everything works fine. But sometimes开发者_运维百科, the query takes forever, it is a pretty hard query and it should take about 10s. But it takes minutes without java recieveing the result from mysql. When i look in the processlist of mysql, it is sending data and blocking al other queries on that table. It continues after the 180s i have set in querytimeout, and even after i kill the javaprocess, the query in mysql is running and i have to kill that aswell.

You can't do anything meaningful with that much data.

If the data is meant to be displayed consider implementing paging. Otherwise, if it's for computational purposes then maybe it should be done in some stored procedure/function. Nobody likes them, but they can be really useful for optimizations.