Mysql opening tables

2001-01-22 Thread Michael Widenius
Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello monty, Peter After I got mysql/system crash I often see the following after I Peter bring mysql up again: Peter ruby:~ # w Peter 9:37pm up 7:35, 1 user, load average: 0.01, 0.04, 0.06 Peter USER TTY FROM

Re: Mysql opening tables

2001-01-22 Thread Peter Zaitsev
Hello Michael, Tuesday, January 23, 2001, 2:02:33 AM, you wrote: Peter I saw this many times on different machines and this sequince never Peter resolves itself ( the locks never disapears). Always the only way to Peter fix this is to kill one of the queries. I killed query #16 and Peter