(mysql.info) sco-unixware
Info Catalog
(mysql.info) sco-openserver
(mysql.info) other-unix-notes
2.12.5.10 SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes
.....................................................
We recommend using the latest production release of MySQL.
We have been able to compile MySQL with the following `configure'
command on UnixWare 7.1.x:
CC="cc" CFLAGS="-I/usr/local/include" \
CXX="CC" CXXFLAGS="-I/usr/local/include" \
./configure --prefix=/usr/local/mysql \
--enable-thread-safe-client --with-berkeley-db=./bdb \
--with-innodb --with-openssl --with-extra-charsets=complex
If you want to use `gcc', you must use `gcc' 2.95.3 or newer.
CC=gcc CXX=g++ ./configure --prefix=/usr/local/mysql
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 `SRC_DIRECTORY/bdb/build_unix/',
but it does not with MySQL's own `BDB' version. The workaround is as
follows.
1. Configure as normal for MySQL.
2. `cd bdb/build_unix/'
3. `cp -p Makefile to Makefile.sav'
4. Use same options and run `../dist/configure'.
5. Run `gmake'.
6. `cp -p Makefile.sav Makefile'
7. Change to top source directory and run `gmake'.
This allows both the shared and dynamic libraries to be made and work.
SCO provides operating system patches at
`ftp://ftp.sco.com/pub/unixware7' for UnixWare 7.1.1,
`ftp://ftp.sco.com/pub/unixware7/713/' for UnixWare 7.1.3,
`ftp://ftp.sco.com/pub/unixware7/714/' for UnixWare 7.1.4, and
`ftp://ftp.sco.com/pub/openunix8' for OpenUNIX 8.0.0.
SCO provides information about security fixes at
`ftp://ftp.sco.com/pub/security/OpenUNIX' for OpenUNIX and
`ftp://ftp.sco.com/pub/security/UnixWare' for UnixWare.
By default, the maximum file size on a UnixWare 7.1.1 system is 1GB,
but UnixWare 7.1.4 file size limit is 1 TB with VXFS. Some OS
utilities have a limitation of 2GB. The maximum possible file size on
UnixWare 7 is 1TB with VXFS.
On UnixWare 7.1.4 you do not need to do anything to get large file
support, but to enable large file support on prior versions of UnixWare
7.1.x, run `fsadm'.
# fsadm -Fvxfs -o largefiles /
# fsadm / * Note
# ulimit unlimited
# cd /etc/conf/bin
# ./idtune SFSZLIM 0x7FFFFFFF ** Note
# ./idtune HFSZLIM 0x7FFFFFFF ** Note
# ./idbuild -B
* This should report "largefiles".
** 0x7FFFFFFF represents infinity for these values.
Reboot the system using `shutdown'.
By default, the entries in `/etc/conf/cf.d/mtune' are set to:
Value Default Min Max
----- ------- --- ---
SVMMLIM 0x9000000 0x1000000 0x7FFFFFFF
HVMMLIM 0x9000000 0x1000000 0x7FFFFFFF
SSTKLIM 0x1000000 0x2000 0x7FFFFFFF
HSTKLIM 0x1000000 0x2000 0x7FFFFFFF
We recommend setting these values as follows:
SDATLIM 0x7FFFFFFF
HDATLIM 0x7FFFFFFF
SSTKLIM 0x7FFFFFFF
HSTKLIM 0x7FFFFFFF
SVMMLIM 0x7FFFFFFF
HVMMLIM 0x7FFFFFFF
SFNOLIM 2048
HFNOLIM 2048
We recommend tuning the system, but 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
affects the kernel parameters defined in `/etc/conf/cf.d/stune':
`SHMMAX' (recommended setting: 128MB) and `SHMSEG' (recommended
setting: 15). These parameters have influence on the MySQL database
engine to create user buffer pools.
`SFNOLIM' and `HFNOLIM' should be at maximum 2048.
`NPROC' should be set to at least 3000/4000 (depends on number of
users).
Also is recommended to use following formula to count value for
`SEMMSL', `SEMMNS', and `SEMMNU':
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.
Set `SEMMNS' to the value of `SEMMSL' multiplied by the number of db
servers (maximum) that you are running on the system at one time.
`SEMMNU' = `SEMMNS'
Set the value of `SEMMNU' to equal the value of `SEMMNS'. You could
probably set this to 75% of `SEMMNS', but this is a conservative
estimate.
Info Catalog
(mysql.info) sco-openserver
(mysql.info) other-unix-notes
automatically generated byinfo2html