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!
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.