Re: the mystery of the missing mysql.sock file

2009-12-15 Thread Keith Murphy
Thanks Johan. Yes, it shows the mysqld holding it open. Not suprising really I guess. I did check the cron jobs and the history file searching for something/someone who deleted it, but didn't find anything. Still, that is what it looks like happend. I will move the sock file to /var/run/mysql so it

Re: the mystery of the missing mysql.sock file

2009-12-15 Thread Johan De Meersman
Presumably someone deleted it :-) You can try an 'lsof -U |grep mysql' to see if any processes still have it open. If the mysqld process still has it open, it's probably not the server. Why do you keep it in /tmp, btw ? My guess would be that someone (or some process) decided it was time to clean

the mystery of the missing mysql.sock file

2009-12-15 Thread Keith Murphy
Take one perfectly functional production server running 5.0.77. It has been up and running under load for quite some time. I am using xtrabackup for backups and suddenly three or four days ago backup stop running. Investigation shows that the socket file '/tmp/mysql.sock' is no longer there. The m

Missing mysql.sock file

2003-03-01 Thread Graham Neal
Hello, I must have installed mysql incorrectly because my suse 8.0 server does not have a mysql.sock file at all. I installed mysql 3.23.48 from rpm packages I installed server bench client Max navigator shared and the required perl bench What happened. Can anyone email me a socket file? Thx --