Hi! >>>>> "Arjen" == Arjen Lentz <[email protected]> writes:
Arjen> Hi Sergey, all 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> Regards, Monty _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
