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