>>>>> "Benjamin" == Benjamin Pflugmann <philemon@stripped> writes:
Benjamin> Hi.
Benjamin> On Mon, Jan 03, 2000 at 05:48:35PM -0800, sroussey@stripped wrote:
>> We split our most used tables into 10 pieces so not all our users
>> get delayed when there is one insert going on. As I understand it,
>> MySQL 3.23.8 has page locking that depreciates the value of this
>> hack.
Benjamin> No, not page locking. There was only discussion about page locking in
Benjamin> a later version, IIRC. What it allows are SELECTs while an INSERT is
Benjamin> running (and only if there are no holes from DELETEs left in the
Benjamin> table).
Benjamin> Btw, IIRC, this feature is available since 3.23.7.
>> Is it required to change to MyISM from ISM indexes for this to work?
Benjamin> Hm. I don't remember to have this heard anywhere in the discussion of
Benjamin> the feature, so I would guess, the answer is No. But I would not bet
Benjamin> on this. I assume Monty corrects me, if I am wrong about this.
You have to use MyISAM to get this feature; I didn't want to touch
the 'quite stable' ISAM code with the large changes that was required
to get this to work.
Regards,
Monty
