Hi Michael,
I would be very happy to help. I will however be away for the next
5 days, but there are other FreeBSD users on the list. I think the
biggest help would be for one of us FreeBSD users to update the manual
with all the latest information (I will try to do that late next week
if someone else doesn't!). I have similar notes for BSDi OS.
The first major suggestion is to use the FreeBSD ports to install
MySQL, the ports maintainers go through alot to make sure you get a
proper compile from source. However that being said it is not always
exactly what you want, but there is alot to be learned from teh
makefile. Make sure you get latest ports with cvsup and are on at
least freebsd 4.3 or a stable date from march 2001.
Second, for tuning MySQL based on your hardware see either
/usr/share/examples/mysql (if you installed from ports), or the
support-files sub directory in whatever directorty you have mysql
(like /usr/home/admin/mysql-3.23.39/support-files )
Third, there is great new info coming in FreeBSD 4.4 on tuning
FreeBSD in a man page called tuning. (man 7 tuning). You can get this
now by upgrading whatever release you are on to freebsd-stable (which
changes daily, yes you can pick a date read cvsup man page).
Fourth, my configure script for mysql:
bash-2.03$ cat ken.sh
VERSION=mysql-3.23.38
#replace first line with current version
set -x
cd $VERSION;
CC=gcc CFLAGS=-O3 CXX=gcc \
CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
./configure --enable-large-files --with-berkeley-db \
--with-innodb --with-low-memory
bash-2.03$ gmake -s
bash-2.03$ gmake -s install
(note use gmake not BSD make, must be installed (from ports) )
Without knowing alot more specifcally about any issues you are having.
I can not help more than this. I do try to answer anything I see
relating to freebsd if I can (as sometimes I learn things for our own
operation). I have changed the subect of the message to hopefully
help people searching the archives that this is a list of suggestions!
Hope this helps, I am here the rest of the day and back the middle of
next week!
Ken
----- Original Message -----
From: "Institute For Social Ecology" <ise@stripped>
To: "Ken Menzel" <kenm@stripped>; <mysql@stripped>
Sent: Wednesday, July 18, 2001 6:32 PM
Subject: RE: FreeBSD issues
> Ken,
>
> Thank you for your very helpful notes. We took your advice and
> updated to FreeBSD 4.3 and the last version of MYSQL. We are still
> experiencing problems with MYSQL, though. We installed it fresh,
with
> no freeBSD tweaks. I was not able to locate the email you referred
to
> regarding FreeBSD installs. If you have any pointers on tweaking a
> freeBSD install, it would be very helpful.
>
> Regards,
>
> Michael Caplan
>
>
> -----Original Message-----
> From: Ken Menzel [mailto:kenm@stripped]
> Sent: Tuesday, July 17, 2001 3:25 PM
> To: grrrl@stripped; mysql@stripped
> Subject: Re: FreeBSD issues
>
>
> Hi Michael,
> As another FreeBSD user that has posted many times on FreeBSD
> topics realted to MySQL it only took me a few minutes to find
<rest cut>
