← Back to team overview

maria-developers team mailing list archive

Re: Windows installer kick-off


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):
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:

"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."

"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.


Ahye sorry I stand corrected. Got my logic memory reversed ;-)

ok so we do want a pipe.

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