Bug #229

MySQL should be enabled for 64bit on 64bit platforms by default

Added by Roy Sigurd Karlsbakk about 8 years ago. Updated over 6 years ago.

Status:NewStart date:2010-09-18
Priority:LowDue date:2011-09-14
Assignee:OI Userland% Done:

10%

Category:-Estimated time:1.00 hour
Target version:-
Difficulty:Bite-size Tags:mysql

Description

Hi all

MySQL-51 installs well, but the default is to use it in 32bit mode, which isn't optimal, since a 32bit app won't use all registers available in 64bit, and won't have access to all the memory. Could this be switched to use 64bit mode when this is available in the OS (and hardware)?

roy

History

#1 Updated by Roy Sigurd Karlsbakk about 8 years ago

This could be changed tosomething like "We should document that MySQL is used in 32bit by default on OpenIndiana. If you need access to more than 4GB (or 2?) memory, please enable 64 bit by doing

svccfg -s mysql:version_51 setprop mysql/enable_64bit = true
svcadm refresh
svcadm restart

#2 Updated by Albert Lee almost 8 years ago

  • Category changed from OpenIndiana Misc to 10
  • Priority changed from Normal to Low

#3 Updated by Julian Wiesener over 7 years ago

  • Assignee set to OI SFW

#4 Updated by Ken Mays about 7 years ago

  • Due date set to 2011-09-14
  • Status changed from New to Closed
  • Assignee changed from OI SFW to OI Userland
  • Target version set to oi_151_stable
  • % Done changed from 0 to 100
  • Estimated time set to 1.00
  • Difficulty set to Medium
  • Tags set to mysql

Roy - added to release notes of oi_151a as known issue.

#5 Updated by Roy Sigurd Karlsbakk about 7 years ago

  • Status changed from Closed to Feedback
  • % Done changed from 100 to 10

A release note doesn't fix the issue, so please reopen this - if it's not planned for fixing in 151, well, change target version. Closing a bug just because it's known is rather silly

#6 Updated by Roy Sigurd Karlsbakk about 7 years ago

oh - I see the svc stuff above - never mind my comment

#7 Updated by Ken Mays about 7 years ago

  • Status changed from Feedback to Closed
  • Difficulty changed from Medium to Bite-size

Roy - this was not closed for no reason although you may keep it open if you wish. You provided a workaround that was simple for sysadmins/users to implement and be aware of. Also, the 32-bit default method is OK due to the majority of legacy deployments of Solaris being on 32-bit legacy x86 servers. I rather think of this as an RFE versus a bug.

#8 Updated by Albert Lee about 7 years ago

  • Status changed from Closed to New

Not resolved.

#9 Updated by Bayard Bell over 6 years ago

  • Project changed from OpenIndiana Distribution to illumos-userland
  • Category deleted (10)
  • Target version deleted (oi_151_stable)

Also available in: Atom