Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

up vote 0 down vote accepted

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

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_open-files-limit

This has solved this issue.

share|improve this answer

Your Answer

 
discard

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.