Re: MySQL Hang and Freeze

2001-05-31 Thread Jeremy Zawodny
On Thu, May 31, 2001 at 12:37:56AM -0500, Mike Trotzke wrote: > >Have you tried putting the file in some other location (/tmp?) just to > >see if it has any effect? > > I'm not exactly sure what file you mean. But based on your comments, > I tried puting the my.conf file in /tmp and resterting---

Re: MySQL Hang and Freeze

2001-05-30 Thread Mike Trotzke
>You did do a myisamchk -eoB /var/lib/mysql/*/*.ISM ? I did do a myisamchk on all my tables, but not exactly with the -eoB option. I am, however, sure that the table files themselves are fine. As a temporary solution I have rebuilt our development server from scratch (fresh RedHat install) and

Re: MySQL Hang and Freeze

2001-05-30 Thread Mike Trotzke
>Have you tried putting the file in some other location (/tmp?) just to >see if it has any effect? I'm not exactly sure what file you mean. But based on your comments, I tried puting the my.conf file in /tmp and resterting---nothing changed. Were you refering to the mysql.sock file? Thanks, Mi

Re: MySQL Hang and Freeze

2001-05-30 Thread jaab
On Wed, 30 May 2001, Jeremy Zawodny wrote: > > Unfortunately didn't solve it for me. :( I tried copying > > /usr/share/mysql/my-medium.cnf to /etc/my.cnf and restarting... same > > behavior. Damn, I was looking forward to going out celebrating :-). *dang*. Ok. You did do a myisamchk -eoB /var/li

Re: MySQL Hang and Freeze

2001-05-30 Thread Jeremy Zawodny
On Wed, May 30, 2001 at 02:46:24PM -0500, Mike Trotzke wrote: > > >copying one of the my.cnf sample files > >from the support(?) directory to /etc/my.cnf actually solved it. > > Unfortunately didn't solve it for me. :( I tried copying > /usr/share/mysql/my-medium.cnf to /etc/my.cnf and restartin

Re: MySQL Hang and Freeze

2001-05-30 Thread Mike Trotzke
>copying one of the my.cnf sample files >from the support(?) directory to /etc/my.cnf actually solved it. Unfortunately didn't solve it for me. :( I tried copying /usr/share/mysql/my-medium.cnf to /etc/my.cnf and restarting... same behavior. Damn, I was looking forward to going out celebrating :

Re: MySQL Hang and Freeze

2001-05-30 Thread jaab
On Wed, 30 May 2001, Mike Trotzke wrote: > Never actually reads CONNECTED, even after hours. > I suspect this has something to do with the problem. > > Permissions are currently wide open as follows > (though I've tried everything): > > /var/ drwxr-xr-x root r