Each Connection sends many queries to MySQL
Posted by: Richie Chauhan
Date: September 29, 2004 12:53PM

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.


Options: ReplyQuote


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.