List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 29 1999 7:46pm
Subject:Bug open more than 200 tables
View as plain text  
>>>>> "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
Thread
Bug open more than 200 tablesApnian S.29 Sep
  • Re: Bug open more than 200 tablesBob Kline29 Sep
    • Re: Bug open more than 200 tablesApnian S.29 Sep
      • Re: Bug open more than 200 tablesBob Kline29 Sep
        • Re: Bug open more than 200 tablesApnian S.29 Sep
          • Re: Bug open more than 200 tablesBob Kline29 Sep
            • Re: Bug open more than 200 tablesApnian S.30 Sep
          • Re: Bug open more than 200 tablesMichael Widenius29 Sep
          • Re: Bug open more than 200 tablesTonu Samuel30 Sep
            • Re: Bug open more than 200 tablesApnian S.30 Sep
              • Re: Bug open more than 200 tablesMichael Widenius30 Sep
  • Re: Bug open more than 200 tablesIngo Oellers29 Sep
  • Re: Bug open more than 200 tables, the secondIngo Oellers29 Sep
  • Bug open more than 200 tablesMichael Widenius29 Sep
    • Re: Bug open more than 200 tablesApnian S.30 Sep