Hi Alan,
Sounds like you need to do some tuning, you are running MySQL low
on resources. This is one situation MySQL does not handle well. You
need to adjust the login class to have more memory for instance you
could create a class named "sql" and place it in your login .conf,
then use vipw to change to login class of the mysql user. I have
attached an example. You could also just use the daemon class.
#Add more relaxed memory for database users
sql:\
:path=/bin /usr/bin /usr/contrib/bin /usr/X11/bin:\
:datasize-max=128M:\
:datasize-cur=64M:\
:maxproc-max=128:\
:maxproc-cur=64:\
:openfiles-cur=6000:\
:radius-challenge-styles=activ,crypto,skey,snk,token:\
:stacksize-cur=64M:\
:tc=auth-bsdi-defaults:\
:tc=auth-ftp-bsdi-defaults:
On the PHP errors Are you using the latest PHP 4.0.4pl1 or are you
using the contrib, I would guess the contrib, try the latest PHP.
Ken
-----------------------------------------------------
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
----- Original Message -----
From: "Alan Halls" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Thursday, February 15, 2001 12:12 PM
Subject: Restart server when it hangs?
> Hi,
> I am running a PIII 733 with 256 MB Ram and the mysql server keeps
locking
> up. I go into the "top" program and the mysql process is taking up
95-98% of
> the processor and continually has to be killed and restarted. We are
running
> on an BSDI4.2 / Apache server using PHP pages, I am not using
persistent
> connections, should I be. is there a way to have mysql restart when
it
> hangs?
>
> These are the errors I am getting:
> 010212 4:24:29 /usr/local/libexec/mysqld: Out of memory (Needed
16384
> bytes)
> 010212 04:25:53 mysqld restarted
> /usr/local/libexec/mysqld: ready for connections
> 010208 3:42:57 Aborted connection 9634 to db: 'pp_beta1' user:
'root'
> host: `localhost' (Got an error reading communication packets)
> 010208 3:43:57 Aborted connection 9505 to db: 'pp_beta1' user:
'root'
> host: `localhost' (Got an error writing communication packets)
> 010208 03:54:55 mysqld restarted
> Alan
>
>
> --------------------------------------------------------------------
-
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
