Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Cannot Reproduce
-
None
-
None
-
None
Description
We use the FederatedX engine exclusively for SELECTs.
Local (MyISAM) tables are populated with INSERT INTO ... SELECT FROM <Federated table>. Aggregation and other querying is done against the local tables.
Memory is almost always being leaked by the SELECTs. Successive queries usually cause unallocated RAM to be consumed, instead of reusing that which had been already allocated by mysqld. The box eventually starts to page, at which point the instance needs to be restarted.