On 23 May 2001 00:15:52 -0400, Randy Johnson wrote:
>
> Please give me advice on optimizing my server: Here are the system specs
>
> dual 733 Pentium
> 512 megs of ram
>
> 9 gig scsi
>
> ------------------------------
>
> Here is the options that I use based on the documentation for a moderate #
> of users:
>
>
> -O max_connections=1000 -O key_buffer=64M -O table_cache=256 \
> -O sort_buffer=4M -O record_buffer=1M
>
> How can I improve on these options for a higher number of users than 1000.
>
> Is 5000 connections to high for mysql?
>
> How can I improve the above options since I have a good server?
Improving of speed depends on context. Yuo should run your work on this
server and watch, where is the bottleneck. Often this gives a good
hints.
5000 connections and related stuff is operating system dependant limit.
MySQL creates separate thread for each connection (to give better speed
of course ;)) but linux 2.2.x for example have by default limit of 256
threads maximum. This is solved in 2.4.x but anyway you can run on
different limits. Read manual about OS topic.
--
MySQL Security Administrator
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Paris, France (temporarily)
<___/
---------------------------------------------------------------------
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
