Re: INFORMATION_SCHEMA table gets locked
Posted by: Tushar Agarwal
Date: September 18, 2015 10:38AM

Hi Gabriela,
Thanks for replying. We are using MySql Connector 6.9.x
The server details are as :
+-------------------------+-----------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------+
| innodb_version | 5.5.37 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.37-0ubuntu0.12.04.1-log |
| version_comment | (Ubuntu) |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+-----------------------------+

We don't query the INFORMATION_SCHEMA directly. We just use stored procs in our .NET code. In .NET we are using Microsoft Enterprise Library 5.1 for querying the DB.
In case we convert the Stored Procs to String / Inline queries, it works perfectly fine.

We had been using the same architecture with SQL Server for years and never faced the issue.

Please let me know in case you need any more help.

Regards,
Tushar

Options: ReplyQuote


Subject
Written By
Posted
Re: INFORMATION_SCHEMA table gets locked
September 18, 2015 10:38AM


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.