I wonder the normalization and indexing of tables, Awa the complexity of
queries submitted to server. For those variables you mentioned I use in
production without significantly slow-down in peak time.
-----Original Message-----
From: Matis, Jan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 31, 2001 12:46 AM
To: 'Sam Wong'; [EMAIL PROTECTED]
Subject: RE: Mysqld eats up RAM and CPU
what about this ?
2*PII 450 MHZ
1G RAM
data on hardware raid
port = 3306
socket = /tmp/mysql.sock
user = mysql
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = wait_timeout=150
set-variable = max_connections=768
set-variable = record_buffer=12k
set-variable = net_buffer_length=12k
set-variable = sort_buffer=12k
set-variable = table_cache=12
I've never had more than 512 conections ... but sometimes mysql looks
really
slow ...
ant load goes up to 40
do U have some ideas ?
Jan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php