Bluehost.com Web Hosting $6.95

Settings of `black_log` in MySQL

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 ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 01-15-2007
howa
 
Posts: n/a
Default Settings of `black_log` in MySQL

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 (permalink)  
Old 01-15-2007
howa
 
Posts: n/a
Default Re: Settings of `black_log` in MySQL


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

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 11:19 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0