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"
"my.cnf"
Error I see in "maillog" due to vpopmail/courier reporting a problem:
"ps waux | grep -i sql"
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
"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