Oracle 5.0, Reference Manual

Page: 205 / 3232

Other Unix Notes
185
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.
•
SFNOLIM
and
HFNOLIM
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 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 database 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.
2.20.5.10. SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes
Use the latest production release of MySQL. 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 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 ...
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 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 enables both the shared and dynamic libraries to be made and work.