Hi Victor,
My server's connections seem never time out. Please tell me how to fix it.
The following is my.cnf:
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
#skip-locking
#
max_allowed_packet = 8M
myisam_sort_buffer_size = 64M
#
key_buffer = 1024M
table_cache = 1024
record_buffer = 8M
sort_buffer_size = 8M
read_buffer_size = 8M
#
query_cache_size = 32M
#
max_connections = 1024
max_connect_errors = 100
#
wait_timeout = 14400
interactive_timeout = 14400
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 10
thread_cache = 10
My process status:
Id User Host/IP DB Time Cmd Query or
State
-- ---- ------- -- ---- --- ----------
21110 admin 10.20.1.202 testdb 33786 Sleep
1220 admin 10.145.0.254 test1 33174 Sleep
23371 admin 10.20.1.156 testdb 30518 Sleep
3292 admin 10.145.0.254 test1 30510 Sleep
23427 admin 10.20.1.156 testdb 30487 Sleep
Thanks
Linda
----- Original Message -----
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Linda '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 18, 2004 2:13 AM
Subject: RE: query_cache_size will impact timeout variables ?
> These server settings are independent of one another. Query cache size
> should not effect your *_timeout values. Can you post the my.cnf section
> where these values are intialized?
>
> -----Original Message-----
> From: Linda
> To: [EMAIL PROTECTED]
> Sent: 8/17/04 10:10 AM
> Subject: query_cache_size will impact timeout variables ?
>
> Hi,
>
> I found out if I set "query_cache_size = 32M" to enable Query Cache,
> interactive_timeout and wait_timeout will not be effected. It makes the
> connections too many if the connections never timeout. How can I fix it?
>
>
> Linda
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
