Hi,

What setting would you recommend for a medium site?
My site is currently running at around 20/30 queries per seconds, no
slow queries as far as the log can tell.

At the moment I have max.concurrent connections set to 4 should I
increase that?

What other setting should I change for the site to run properly?

Many thanks

FFMG


--

'webmaster forum' (http://www.httppoint.com) | 'webmaster Directory'
(http://www.webhostshunter.com/) | 'Recreation Vehicle insurance'
(http://www.insurance-owl.com/other/car_rec.php)
'Free URL redirection service' (http://urlkick.com/)
------------------------------------------------------------------------
FFMG's Profile: http://www.httppoint.com/member.php?userid=580
View this thread: http://www.httppoint.com/showthread.php?t=18667

Message Posted via the webmaster forum http://www.httppoint.com, (Ad revenue sharing).

FFMG wrote:
> Hi,
>
> What setting would you recommend for a medium site?
> My site is currently running at around 20/30 queries per seconds, no
> slow queries as far as the log can tell.
>
> At the moment I have max.concurrent connections set to 4 should I
> increase that?
>
> What other setting should I change for the site to run properly?
>
> Many thanks
>
> FFMG
>
>
when you installed mysql, the install program creates a folder called
support-files. inside that folder you'll find several configuration
files one for small, medium and large sites/servers. here's the
beginning of the one they have for medium type of systems:


# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M