This is a discussion on Settings of `black_log` in MySQL within the MySQL Database forums, part of the Database Forums category; our max. connection has been set to 1000, for a very busy database, but we leave the black_log as its ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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 |