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 ?
>
> Thanks,
>
> Mariella
>
>
>
> --- Mariella Petrini <mariellapetrini@yahoo.com>
> 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/internals?uns...rini@yahoo.com
>>
>
>
> __________________________________________________ __________________________________
> Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yah...invite.asp?a=7
>
>
>
>
> ------------------------------------------------------------------------
>
>