BSD Notes
171
CFLAGS=-pthread CXXFLAGS=-pthread ./configure --with-mit-threads=no
2.20.4.4. BSD/OS Version 2.x Notes
If you get the following error when compiling MySQL, your
ulimit
value for virtual memory is too low:
item_func.h: In method
`Item_func_ge::Item_func_ge(const Item_func_ge &)':
item_func.h:28: virtual memory exhausted
make[2]: *** [item_func.o] Error 1
Try using
ulimit -v 80000
and run
make
again. If this doesn't work and you are using
bash
, try
switching to
csh
or
sh
; some BSDI users have reported problems with
bash
and
ulimit
.
If you are using
gcc
, you may also use have to use the
--with-low-memory
[124]
flag for
configure
to be able to compile
sql_yacc.cc
.
If you get problems with the current date in MySQL, setting the
TZ
variable should help. See
Section 2.21, “Environment Variables”
.
2.20.4.5. BSD/OS Version 3.x Notes
Upgrade to BSD/OS 3.1. If that is not possible, install BSDIpatch M300-038.
Use the following command when configuring MySQL:
env CXX=+ CC=shlicc2 \
./configure \
--prefix=/usr/local/mysql \
--localstatedir=/var/mysql \
--without-perl \
--with-unix-socket-path=/var/mysql/mysql.sock
The following is also known to work:
env CC=gcc CXX=gcc CXXFLAGS=-O3 \
./configure \
--prefix=/usr/local/mysql \
--with-unix-socket-path=/var/mysql/mysql.sock
You can change the directory locations if you wish, or just use the defaults by not specifying any
locations.
If you have problems with performance under heavy load, try using the
--skip-thread-
priority
[422]
option to
mysqld
. This runs all threads with the same priority. On BSDI 3.1, this
gives better performance, at least until BSDI fixes its thread scheduler.
If you get the error
virtual memory exhausted
while compiling, you should try using
ulimit -
v 80000
and running
make
again. If this doesn't work and you are using
bash
, try switching to
csh
or
sh
; some BSDI users have reported problems with
bash
and
ulimit
.
2.20.4.6. BSD/OS Version 4.x Notes
BSDI 4.x has some thread-related bugs. If you want to use MySQL on this, you should install all thread-
related patches. At least M400-023 should be installed.
On some BSDI 4.x systems, you may get problems with shared libraries. The symptom is that you can't
execute any client programs, for example,
mysqladmin
. In this case, you need to reconfigure not to
use shared libraries with the
--disable-shared
option to configure.
Some customers have had problems on BSDI 4.0.1 that the
mysqld
binary after a while can't open
tables. This occurs because some library/system-related bug causes
mysqld
to change current
directory without having asked for that to happen.
Содержание 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 ...