Jan S Berg wrote: > Hi, > > thanks Martin for the performance runs. > It seems that although some runs show significant improvements there > are occasions where you would choose 32bit. > > In the discussions it seems that a switch for choosing between 32bit > and 64bit is wanted. We have not found any good way, that will work > for all installations, how to set up a SMF property that comes with > different default based on the platform you are running on.(Anyway, we > are open for suggestions :)
Assuming you're following a directory layout consistent with what isalist(1) expects, and you want it to run with the best isa there, you can certainly use a hardlink to isaexec. http://docs.sun.com/app/docs/doc/816-5138/6mba6ua5n?l=en&a=view This is the most common way to execute the most appropriate, per platform binary. For instance, on my laptop here: mi109165 at bird$ ls -i /usr/bin/sort 145701 /usr/bin/sort mi109165 at bird$ ls -i /usr/lib/isaexec 145701 /usr/lib/isaexec So I'd get a 64-bit capable sort... if my laptop were capable of it. :) Perhaps the switch in SMF should be between 'native' ISA and 32-bit addressing? > > We would also argue that to get the most performance out of MySQL you > should also tweak the settings in my.cnf as well as choosing the > binary that works best for the purpose. > > So having a property makes us choose the default as 32bit. > > I have updated the the ARC case with the comments: > > http://wikis.sun.com/display/WebStack/MySQL64bitARC > > Updates are: > -the connectors are placed in separate location > -update for the enable_64bit property > -added documentation changes > -renamed the packages > -added file listing > > Regards, > Jan S > > > Martin MC Brown wrote: >> Hi Everybody, >> >>> I'll do similar Studio12 builds over the weekend and re-run as well. >> >> >> OK, I ran the tests (and experienced a problem on my x86 host for >> 64-bit builds), but managed to get together some good results which I >> summarized here: http://coalface.mcslp.com/?p=68 >> >> The upshot? >> >> Basically on x86 there seems to be a significant advantage of >> enabling 64-bit builds over 32-bit. On SPARC, the difference is far >> more marginal, if not approaching the non-existent. >> >> MC >> >> -- >> Martin 'MC' Brown, mc at mcslp.com >> Everything MCslp: http://planet.mcslp.com >> >> >> > -- Matt Ingenthron - Web Infrastructure Solutions Architect Sun Microsystems, Inc. - Global Systems Practice http://blogs.sun.com/mingenthron/ email: matt.ingenthron at sun.com Phone: 310-242-6439
