The FreeBSD Diary

The FreeBSD Diary (TM)

Providing practical examples since 1998

If you buy from Amazon USA, please support us by using this link.
[ HOME | TOPICS | INDEX | WEB RESOURCES | BOOKS | CONTRIBUTE | SEARCH | FEEDBACK | FAQ | FORUMS ]
FreeBSD Support
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Previous Message  |  Next Message 
 RE: mysql error on freshports
Author: Michael Joyner 
Date:   01-12-00 04:22

You need to change
the settings mysqld is started with.

I use the following at work for my
www site.

(excerpt from /usr/local/bin/safe_mysqld)

echo "mysqld started on " `date` >> $err_log
while true
do
rm -f $MYSQL_UNIX_PORT $pid_file # Some extra safety
if test "$#" -eq 0
then
nohup $ledir/mysqld -O max_connections=1000 -O wait_timeout=3600 --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
>> $err_log 2>&1
else
nohup $ledir/mysqld -O max_connections=1000 -O wait_timeout=3600 --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
"$@" >> $err_log 2>&1
fi
if test ! -f $pid_file # This is removed if normal shutdown
then
break;
fi
echo "mysqld restarted on " `date` | tee -a $err_log
done

 Reply To This Message  |  Forum List  |  Flat View   Newer Topic  |  Older Topic 

 Topics Author  Date
 mysql error on freshports   new
parv 29-11-00 05:09 
 RE: mysql error on freshports   new
Dan Langille 29-11-00 08:18 
 RE: mysql error on freshports   new
Michael Joyner 01-12-00 04:22 
 RE: mysql error on freshports   new
Dan Langille 01-12-00 07:21 
 RE: mysql error on freshports   new
Michael Joyner 03-12-00 16:49 
 RE: mysql error on freshports   new
Dan Langille 03-12-00 20:10 
 RE: mysql error on freshports   new
Dan Langille 03-12-00 20:30 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
How to get the most out of the forum

phorum.org