I am getting "too many open files" error when I try to insert records in a partitioned table.
mysql> insert into test.ox_data_geo_span select * from vserv.ox_data_geo_span limit 100;
ERROR 1016 (HY000): Can't open file: './test/ox_data_geo_span.frm' (errno: 24)
OS error code 24: Too many open files
If I execute "flush tables" then I am able to insert data into some other table. But I need a way to insert into many tables at a time.