Re: Java and mysql high concurrency bottlenecks solutions

[Frwa Onto]

Dear Silva,
Currently on the java side I am just doing connection pooling how many concurrent connection should I allow to be on the safe side. I never really implemented thread pool for the socket. I just implemented multithread socket. So I dont really impose any control on the thread of the socket. I think I will leave it like you said lets go with this first and monitor. Below is my code snippet of the socket thread.

try
{
final ServerSocket serverSocketConn = new ServerSocket(8888);
while (true){
try {
Socket socketConn1 = serverSocketConn.accept();
new Thread(new ConnectionHandler(socketConn1)).start();
}
catch(Exception e){
e.printStackTrace(System.out);
}
}
}
catch (Exception e) {
e.printStackTrace(System.out);
}