Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Server not running enough daemons

Status
Not open for further replies.

thedaver

IS-IT--Management
Jul 12, 2001
2,741
US
I have a server (linux) with mysql 3.23.58 running. I had to have my provider power cycle the box for unknown reasons, now I'm getting some odd behavior from an otherwise well-working system.

"mysql stat"
Code:
--------------
mysql  Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

Connection id:          10
Current database:
Current user:           root@localhost
Current pager:          stdout
Using outfile:          ''
Server version:         3.23.58
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 2 min 31 sec

Threads: 4  Questions: 46  Slow queries: 0  Opens: 13  Flush tables: 1  Open tables: 7 Queries per second avg: 0.305
--------------

"my.cnf"
Code:
===========================================
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# skip_networking
skip-innodb

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
===========================================

Error I see in "maillog" due to vpopmail/courier reporting a problem:
Code:
Aug 23 13:13:06 myhost authdaemond: vmysql: sql error[3]: MySQL server has gone away

"ps waux | grep -i sql"
Code:
root     11073  0.0  0.1  5284 1104 pts/0    S    13:26   0:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid

mysql    11102  0.0  0.5 32180 5640 pts/0    Sl   13:26   0:00 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking

I had REALLY expected to see about 6-10 mysqld child daemons running along side the one daemon that is legimately running. What's gone bad? Thanks!


D.E.R. Management - IT Project Management Consulting
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top