Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 30 Jul 2005 11:39:27 +0400
From:      Oleg Rusanov <freebsd-amd64@molecon.ru>
To:        freebsd-amd64 <freebsd-amd64@freebsd.org>
Subject:   Mysql 4.1. my-large.cnf or my-medium.cnf? Dual Opteron web server 2gb memory
Message-ID:  <1812296880.20050730113927@molecon.ru>

next in thread | raw e-mail | index | archive | help
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@molecon.ru




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1812296880.20050730113927>