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.

From MySQL documentation:

Max value limit for open_files_limit is 65536 and table_open_cache is 524288.

When I applied max limit, mysql server started but with following warnings in error log:

2013-09-01 11:34:42 57231 [Warning] Buffered warning: Could not increase number of max_open_files to more than 65536 (request: 1048687)

2013-09-01 11:34:42 57231 [Warning] Buffered warning: Changed limits: table_cache: 32713 (requested 524288)

I see that max-limit for open_files_limit is less than table_open_cache. I feel this is strange and open_file_limit should be always greater than table_open_cache.

Neverthless, I set open_file_limit to larger than 65536 and it worked.

I am now wondering, how these are related? Is there any mistake in MySQL documentation?

p.s. I modified /etc/security/limits.conf on way as for such high limits.

share|improve this question
add comment

Your Answer


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

Browse other questions tagged or ask your own question.