Re: concurrent inserts into myisam file

[Damiano C.]

>>There should be no problem with two _connections_ to the _same_ instance of mysql.

I'm talking about storage and not SQL connections. Using the myisam as a storage system imply that you write directly using its API on the tables without a SQL server doing that for you. We are not connected to any SQL server in this way.


>>But, I don't understand -- What does opening "READONLY" mean? How does one do such?

There are opening modes for the mi_open() function, and one of them is O_RDONLY (the function mirrors the common unix opening modes - O_RDONLY, O_RDWR, O_WRONLY).
As I previously stated the problem lies within the scope of the Bug #29838. The record is there but is not read for this sync problem, and a KEY NOT FOUND is returned.


>>The only read_only I know of affects _all_ connections to the server.

again, we are not connected to the server.

Thanks
D.