Posted by Michael Fesser on 07/13/07 16:36

..oO(Markus)

>[handling a race condition]
>
>Which is the recommended way to handle this? I guess, as MySQL 4.0 and
>MyISAM tables are a quite common configuration, there must be some
>common practice about this, but I did not find anything by googling...

Is it really necessary to keep the script compatible to outdated
versions of MySQL? The current stable is 5, the old 4.0 is not even
available for download anymore. If it still has to work on a series 4
server, then I would make at least 4.1 a requirement.

I would even drop support for MyISAM and use InnoDB instead, but that's
just a personal decision. I simply need the features of a modern engine,
so I can't take care of older installations. The same goes for PHP for
example -- my scripts require PHP 5.2, PHP 4 is dead (it's official
now). At some point you simply have to draw the line.

Micha

• Next in forum: Newbie question about multiple databases
• Prev in forum: Race condition when inserting data / MySQL 4.0+, MyISAM tables
• Thread view: Re: Race condition when inserting data / MySQL 4.0+, MyISAM tables

[Reply to this message]