Plesk server down every night

[mr_exclusive]

Hi,

My plesk i falling dawn every night for 5min at 4:07 until 4:12

log:

nscd: 6104 no more memory for database 'hosts'

wdcollect [7220]: SMTP server error: 'relaylock: db_connect: failed to connect do database: Error: Too many connections 220 ESMTP

free space on drive 200gb
server ram 4gb

what should i do to fix it?
please help

gr,
mr

 

[mr_exclusive]

problem fixed, i just needed to change mysql variables to higher values

 

[bcstaat]

where did you make the changes?

Thanks,
Brad

 

[mr_exclusive]

/etc/my.cfg

 

[bcstaat]

thank you!

 

[MegaCrash]

Whats variables do you change in "my.cnf" ?

 

[mr_exclusive]

key buffer 384MB

max_connections = 2500

 

[MegaCrash]

Thanks, i will try.

 

[poshtiban]

I have this problem yet.
I monitor my server and see that connectiones use pconnect method to connect mysql.
I see connect to mysql not realesed for long time untill mysql crach and restart.
this ocur after I upgrage plesk to 8.1
please help me

 

[MegaCrash]

I tried to change variables values. That helped! ThanX!

 

[cmurphy@]

Originally posted by mr_exclusive
key buffer 384MB

max_connections = 2500

It is recommended to NOT set max-connections above 700