Dear Sir,
This is my error after run mysql client.
Didn't find any fields in table 'itresources_co_th'
Didn't find any fields in table 'itsthai_co_th'
Didn't find any fields in table 'jancobkk_com'
Didn't find any fields in table 'jasper_co_th'
Didn't find any fields in table 'jbathailand_com'
Didn't find any fields in table 'jcthailand_co_th'
Didn't find any fields in table 'jetfresh_co_th'
..................
Note: I think that I don not have 200+ connections at once. from
mysqladmin status command result as below:
Uptime: 97390 Running threads: 1 Questions: 532996 Opened_tables: 2838
Flush tables: 80 Open tables: 3
Regards,
**************************************************************************
Apinan Supanugoolsamai | E-mail : white@stripped
| Tel. : (662)622-5678 Ext. 305
System Administrator | Fax : (662)622-5669
| www : www.loxinfo.co.th
| ftp : ftp.loxinfo.co.th
Operation Department,
Loxley Information Services Co.,Ltd.
304 Suapah Rd., Pomprab,
Pomprab Suttruphai, Bangkok 10100
Thailand
**************************************************************************
On Thu, 30 Sep 1999, Tonu Samuel wrote:
> "Apnian S." wrote:
> > I already read and using it but it still not working with real
> > system. and I used all option in mysql daemon such as table_cache,
> > max_connections (ulimit is unlimited).
> > > > > > We have a problem to open more than 200 tables. If
> we used client
> > > > > > mysql and not using -A command, mysql Database will got a
> error can't
> > > > > > open table.
> > > > > > Result we can't open some table on my database and
> we can't
> > > > > > connect to mysql database. Help me please!
>
> What is the exact error message? There is also hardcoded limit in linux
> kernels which limits maximum number of processes (threads) to 256 per
> user. Maybe you stuck on it if you maybe made 200+ connections at once?
>
> --
> +----------------------------------------------------------------+
> | TcX ____ __ _____ _____ ___ |
> | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| T> | /*/ /*/ /*/ \*\_ |*| |*||*| tonu@stripped |
> | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn, Estonia |
> | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
> | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
> | /*/ \*\ Developers Team |
> +----------------------------------------------------------------+
>
