Re: I got it hanged !

2001-07-16 Thread Jamie Mason
I've been experiencing a simmilar problem only with MyISAM tables. This is under 3.23.35 and 3.23.36 on Sparc/Solaris 2.7. For me the problem occurs when doing an ALTER TABLE or a simmilar operation (eg OPTIMIZE) on relatively large tables (>4 millon rows) with one or two indeces. The table in

mysqld 3.23.36 -- new connections get stuck in "Open Tables"

2001-06-18 Thread Jamie Mason
I've been experiencing some strange behaviour in which mysqld will get into an odd state. When doing certain long-running operations (see below) on large tables (5-10 million rows; 20-30 columns per row -- mix of varchar and int) with unique indeces mysqld will occasioanlly get into a confused s