postfix trouble in combination with mysql

finding more and more of these in the logs:

Code:

Sep 12 14:58:21 h1550830 postfix/trivial-rewrite[17386]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Sep 12 14:58:22 h1550830 postfix/trivial-rewrite[17580]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Sep 12 14:58:23 h1550830 postfix/trivial-rewrite[17581]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:21 h1550830 postfix/trivial-rewrite[26670]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:24 h1550830 postfix/smtp[22799]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:24 h1550830 postfix/smtp[26585]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:24 h1550830 postfix/smtp[26582]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:24 h1550830 postfix/smtp[26597]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:24 h1550830 postfix/smtp[26604]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:24 h1550830 postfix/smtp[26600]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:24 h1550830 postfix/smtp[26607]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:24 h1550830 postfix/smtp[26614]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:54 h1550830 postfix/smtp[26601]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Sep 12 16:07:56 h1550830 authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Too many connections
Sep 12 16:07:56 h1550830 pop3d: authentication error: Input/output error

which is a bit odd :-( I found one single similar post here with not much of a conclusion at the end. I know my system is running a bit bad right now but there are enough mysql connections for everyone dunno how that one above timed out. but what about all those table lookup problems?

runnind up-to-date Debian installed accoring to the perfect server setup with ispcfg3

 

I think it's a load problem with your MySQL server. Did you try to optimize MySQL?

 

working on that. will post back here if I find it was related.
do you have a link to a how-to? I know enough general ones, I'd be more interested in comparing what other ispcfg3 users use.

i.e. I have 4gb of RAM and use the server in every capacity ispcfg3 enables me to: serve web pages, run DNS, serve email, run DBs...

 

I think the most important settings in the [mysqld] section of your my.cnf are query_cache_limit, query_cache_size, and query_cache_type as this configures the cache in MySQL so that MySQL doesn't have to perform so many queries.