![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196186.webp)
Solaris Notes
166
For information about installing MySQL on Solaris using PKG distributions, see
Section 2.13, “Installing
MySQL on Solaris”
.
On Solaris, you may run into trouble even before you get the MySQL distribution unpacked, as the
Solaris
tar
cannot handle long file names. This means that you may see errors when you try to
unpack MySQL.
If this occurs, you must use GNU
tar
(
gtar
) to unpack the distribution.
If you get the following error from
configure
, it means that you have something wrong with your
compiler installation:
checking for restartable system calls... configure: error can not
run test programs while cross compiling
In this case, you should upgrade your compiler to a newer version. You may also be able to solve this
problem by inserting the following row into the
config.cache
file:
ac_cv_sys_restartable_syscalls=${ac_cv_sys_restartable_syscalls='no'}
If you are using Solaris on a SPARC, the recommended compiler is
gcc
2.95.2 or 3.2. You can find this
at
http://gcc.gnu.org/
. Note that
gcc
2.8.1 does not work reliably on SPARC.
The recommended
configure
line when using
gcc
2.95.2 is:
CC=gcc CFLAGS="-O3" \
CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
./configure --prefix=/usr/local/mysql --with-low-memory \
--enable-assembler
If you have an UltraSPARC system, you can get 4% better performance by adding
-mcpu=v8 -Wa,-
xarch=v8plusa
to the
CFLAGS
and
CXXFLAGS
environment variables.
If you have Sun's Forte 5.0 (or newer) compiler, you can run
configure
like this:
CC=cc CFLAGS="-Xa -fast -native -xstrconst -mt" \
CXX=CC CXXFLAGS="-noex -mt" \
./configure --prefix=/usr/local/mysql --enable-assembler
To create a 64-bit binary with Sun's Forte compiler, use the following configuration options:
CC=cc CFLAGS="-Xa -fast -native -xstrconst -mt -xarch=v9" \
CXX=CC CXXFLAGS="-noex -mt -xarch=v9" ASFLAGS="-xarch=v9" \
./configure --prefix=/usr/local/mysql --enable-assembler
To create a 64-bit Solaris binary using
gcc
, add
-m64
to
CFLAGS
and
CXXFLAGS
and remove
--
enable-assembler
from the
configure
line.
In the MySQL benchmarks, we obtained a 4% speed increase on UltraSPARC when using Forte 5.0 in
32-bit mode, as compared to using
gcc
3.2 with the
-mcpu
flag.
If you create a 64-bit
mysqld
binary, it is 4% slower than the 32-bit binary, but can handle more
threads and memory.
When using Solaris 10 for x86_64, you should mount any file systems on which you intend to store
InnoDB
files with the
forcedirectio
option. (By default mounting is done without this option.)
Failing to do so will cause a significant drop in performance when using the
InnoDB
storage engine on
this platform.
If you get a problem with
fdatasync
or
sched_yield
, you can fix this by adding
LIBS=-lrt
to the
configure
line
For compilers older than WorkShop 5.3, you might have to edit the
configure
script. Change this
line:
Содержание 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 ...