Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.9.7
-
None
-
centos7
Description
For about 2 days now, most queries on the information_schema tables do not bring any results within 10 minutes. Queries from Nagios sometimes hang longer than 6 hours in the process list.
The queries from Nagios usually run within one second.
Even the query "select * from information_schema.key_column_usage limit 1;" does not bring any result within 10 minutes.
The only change made on the database server is the installation of the Sentinel virus scanner. But even temporarily disabling Sentinel did not bring any improvement in the runtime of the above query.
What can I do to find out why the above query is running so long?
Hello,
I think I figured out why the queries on the information_schema took so long. We had tables with the FederatedX storage engine pointing to an external server that could no longer be accessed through the firewall.
After I deleted these tables, the queries are running fast again.
It's a pity that in such a case there is no error message to indicate the problem.
Is it possible to set a timeout in the FederatedX engine if the remote database cannot be reached?
With kind regards
Karsten