dbTalk Databases Forums  

Settings of `black_log` in MySQL

comp.databases.mysql comp.databases.mysql


Discuss Settings of `black_log` in MySQL in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
howa
 
Posts: n/a

Default Settings of `black_log` in MySQL - 01-15-2007 , 09:08 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?


Reply With Quote
  #2  
Old   
howa
 
Posts: n/a

Default Re: Settings of `black_log` in MySQL - 01-15-2007 , 09:17 AM







howa ¼g¹D¡G

Quote:
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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.