I have 4GB of Ram in this machine. I really know nothing about tunning MySQL (I am aware of my.cnf in the /etc directory). Since I am not seeing any MySQL errors, I am not sure where to begin.

top - 10:11:30 up 23 days, 20:45,  1 user,  load average: 0.14, 0.27, 0.31
Tasks: 201 total,   1 running, 200 sleeping,   0 stopped,   0 zombie
Cpu(s): 0.4%us, 0.2%sy, 0.0%ni, 98.6%id, 0.8%wa, 0.0%hi, 0.0%si, 0.0%st
Mem:   3369668k total,  3204236k used,   165432k free,   500512k buffers
Swap:  4192956k total,      136k used,  4192820k free,  2013144k cached

Gilbert

----- Original Message ----- From: "Jake Vickers" <[EMAIL PROTECTED]>
To: <qmailtoaster-list@qmailtoaster.com>
Sent: Friday, September 14, 2007 4:51 PM
Subject: Re: [qmailtoaster] Error Message


Gilbert T. Gutierrez, Jr. wrote:
Error - no authentication database connection. Initial open.

This message goes away if I restart MySQL. I am not seeing any errors in the MySQL log as seen below. Is there some SQL tunning that needs to be done if there are more than a couple hundred users?

Gilbert

--- LOG ---
070913 17:01:54  mysqld started
070913 17:01:55  InnoDB: Started; log sequence number 0 43655
070913 17:01:55 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
070914 10:48:25 [Note] /usr/libexec/mysqld: Normal shutdown
070914 10:48:27  InnoDB: Starting shutdown...
070914 10:48:30  InnoDB: Shutdown completed; log sequence number 0 43655
070914 10:48:30 [Note] /usr/libexec/mysqld: Shutdown complete
070914 10:48:30  mysqld ended
070914 10:48:30  mysqld started
070914 10:48:31  InnoDB: Started; log sequence number 0 43655
070914 10:48:31 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution


You can adjust mysql settings by adding options to your /etc/my.cnf file.
Are you low on RAM on this system or anything? I run several hundred users on my machines without this issue.



---------------------------------------------------------------------
    QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to