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

Oleg Rusanov freebsd-amd64 at molecon.ru
Sat Jul 30 07:39:56 GMT 2005


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--------------------------------------

-- 
Regards,

Oleg Rusanov
Molecon                          mailto:freebsd-amd64 at molecon.ru



More information about the freebsd-amd64 mailing list