Matt / Nico If I am not mistaken, there was some discussion during the initial design stages as to whether should we enable MySQL as 64-bit in a 64-bit platform. I guess, the outcome is what we have today :-) I will let MySQL folks chime in for more appropriate insight.
- Sriram Matt Ingenthron wrote: > Hi Nico, > > I've cc'd webstack-discuss, as that's the project which does the > integration of components like MySQL into OpenSolaris. It's probably > best to discuss this there. > > More below... > > Nico Sabbi wrote: > >> On Tuesday 13 January 2009 11:28:54 Nico Sabbi wrote: >> >> >>> As for $subject: I can't imagine an application that requires 64 >>> bit more than a db, but unfortunately the version pkg installs is >>> 32-bits only. >>> >>> >>> >> uhm, sorry I have to backtrack. I've read just now that it's possible >> to configure the 64bit mode with >> >> $ svccfg -s svc:/application/database/mysql:version_50 setprop >> enable_64bit = boolean: true >> >> $ svcadm refresh mysql >> >> $ svcadm restart mysql >> >> but it would have been nice enabling it by default on a 64bit >> installation :) >> > > Correct. With other components, notably Apache/PHP, we'd decided to > keep 64-bit an SMF configurable option since it's possible/likely that > 3rd party extensions people may add through pecl/apxs could not be > 64-bit clean. > > You have a good argument for MySQL *if* using the InnoDB query cache. > It's still pretty common though for people to rely on the filesystem for > caching (and ZFS should do well for this type of configuration) for a > variety of reasons. > > I'm not sure what the right approach is, but maybe one of my colleagues > on webstack-discuss has thought about this already. I'd imagine we can > do this from the service... perhaps pre-deliver it with an enable_64bit > set to "auto" (which would mean it can't be a boolean any longer) and > use /usr/lib/isaexec within the service? > > - Matt > _______________________________________________ > > > webstack-discuss mailing list > webstack-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/webstack-discuss >