hi, is anybody using federated tables in mysql?
sorry, I already wrote a msg in thy mysql forums, got no help yet.. problem is that I cannot connect to the remote tables, I found a (verified) bug (but not yet assigned to anybody) that seems to cause the problem I'm having: http://bugs.mysql.com/bug.php?id=17049) federated storage engine does not transparently reconnect Well, thats just that what I needed, I wanna set up a new frontend (where an additional frontend and backend exists) to use a part of the existing data stored in a mysql-db. WIthout changing some queries.. Now I sometimes can connect, sometimes not, sometimes I get the error the database doesnt exist, sometimes just a 'closed connection'. Sometimes I see long-running processes where mysql copies data in tmp-tables (strange, there is enough cache available, but they die at all) On a remote-db in my local network it was working (slowly but it worked :-p Does anybody have the same problems? -- Sebastian Mork <[EMAIL PROTECTED]> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231701 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
