MySQL Forums
Forum List  »  Newbie

Re: MySQL frequent communication link error
Posted by: Sai Zhang
Date: August 19, 2015 07:47PM

Dear all,
Additional information is that:
I am using JDBC(Connector/J) to connect to MySQL, both MySQL and JDBC are the latest version.

My query is in this format

conn.
try{

setAutoCommit(false)
Select..
insert...
select...
delete
commit()
catch(Exception ex){
rollback()
}
finally{
conn.close()
}

I observed from MySQL workbench
Traffic 2MB/s
Selects per Second 6K~10K
InnoDB Writes per Second 1K~2K

Key Efficiency: 88.9%
InnoDB Buffer Usage 20%

Connections: 374

Thank you very much!

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL frequent communication link error
August 19, 2015 07:47PM


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.