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)

perror 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.

  • which engine you are using ? Is it MyISAM ? How many partitions are there in table? Jun 7, 2012 at 5:01

1 Answer 1


Restarted mysqld after increasing open file limit to 40000 in my.cnf


This has solved this issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.