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. -- Jaemyung Kim 2007/9/9, Mathieu Bruneau <[EMAIL PROTECTED]>: > > 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... > > -- > Mathieu Bruneau > aka ROunofF > > === > GPG keys available @ http://rounoff.darktech.org > > 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. > > > > > > Could you please help ? > > > > Thanks, > > > > Mariella > > > > > > > > --- Mariella Petrini <[EMAIL PROTECTED]> > > wrote: > > > >> Hi All, > >> > >> > >> 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). > >> > >> I will try to re-run the same job, enabling > >> falcon_debug_mask and see if I can get more info and > >> repeat the problem. > >> > >> Mariella > >> > >> > >> > >> Below are shown the Falcon settings used: > >> > >> > > +----------------------------------+-----------------+ > >> > >> | Variable_name | Value > >> | > >> > > +----------------------------------+-----------------+ > >> | falcon_checkpoint_schedule | 7 * * * * * > >> | > >> | falcon_debug_mask | 0 > >> | > >> | falcon_debug_server | OFF > >> | > >> > >> | falcon_disable_fsync | OFF > >> | > >> > >> | falcon_index_chill_threshold | 4 > >> | > >> > >> | falcon_initial_allocation | 1073741824 > >> | > >> > >> | falcon_max_transaction_backlog | 150 > >> | > >> > >> | falcon_page_cache_size | 4194304 > >> | > >> | falcon_page_size | 4096 > >> | > >> | falcon_record_chill_threshold | 5 > >> | > >> | falcon_record_memory_max | 262144000 > >> | > >> > >> | falcon_record_scavenge_floor | 50 > >> | > >> > >> | falcon_record_scavenge_threshold | 67 > >> | > >> > >> | falcon_scavenge_schedule | 15,45 * * * * * > >> | > >> > >> | falcon_serial_log_buffers | 10 > >> | > >> > >> | falcon_serial_log_dir | > >> | > >> | have_falcon | YES > >> | > >> > > +----------------------------------+-----------------+ > >> > >> > >> > >> > >> > >> > > > ____________________________________________________________________________________ > >> Need a vacation? Get great deals > >> to amazing places on Yahoo! Travel. > >> http://travel.yahoo.com/ > >> > >> -- > >> MySQL Internals Mailing List > >> For list archives: http://lists.mysql.com/internals > >> To unsubscribe: > >> > > http://lists.mysql.com/[EMAIL PROTECTED] > >> > > > > > > > ____________________________________________________________________________________ > > Shape Yahoo! in your own image. Join our Network Research Panel > today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > -- > MySQL Internals Mailing List > For list archives: http://lists.mysql.com/internals > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
