MySQL Forums
Forum List  »  Federated Storage Engine

FEDERATED out of connections
Posted by: Martin Wilmes
Date: April 13, 2015 06:45AM

I have created about 150 tables with engine FEDERATED. After a while of using about 30 of them I get the error "ERROR 1429 (HY000) at line 3: Unable to connect to foreign data source: Can_t create a new thread (errno 11); ..."

Is there any way of checking how many different connections are open except from looking at the remote server?

Is there any way of flushing the connections except from dropping all the tables or killing the connections at the remote database?

Options: ReplyQuote

Written By
FEDERATED out of connections
April 13, 2015 06:45AM

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.