Re: [vchkpw] Tuning mysql for vpopmail
On Thursday 30 September 2004 03:52 pm, Rainer Duffner wrote: > It's really a mysql-question - but I'll ask anyway: > If I have a .my.cnf in ~root and a my.cnf in /usr/local/etc - which one > get's used ? Or do they get used both ? > The one from ~root is mainly for some backup-scripts and doesn't contain > any tuning-options. the one in ~root is probably for the mysql client. mysql looks in the normal system areas for my.cnf (/etc/ /usr/local/etc/, and so on) -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail GnuPG Key ID: 481BF7E2 ++ scriptkitchen.com/kitchen.asc pgp3Xk6CjJtsU.pgp Description: PGP signature
Re: [vchkpw] Tuning mysql for vpopmail
Hallo Rainer - Original Message - From: "Rainer Duffner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 30, 2004 10:52 PM Subject: Re: [vchkpw] Tuning mysql for vpopmail > Am Sa, den 25.09.2004 schrieb Rick Macdougall um 2:21: > > 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. > > > > > > 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)/ > > > > > > > Hi, > > > > I use the my-large.cnf (copied to /etc/my.cnf) and I add the following > > line under the [mysqld] group > > > > set-variable = max_connections=500 > > > > Works for me (On quite a few servers). > > > It's really a mysql-question - but I'll ask anyway: > If I have a .my.cnf in ~root and a my.cnf in /usr/local/etc - which one > get's used ? Or do they get used both ? > The one from ~root is mainly for some backup-scripts and doesn't contain > any tuning-options. > > Or will both get used ? > > > cheers, > Rainer > -- > === > ~ Rainer Duffner - [EMAIL PROTECTED] ~ > ~ Freising - Munich - Germany ~ > ~Unix - Linux - BSD - OpenSource - Security ~ > ~ http://www.ultra-secure.de/~rainer/pubkey.pgp ~ > === > >
Re: [vchkpw] Tuning mysql for vpopmail
Am Sa, den 25.09.2004 schrieb Rick Macdougall um 2:21: > 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. > > > > 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)/ > > > > Hi, > > I use the my-large.cnf (copied to /etc/my.cnf) and I add the following > line under the [mysqld] group > > set-variable = max_connections=500 > > Works for me (On quite a few servers). It's really a mysql-question - but I'll ask anyway: If I have a .my.cnf in ~root and a my.cnf in /usr/local/etc - which one get's used ? Or do they get used both ? The one from ~root is mainly for some backup-scripts and doesn't contain any tuning-options. Or will both get used ? cheers, Rainer -- === ~ Rainer Duffner - [EMAIL PROTECTED] ~ ~ Freising - Munich - Germany ~ ~Unix - Linux - BSD - OpenSource - Security ~ ~ http://www.ultra-secure.de/~rainer/pubkey.pgp ~ ===
Re: [vchkpw] Tuning mysql for vpopmail
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): > @40004154ae4c2cd0fbfc 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
Re: [vchkpw] Tuning mysql for vpopmail
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. 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)/ Hi, I use the my-large.cnf (copied to /etc/my.cnf) and I add the following line under the [mysqld] group set-variable = max_connections=500 Works for me (On quite a few servers). Regards, Rick
[vchkpw] Tuning mysql for vpopmail
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. 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)/ I have high concurrency (log qmail-send): @40004154ae4c2cd0fbfc status: local 10/100 remote 150/255 My mysql setup is for default ( I haven't /etc/my.cnf created !!!) Somebody have a configuration of mysql for high concurrency and that work with vpopmail? Is possible limit vpopmail for don't use more of 100 connections? Because it reboot my mysql daemon Should I think use postgresql instead of mysql? Thanks for your suggestions Juan