Settings of `black_log` in MySQL

**Settings of `black_log` in MySQL -** 06-04-2007, 07:47 AM

our max. connection has been set to 1000, for a very busy database, but
we leave the black_log as its default value, is it a problem?

any recommendation on its value?

**Re: Settings of `black_log` in MySQL -** 06-04-2007, 07:47 AM

howa ¼g¹D¡G

> our max. connection has been set to 1000, for a very busy database, but
> we leave the black_log as its default value, is it a problem?
>
> any recommendation on its value?

some settings...

wait_timeout 28800
interactive_timeout 28800
max_connections 1000

sort_buffer_size 2097144
read_buffer_size 2093056
key_buffer_size 104857600
join_buffer_size 131072

and some status...

Uptime 471655
Bytes_received 467781159
Bytes_sent 819100182
Questions 37969745
Table_locks_immediate 14679426
Table_locks_waited 31840

Threads_cached 7
Threads_connected 41
Threads_created 213392