maria-developers team mailing list archive
Mailing list archive
Re: Windows installer kick-off
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:
Parameters that would allow to install multiple servers side-by
The billion dollar question is: what options should a config wizard
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?
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
"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