MySQL Forums
Forum List  »  Connector/JDBC and Java

Re: Java and mysql high concurrency bottlenecks solutions
Posted by: Frwa Onto
Date: June 29, 2017 01:32PM

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);
}

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.