Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem

[Sergei Golubchik]

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 <mathieu.bruneau@stripped>:
> > 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 <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Developer
/_/  /_/\_, /___/\___\_\___/  MySQL GmbH, Dachauer Str. 37, D-80335 München
       <___/                  Geschäftsführer: Kaj Arnö - HRB
München 162140