Hi!
We have that huge query against a mysql 4.1 (myisam) to retrieve rows.
The query is built dynamically using a loop, as we are searching in an
external database built to store a tree with the nested tree model.
When we do this search with a "normal" world, it's fine: the query is around
4 lines.
If we search with a very "frequent" word, we get a lot of hits, and the
query becomes very long (probably around 300 lines), and we get the errno24
Looking at the doc:
http://dev.mysql.com/doc/refman/4.1/en/not-enough-file-handles.html
so apparently I don't have enough file handlers. Ok, don't mind increasing
that.They say to modify the open_files_limit variable.
#open_files_limit
The number of files that the operating system allows mysqld to open. This is
the real value allowed by the system and might be different from the value
you gave using the --open-files-limit option to mysqld or mysqld_safe. The
value is 0 on systems where MySQL can't change the number of open files.
This variable was added in MySQL 3.23.20.
2 questions:
- any idea of the value I should put there? mysqld is running on a machine I
don't manage, what should I ask for?
- is it possible to modify this value in the conf file and to reload that
file without stopping/re starting the server?
Additionnally, any pointer on a doc explaining why and when is mysql opening
a new file?
Thanks,
melanie
_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger
7.5 today! http://join.msn.com/messenger/overview
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]