show keys prior to every query
Posted by: andre erdna
Date: June 05, 2009 05:18AM

Hi there,

I am using mysql-connector-java-5.1.7 to access a large database (mysql 5.1.24 with approx. 500GB).
Every time I perform executeQuery(String query) on my Statement object, a

SHOW KEYS FROM `tablename` FROM `schema_name`,

query appears, which seems to be pretty demanding, as it takes several minutes to finish.

This of course drops the database performance to an unacceptable degree. I do not get the resultSet back until the query finishes.
I am wondering why it is executed and if there is a way to disable it or to do a workaround.

I am not using prepared statements...

Happy for any suggestions!

Options: ReplyQuote


Subject
Written By
Posted
show keys prior to every query
June 05, 2009 05:18AM


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.