FreeBSD下MySQL安装 FreeBSD, MySQL

yuren

手动指定了几个参数来提高MySQL在FreeBSD下的性能，望对MySQL熟悉的朋友补充，谢谢！
[PHP]cd /usr/ports/databases/mysql40-server/
make WITH_XCHARSET=all WITH_LINUXTHREADS=yes WITH_PROC_SCOPE_PTH=yes SKIP_DNS_CHECK=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes install clean
/usr/local/bin/mysql_install_db
chown -R mysql:mysql /var/db/mysql/[/PHP]
下面的文件需根据服务器硬件做相应调整
[PHP]cp /usr/local/share/mysql/my-large.cnf /var/db/mysql/my.cnf[/PHP]
[PHP]ln -s /usr/local/lib/mysql /usr/lib/
ln -s /usr/local/include/mysql /usr/include/
cp /usr/local/lib/mysql/libmysqlclient.so.12 /usr/lib/[/PHP]
这样在编译类似Vpopmail等软件时可以不用指定mysql的库文件
[PHP]ee /etc/rc.conf
mysql_enable="YES"[/PHP]
reboot
[PHP]mysqladmin -u root password passwd[/PHP]

xiukan

好文章啊,,

a1b2cc3

thank