GNU Info

(mysql.info)FreeBSD

---

Next: NetBSD Prev: BSD Notes Up: BSD Notes

---

Enter node , (file) or (file)node

FreeBSD Notes
.............

FreeBSD 3.x is recommended for running MySQL since the thread package
is much more integrated.

The easiest and therefor the preferred way to install is to use the
mysql-server and mysql-client ports available on
`http://www.freebsd.org'.

Using these gives you:
   * A working MySQL with all optimizations known to work on your
     version of FreeBSD enabled.

   * Automatic configuration and build.

   * Startup scripts installed in /usr/local/etc/rc.d.

   * Ability to see which files that are installed with pkg_info -L.
     And to remove them all with pkg_delete if you no longer want MySQL
     on that machine.

It is recommended you use MIT-pthreads on FreeBSD 2.x and native
threads on Versions 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'.

The MySQL `Makefile's require GNU make (`gmake') to work.  If you want
to compile MySQL you need to install GNU `make' first.

Be sure to have your name resolver setup correct.  Otherwise you may
experience resolver delays or failures when connecting to `mysqld'.

Make sure that the `localhost' entry in the `/etc/hosts' file is
correct (otherwise you will have problems connecting to the database).
The `/etc/hosts' file should start with a line:

     127.0.0.1       localhost localhost.your.domain

If you notice that `configure' will use MIT-pthreads, you should read
the MIT-pthreads notes.  Note: MIT-pthreads.

If you get an error from `make install' that it can't find
`/usr/include/pthreads', `configure' didn't detect that you need
MIT-pthreads.  This is fixed by executing these commands:

     shell> rm config.cache
     shell> ./configure --with-mit-threads

FreeBSD is also known to have a very low default file handle limit.
Note: Not enough file handles.  Uncomment the ulimit -n section in
safe_mysqld or raise the limits for the `mysqld' user in /etc/login.conf
(and rebuild it with cap_mkdb /etc/login.conf).  Also be sure you set
the appropriate class for this user in the password file if you are not
using the default (use: chpass mysqld-user-name).  *Note `safe_mysqld':
safe_mysqld.

If you get problems with the current date in MySQL, setting the `TZ'
variable will probably help.  Note: Environment variables.

To get a secure and stable system you should only use FreeBSD kernels
that are marked `-STABLE'.