BSD Notes
169
• If you are using Solaris 8, you can install the optional
zlib
from your Solaris 8 CD distribution.
• Run
configure
with the
--with-named-z-libs=no
option when building MySQL.
2.20.3.2. Solaris x86 Notes
On Solaris 8 on x86,
mysqld
dumps core if you remove the debug symbols using
strip
.
If you are using
gcc
on Solaris x86 and you experience problems with core dumps under load, you
should use the following
configure
command:
CC=gcc CFLAGS="-O3 -fomit-frame-pointer -DHAVE_CURSES_H" \
CXX=gcc \
CXXFLAGS="-O3 -fomit-frame-pointer -felide-constructors \
-fno-exceptions -fno-rtti -DHAVE_CURSES_H" \
./configure --prefix=/usr/local/mysql
This avoids problems with the
+
library and with C++ exceptions.
If this doesn't help, you should compile a debug version and run it with a trace file or under
gdb
. See
MySQL Internals: Porting to Other Systems
.
2.20.4. BSD Notes
This section provides information about using MySQL on variants of BSD Unix.
2.20.4.1. FreeBSD Notes
FreeBSD 4.x or newer is recommended for running MySQL, because the thread package is much more
integrated. To get a secure and stable system, you should use only FreeBSD kernels that are marked
-RELEASE
.
The easiest (and preferred) way to install MySQL is to use the
mysql-server
and
mysql-client
ports available at
http://www.freebsd.org/
. Using these ports gives you the following benefits:
• A working MySQL with all optimizations enabled that are known to work on your version of FreeBSD.
• Automatic configuration and build.
• Startup scripts installed in
/usr/local/etc/rc.d
.
• The ability to use
pkg_info -L
to see which files are installed.
• The ability to use
pkg_delete
to remove MySQL if you no longer want it on your machine.
It is recommended you use MIT-pthreads on FreeBSD 2.x, and native threads on FreeBSD 3 and up.
It is possible to run with native threads on some late 2.2.x versions, but you may encounter problems
shutting down
mysqld
.
Unfortunately, certain function calls on FreeBSD are not yet fully thread-safe. Most notably, this
includes the
gethostbyname()
function, which is used by MySQL to convert host names into IP
addresses. Under certain circumstances, the
mysqld
process suddenly causes 100% CPU load
and is unresponsive. If you encounter this problem, try to start MySQL using the
--skip-name-
resolve
[420]
option.
Alternatively, you can link MySQL on FreeBSD 4.x against the LinuxThreads library, which avoids a
few of the problems that the native FreeBSD thread implementation has. For a very good comparison
of LinuxThreads versus native threads, see Jeremy Zawodny's article FreeBSD or Linux for your
MySQL Server? at
http://jeremy.zawodny.com/blog/archives/000697.html
.
Known problem when using LinuxThreads on FreeBSD is:
Содержание 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 ...