Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
which engine you are using ? Is it MyISAM ? How many partitions are there in table? – Abdul Manaf Jun 7 '12 at 5:01
up vote 1 down vote accepted

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

This has solved this issue.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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