on my server which runs an online game the values are all in the megabytes
On Wed, 31 Jan 2001, Tony Shiu wrote:
> 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
>
>
--
-Spinlock
EmpireQuest Creator
http://www.empirequest.com
---------------------------------------------------------------------
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