Re: Bug open more than 200 tables

[Michael Widenius]

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

Apnian> Dear Sir,
Apnian>         This is my error after run mysql client.

Apnian> Didn't find any fields in table 'itresources_co_th'
Apnian> Didn't find any fields in table 'itsthai_co_th'
Apnian> Didn't find any fields in table 'jancobkk_com'
Apnian> Didn't find any fields in table 'jasper_co_th'
Apnian> Didn't find any fields in table 'jbathailand_com'
Apnian> Didn't find any fields in table 'jcthailand_co_th'
Apnian> Didn't find any fields in table 'jetfresh_co_th'
Apnian> ..................

Apnian> Note: I think that I don not have 200+ connections at once. from
Apnian> mysqladmin status command result as below:

Apnian> Uptime: 97390  Running threads: 1  Questions: 532996  Opened_tables: 2838
Apnian> Flush tables: 80  Open tables: 3

Hi!

The problem is definitely that you haven't configured mysqld/your OS
to have enough file descriptors.

By the way, why do you have så many 'flush tables' ?

Regards,
Monty