"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õnu Samuel |
| /*/ /*/ /*/ \*\_ |*| |*||*| tonu@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn, Estonia |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------+
