RE: INSERT/REPLACE lock up in 3.23.33

2001-02-24 Thread Sinisa Milivojevic
Steven Roussey writes: Some clarification. On this table there are a lot of indexes, but there is one unique/primary key, and it is that one that the replace should be checking for. The other indexes have the same fields in different places though. Table key def is something like this:

Re: INSERT/REPLACE lock up in 3.23.33

2001-02-23 Thread Sinisa Milivojevic
Steven Roussey writes: My troubles continue with INSERTs (i posted a message about INSERT DELAYED crushing a server before). Now, I have this: We are running Linux and MySQL 3.23.30 and have similar problems. In particular we have a lot of INSERT DELAYEDs into a fixed table, and

RE: INSERT/REPLACE lock up in 3.23.33

2001-02-23 Thread Steven Roussey
Safest thing for you is to use our latest 3.23 binaries which are statically linked with stable glibc and with some additional patches. For this reason and greater simplicity :) I have been using your binaries for a long time now. Part of the reason we never tested BDB tables... There can be

INSERT/REPLACE lock up in 3.23.33

2001-02-22 Thread Artem Koutchine
Hello! My troubles continue with INSERTs (i posted a message about INSERT DELAYED crushing a server before). Now, I have this: osiris:/root- mysqladmin processlist ++--+---+---+-+--++---