I don't think that is the problem. I have been able to create over a 1,000,000 of tables with MySQL 5.1.21 and different storage engines with the same environment (I had already ulimit set).
Thanks, Mariella Mathieu Bruneau <[EMAIL PROTECTED]> wrote: 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 > 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 > > > > > ------------------------------------------------------------------------ > > --------------------------------- Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out.