ifconfig alias

[David Pasek]

Jedna z moznosti je poustet mysql daemona takto primo v
/usr/local/etc/rc.d/mysqld.sh (treba skriptem mysqld.sh)
Pomoci --set-variable  je mozno nastavit vse co potrebujes vcetne
--set-variable default-character-set=win1250

Vypis prikladu scriptu mysqld.sh

#!/bin/sh
/usr/local/mysql/bin/safe_mysqld \
--basedir=/usr/local/mysql \
--datadir=/usr/local/mysql/var \
--set-variable max_allowed_packet=1M \
--set-variable max_connections=4000 \
--set-variable tmp_table_size=20M \
--set-variable join_buffer=5M \
--set-variable key_buffer=50M \
--set-variable sort_buffer=5M \
--set-variable myisam_sort_buffer_size=64M \
--set-variable table_cache=512 \
--set-variable thread_cache=8 \
--set-variable thread_stack=128K \
--set-variable record_buffer=5M \
--set-variable wait_timeout=60 &


Dalsi moznost je pouzit cnf soubor, tak jak to popisoval 

Martin Salac wrote:
> 
> Ahoj,
> 
> chtel bych se zeptat, kde najdu u FreeBSD nejaky .ini file nebo konfigurak
> k mysql. Nainstaloval jsem z portu (make install):
> mysql-server-3.23.51 Multithreaded SQL database (server)
> a rad bych mu pri startu dal option: --default-character-set=win1250
> 
> Vim, ze pri startu se spousti z /usr/local/etc/rc.d/mysql-server.sh start a
> z nej se spousti /usr/local/bin/safe_mysqld. Dival jsem se do
> safe_mysqld, ale
> zda se mi prilis slozity.
> Kdyz pridam optionu do mysql-server.sh za --user=mysql, tak se mysql
> nerozebehne
> vubec.
> 
> Diky za pripadne rady.
> 
> Martin

--
David Pasek
Email: pasek at idc.cz WWW: http://www.idc.cz ICQ: 76039994
Phone: +420 (0)2 66728212 Mobile: +420 (0)603 207211
Address: IDC-softwareHouse, Osadni 12a, Prague 7, 170 04 Czech Republic