Hi Monty On 14/10/2009, at 10:57 PM, Michael Widenius wrote:
"Arjen" == Arjen Lentz <arjen@openquery.com> writes: Arjen> On 14/10/2009, at 6:41 PM, Sergey Petrunya wrote: On Wed, Oct 14, 2009 at 12:44:01AM +0200, Peter Laursen wrote: The billion dollar question is: what options should a config wizard (ideally) provide? . base configuration (memory requirements, #of_connections assumed): use: mini, midi, medium. large, huge --template default storage engine: MyISAM, Maria, XtraDB, PBXT default charset: latin1, utf8, custom enable slow log: yes|no enable general log: yes|no enable query cache: yes|no .. what else is important? Parameters that would allow to install multiple servers side-by side: port to listen on, named pipe name, perhaps windows service name. Binary log should probably always be enabled.
Arjen> Forget the named pipe, since it's slower.
As far as I remember if you access MySQL with named pipes from another machine it's faster than sockets. (I did the testing at the same time we got the named pipe code).
From the internet I find:
http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-p... "In simple performance tests, it appears that named pipe access is between 30%-50% faster than the standard TCP/IP access. However, this varies per system, and named pipes are slower than TCP/IP in many Windows configurations."
and: http://www.waltercedric.com/component/content/article/1217.html "We were testing successfuly MySQL 5.0 using named pipe, and what an increase in speed! 50% in the case of this big project"
So it seams that you can gain a lot or loose a bit.
<cut>
Ahye sorry I stand corrected. Got my logic memory reversed ;-) thanks! ok so we do want a pipe. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: enhanced builds for MySQL @ http://ourdelta.org