On Friday 24 September 2004 06:48 pm, Juan Enciso Condeņa wrote:
> Hello friends.
> I have installed vpopmail-5.2.1 + mysql-4.013 running on HP-UX alpha
> server. It has 1GB of memory with 2 proccesors.

Definitly upgrade to Tom's latest release. The 5.2.1 release is good but the
new release is much better.

> I am having problem with mysql at the hours peak. This show me the
> qmail-send log
> 2004-09-24 17:32:06.263335500 delivery 96079: failure:
> vmysql:_sql_error[3]:_Lost_connection_to_My
> SQL_server_during_query/Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/
The "Lost connection" message is from mysql.

> I have high concurrency (log qmail-send):
> @400000004154ae4c2cd0fbfc status: local 10/100 remote 150/255
> My mysql setup is for default ( I haven't  /etc/my.cnf created !!!)
You are either using more mysql connections than the default or your
mysql server is over loaded.

> Somebody have a configuration of  mysql for high concurrency and that work
> with vpopmail?
I agree with Rick, use the large configuration file. 
Unless you are running a mysql cluster I recommend commenting out the 
"log bin" line. 

You might want to use InnoDB tables, which I think are the newer ones,
then uncomment all the inno_d lines. 

> Is possible limit vpopmail for don't use more of 100 connections? 
I think the default max connections are 100. So just give more to mysql,
like Rick suggests.

> Because it reboot my mysql daemon
I'm not surprised. Hopefully the max_connections are your problem and 
everything will run smooth. If mysql is still lagging you will need to 
consider a cluster of servers and distributed mysql.

> Should I think use postgresql instead of mysql?
First, fix the max connections. mysql should do fine.

I wonder is there any documentation on how to setup email/mysql/nfs
in a cluster? I would be willing to contribute text.

Ken Jones

Reply via email to