Date: Sat, 30 Jul 2005 10:26:45 -0600 From: Ken Gunderson <kgunders@teamcool.net> To: freebsd-amd64@freebsd.org Subject: Re: Mysql 4.1. my-large.cnf or my-medium.cnf? Dual Opteron web server 2gb memory Message-ID: <42EBAA45.6020400@teamcool.net> In-Reply-To: <1812296880.20050730113927@molecon.ru> References: <1812296880.20050730113927@molecon.ru>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42EBAA45.6020400>