OpenServer 6 includes these key improvements:
Larger file support up to 1 TB
Multiprocessor support increased from 4 to 32 processors
Increased memory support up to 64GB
Extending the power of UnixWare into OpenServer 6
Dramatic performance improvement
OpenServer 6.0.0 commands are organized as follows:
/bin is for commands that behave
exactly the same as on OpenServer 5.0.x.
/u95/bin is for commands that have
better standards conformance, for example Large File
System (LFS) support.
/udk/bin is for commands that behave
the same as on UnixWare 7.1.4. The default is for the LFS
The following is a guide to setting
OpenServer 6. If the user wants the traditional OpenServer
PATH should be
/bin first. If the user wants LFS
support, the path should be
/u95/bin:/bin. If the user wants UnixWare
7 support first, the path would be
Use the latest production release of MySQL. Should you choose to use an older release of MySQL on OpenServer 6.0.x, you must use a version of MySQL at least as recent as 3.22.13 to get fixes for some portability and OS problems.
MySQL distribution files with names of the following form are
tar archives of media are tar archives of
media images suitable for installation with the SCO Software
/etc/custom) on SCO OpenServer
A distribution where
pro-cert is the Commercially licensed MySQL
Pro Certified server. A distribution where
pro-gpl-cert is the MySQL Pro Certified
server licensed under the terms of the General Public License
Select whichever distribution you wish to install and, after download, extract the tar archive into an empty directory. For example:
tar xf /tmp/mysql-pro-cert-5.0.96-sco-osr6-i686.VOLS.tar
Prior to installation, back up your data in accordance with the procedures outlined in Upgrading MySQL.
Remove any previously installed pkgadd version of MySQL:
pkginfo mysql 2>&1 > /dev/null && pkgrm mysql
Install MySQL Pro from media images using the SCO Software Manager:
/etc/custom -p SCO:MySQL -i -z /tmp/mysql-pro
Alternatively, the SCO Software Manager can be displayed
graphically by clicking the
Manager icon on the desktop, selecting
Software -> Install New, selecting the
Media Images for the Media
Device, and entering
the Image Directory.
After installation, run mkdev mysql as the
root user to configure your newly installed
MySQL Pro Certified server.
The installation procedure for VOLS packages does not create
mysql user and group that the package
uses by default. You should either create the
mysql user and group, or else select a
different user and group using an option in mkdev
If you wish to configure your MySQL Pro server to interface with the Apache Web server using PHP, download and install the PHP update from SCO at ftp://ftp.sco.com/pub/updates/OpenServer/SCOSA-2006.17/.
We have been able to compile MySQL with the following configure command on OpenServer 6.0.x:
CC=cc CFLAGS="-D_FILE_OFFSET_BITS=64 -O3" \ CXX=CC CXXFLAGS="-D_FILE_OFFSET_BITS=64 -O3" \ ./configure --prefix=/usr/local/mysql \ --enable-thread-safe-client --with-berkeley-db \ --with-extra-charsets=complex \ --build=i686-unknown-sysv5SCO_SV6.0.0
If you use gcc, you must use gcc 2.95.3 or newer.
CC=gcc CXX=g++ ... ./configure ...
The version of Berkeley DB that comes with either UnixWare
7.1.4 or OpenServer 6.0.0 is not used when building MySQL.
MySQL instead uses its own version of Berkeley DB. The
configure command needs to build both a
static and a dynamic library in
but it does not with MySQL's own
version. The workaround is as follows.
Configure as normal for MySQL.
cp -p Makefile Makefile.sav
Use same options and run ../dist/configure.
cp -p Makefile.sav Makefile
Change location to the top source directory and run gmake.
This enables both the shared and dynamic libraries to be made and work.
SCO provides OpenServer 6 operating system patches at ftp://ftp.sco.com/pub/openserver6.
SCO provides information about security fixes at ftp://ftp.sco.com/pub/security/OpenServer.
By default, the maximum file size on a OpenServer 6.0.0 system is 1TB. Some operating system utilities have a limitation of 2GB. The maximum possible file size on UnixWare 7 is 1TB with VXFS or HTFS.
OpenServer 6 can be configured for large file support (file sizes greater than 2GB) by tuning the UNIX kernel.
By default, the entries in
/etc/conf/cf.d/mtune are set as follows:
Value Default Min Max ----- ------- --- --- SVMMLIM 0x9000000 0x1000000 0x7FFFFFFF HVMMLIM 0x9000000 0x1000000 0x7FFFFFFF
To make changes to the kernel, use the idtune
name parameter command.
idtune modifies the
/etc/conf/cf.d/stune file for you. To set
the kernel values, execute the following commands as
/etc/conf/bin/idtune SDATLIM 0x7FFFFFFF#
/etc/conf/bin/idtune HDATLIM 0x7FFFFFFF#
/etc/conf/bin/idtune SVMMLIM 0x7FFFFFFF#
/etc/conf/bin/idtune HVMMLIM 0x7FFFFFFF#
/etc/conf/bin/idtune SFNOLIM 2048#
/etc/conf/bin/idtune HFNOLIM 2048
Then rebuild and reboot the kernel by issuing this command:
/etc/conf/bin/idbuild -B && init 6
To tune the system, the proper parameter values to use depend on the number of users accessing the application or database and size the of the database (that is, the used buffer pool). The following kernel parameters can be set with idtune:
SHMMAX (recommended setting: 128MB) and
SHMSEG (recommended setting: 15). These
parameters have an influence on the MySQL database engine
to create user buffer pools.
should be at maximum 2048.
NPROC should be set to at least
3000/4000 (depends on number of users).
The following formulas are recommended to calculate values
SEMMSL = 13
13 is what has been found to be the best for both Progress and MySQL.
SEMMNS = SEMMSL *
number of db servers to be run on the system
SEMMNS to the value of
SEMMSL multiplied by the number of
database servers (maximum) that you are running on the
system at one time.
SEMMNU = SEMMNS
Set the value of
SEMMNU to equal the
SEMMNS. You could probably set
this to 75% of
SEMMNS, but this is a