Other Unix Notes
181
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.
•
NOFILES
and
MAXUP
should be set to at least 2048.
•
MAXPROC
should be set to at least 3000/4000 (depends on number of users) or more.
• 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.
You need to at least install the SCO OpenServer Linker and Application Development Libraries or the
OpenServer Development System to use
gcc
. You cannot use the GCC Dev system without installing
one of these.
You should get the FSU Pthreads package and install it first. This can be found at
http://
moss.csc.ncsu.edu/~mueller/ftp/pub/PART/pthreads.tar.gz
. You can also get a precompiled package
from
ftp://ftp.zenez.com/pub/zenez/prgms/FSU-threads-3.14.tar.gz
.
FSU Pthreads can be compiled with SCO Unix 4.2 with tcpip, or using OpenServer 3.0 or Open
Desktop 3.0 (OS 3.0 ODT 3.0) with the SCO Development System installed using a good port of GCC
2.5.x. For ODT or OS 3.0, you need a good port of GCC 2.5.x. There are a lot of problems without a
good port. The port for this product requires the SCO Unix Development system. Without it, you are
missing the libraries and the linker that is needed. You also need
SCO-3.2v4.2-includes.tar.gz
.
This file contains the changes to the SCO Development include files that are needed to get MySQL to
build. You need to replace the existing system include files with these modified header files. They can
be obtained from
ftp://ftp.zenez.com/pub/zenez/prgms/SCO-3.2v4.2-includes.tar.gz
.
To build FSU Pthreads on your system, all you should need to do is run GNU
make
. The
Makefile
in
FSU-threads-3.14.tar.gz is set up to make FSU-threads.
You can run
./configure
in the
threads/src
directory and select the SCO OpenServer option.
This command copies
Makefile.SCO5
to
Makefile
. Then run
make
.
To install in the default
/usr/include
directory, log in as
root
, and then
cd
to the
thread/src
directory and run
make install
.
Remember that you must use GNU
make
to build MySQL.
Note
If you do not start
mysqld_safe
as
root
, you should get only the default 110
open files per process.
mysqld
writes a note about this in the log file.
With SCO 3.2V4.2, you should use FSU Pthreads version 3.14 or newer. The following
configure
command should work:
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...