From: Date: September 9 2007 10:25am Subject: Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem List-Archive: http://lists.mysql.com/internals/35024 Message-Id: <20070909082506.GA26268@janus.mylan> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi! On Sep 09, Jaemyung Kim wrote: > If Debian is limited to create files over 8k, it can be the reason of > the problem. > > Falcon seems not create data file for tables, but still create ".frm" > files for each tables. frm files aren't kept open all the time, they could not exhaust the precious file descriptor resource. Regards / Mit vielen Grüssen, Sergei > 2007/9/9, Mathieu Bruneau : > > I never tried the falcon engine, but could it be that mysql is running > > out of file descriptor ? > > > > I think debian is limited to something around 8k per user by default. > > Check your pam settings and your ulimit ... Database usually use a lot > > of file handle and it's generally safe to increase it. Don't know if > > falcon use file handle per table or not tough... > > > > Mariella Petrini a écrit : > > > I have re-run and job and I was able to repeat the problem. Find > > > attached the mysql server error log with all the tarces. > > > > > >> I have started using MySQL 6.0.2 with Falcon on Linux with Debian > > >> 4. I have compiled the source code for 64 bit executable. The > > >> system is an Intel 2 cpus 4 cores each, with 8 GB of RAM. > > >> > > >> I have started creating tables (without partitioning) whit engine > > >> type Falcon. After having created approximately 8,500 empty > > >> tables mysqld server was still alive, you could connect with the > > >> mysql client, but any command that you would type would freeze > > >> (never come back). -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik / /|_/ / // /\ \/ /_/ / /__ Principal Software Developer /_/ /_/\_, /___/\___\_\___/ MySQL GmbH, Dachauer Str. 37, D-80335 München <___/ Geschäftsführer: Kaj Arnö - HRB München 162140