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: Dan Langille 
Date:   01-12-00 07:21

Your script differs quite bit from mine:

rm -f $MYSQL_UNIX_PORT $pid_file # Some extra safety
if test "$#" -eq 0
then
(trap "" 1 ; exec $NOHUP_NICENESS $ledir/mysqld -basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR --user=$user -pid-file=$pid_fi
le >> $err_log 2>&1 )
else
(trap "" ; exec $NOHUP_NICENESS $ledir/mysqld -basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR --user=$user -pid-file=$pid_file "$@" >> $err_log 2>&1 )
fi

From what I can tell, you are adding:

-O max_connections=1000 -O wait_timeout=3600

I don't think that is suitable for this situation. The problem is that mysql is getting busy. Very busy. It's taking a long time to run a particular query. It's not that it's getting many connections. And I'm not going to increase the limit to 1000 connections. That's too many for this P100. And a time out of 1 hour? hmmm. Too much.

What do you think the problem is?

 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