Hi Jan, your problems may OR may not be resolved by upgrading your
Linux(?) system to kernel 2.4x, glibc2.2x and MySql to 2.32.30.
I haven't been able to get a confirmation from the MySQL people that this
actualy solves the problem - it is however clear that it is the dual
CPUs that are causing the problems(for me anyway). I saw someone one the
list that solved his problems by upgrading the BIOS on the RAID
controller...I've tried this and it made noe difference for me.
Now that kernel 2.4.1 has arrived I may be able to do the upgrade myself
(there was some unresolved problems with INTEL pro100 ethernet cards)..
/rune
On Tue, 30 Jan 2001, Matis, Jan wrote:
> 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
>
>
--
Rune Hansen
[EMAIL PROTECTED]
Viventus AS
Liaveien 11, 1411 Kolbotn
+4766812280/86
"It's a damn poor mind that can only think
of one way to spell a word."
--Andrew Jackson
---------------------------------------------------------------------
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
