Rick,
No, I can't restart the webserver, but the sysadmins are on the lookout to see if they can determine what's going on.
But things seem fine since my last mysql restart, and I'm suspecting that the order of things might matter (ie restart mysql / change config options). Might be academic now, things seem OK: no dormant/locked processes shown in mysqladmin processlist.
mysql status shows:
*************************
ection id: 4891
Current database:
Current user: xxxxx@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.37
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 2 hours 31 min 3 sec
Threads: 1 Questions: 143606 Slow queries: 20 Opens: 78 Flush tables: 1 Ope
n tables: 64 Queries per second avg: 15.845
*********************************
I'll post again here if the problem continues to occur. Immense thanks for all the help.
Max
