Each Connection sends many queries to MySQL
I turned on Logging on MySQL to debug some problems and found that every connection that is created via connector/J causes a number of queries to be sent to the server.
Example Logs for Connection number 424.
424 Connect biz_1@localhost on biz_1
424 Init DB biz_1
424 Query select round('inf'), round('-inf'), round('nan')
424 Query SHOW VARIABLES
424 Query SET autocommit=1
424 Query SELECT myColumn FROM MyTable ****THIS IS THE ONLY QUERY THAT I ISSUED****
424 Quit
This raises a number of questions.
1) Is this normal behaviour?
2) Is there a way to control this behaviour?
3) Do these queries translate to a performance degradation?
Thanks for any info.
Subject
Written By
Posted
Each Connection sends many queries to MySQL
September 29, 2004 12:53PM
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.