maria-developers team mailing list archive

[Arjen Lentz <arjen@xxxxxxxxxxxxx>]

Hi Monty

On 14/10/2009, at 10:57 PM, Michael Widenius wrote:
> > > > > > "Arjen" == Arjen Lentz <arjen@xxxxxxxxxxxxx> 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-properties.html
> "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