Bug open more than 200 tables

[Michael Widenius]

>>>>> "Apnian" == Apnian S <white@stripped> writes:

Apnian> Dear Sir,
Apnian> We have a problem to open more than 200 tables. If we used client
Apnian> mysql and not using -A command, mysql Database will got a error can't
Apnian> open table. 
Apnian> Result we can't open some table on my database and we can't
Apnian> connect to mysql database. Help me please! 

Apnian> More Detail below:	
Apnian> ------------------------------------------------------------------------
Apnian> CPU intel PII300 Mhz
Apnian> RAM 512 MB
Apnian> HD 10 GB
Apnian> Mysql 3.21.33b
Apnian> Table more than 200 tables but they are not a big tables.
Apnian> ------------------------------------------------------------------------

Hi!

Add 'ulimit -n 1024' to safe_mysqld and restart MySQL.

Note that if the above doesn't work, then you should configure your OS 
to handle more open files!

Regards,
Monty