MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Scheduled procedure causing too many open files error
Posted by: Rick James
Date: January 26, 2013 12:46AM

open_files_limit -- this is derived from a limit in the OS. Sometimes I have seen it at 1024; the OS was to blame.

table_open_cache and table_definition_cache are also worth checking.

However, I think the real problem is that you did not execute DEALLOCATE PREPARE.
http://dev.mysql.com/doc/refman/5.1/en/sql-syntax-prepared-statements.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Scheduled procedure causing too many open files error
2982
F Kemp
January 23, 2013 01:11PM
Re: Scheduled procedure causing too many open files error
1038
F Kemp
January 24, 2013 12:19PM
Re: Scheduled procedure causing too many open files error
895
Peter Brawley
January 24, 2013 12:46PM
Re: Scheduled procedure causing too many open files error
1096
F Kemp
January 24, 2013 01:36PM
Re: Scheduled procedure causing too many open files error
1140
Peter Brawley
January 24, 2013 02:11PM
Re: Scheduled procedure causing too many open files error
1018
Rick James
January 26, 2013 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.