(mysql.info.gz) SCO UnixWare

Info Catalog

(mysql.info.gz) SCO

(mysql.info.gz) Other Unix Notes

 
 2.12.5.9 SCO UnixWare Version 7.1.x Notes
 .........................................
 
 We recommend using the latest production release of MySQL.  Currently
 this is MySQL 4.0.x.  Should you choose to use an older release of
 MySQL on UnixWare 7.1.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.
 
 We have been able to compile MySQL with the following `configure'
 command on UnixWare Version 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
 
 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 system is 1GB.  Many
 OS utilities have a limitation of 2GB.  The maximum possible file size
 on UnixWare 7 is 1TB with VXFS.
 
 To enable large file support on 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
 will affect the following 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 will be 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.gz) SCO

(mysql.info.gz) Other Unix Notes