Mysql 4.1. my-large.cnf or my-medium.cnf? Dual Opteron web server 2gb memory

[Ken Gunderson]

Oleg Rusanov wrote:
> Hello.
> my-large.cnf is twice quicklier, but the description from
> my-medium.cnf is approaches (such as a web server).
> It is necessary that Mysql worked twice more slowly on a web server?
> 
> amd64# uname -r
> 5.4-STABLE
> make WITH_XCHARSET=all BUILD_OPTIMIZED=yes BUILD_STATIC=yes install
> 
> --------------------------my-medium.cnf--------------------------------------
> description:
> # 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)
> 
> test:
> Query Barrel Report for client smacker1
> connect: max=4ms  min=2ms avg= 2ms from 10 clients
> Query_type      num_queries     max_time        min_time        q_per_s
> select_index    20000   0       0       11858.11
> 
> --------------------------/my-medium.cnf--------------------------------------
> 
> --------------------------my-large.cnf--------------------------------------
> description:
> # This is for a large system with memory = 512M where the system runs mainly
> # MySQL.
> 
> test:
> Query Barrel Report for client smacker1
> connect: max=4ms  min=2ms avg= 2ms from 10 clients
> Query_type      num_queries     max_time        min_time        q_per_s
> select_index    20000   0       0       21777.24
> --------------------------/my-large.cnf--------------------------------------
> 

These are just some example suggestions that have been included since 
forever w/the MySQL distribution.  There is certainly nothing about them 
that is written in stone.  If you have the RAM, and you probably most 
certainly do on any modern system, use start off with my-large.cnf

Regards-- kvg