Re: mysql is a pain in the ass

[Michael Widenius]

>>>>> "Mike" == Mike Wexler <mwexler@stripped> writes:

Mike> At 03:35 PM 11/3/99 -0500, Raul Miller wrote:
>> The choice is between microsoft's sql server and postgresql.

Mike> I've been having similar problems where adhoc queries acquire a lock and 
Mike> cause simple/tuned queries to take minutes instead of fractions of a 
Mike> second. Do other SQL servers have a solution to this problem? Is there a 
Mike> solution to this problem with mysql?

Hi!

Just a note about this thread;  When it comes to INSERTS combined with 
SELECT, this is solved in MySQL 3.23.7.  In earlier versions of MySQL, 
you can probably fix this by using DELAYED, LOW_PRIORITY on update or
HIGH_PRIORITY on SELECT.

During December we should also introduce a solution that will work for 
UPDATE / DELETE...

Regards,
Monty