>>>>> "Sasha" == Sasha Pachev <sasha@stripped> writes:
Sasha> Rick Moore wrote:
>> Hi Sasha!
>> > A few comments in addition to what Tonu has said:
>> > - Adding RAM is not that expensive (256 -> 512), and will speed things
>> > a bit
>> I have no issue adding more RAM, but in regards to a large key buffer Tonu
>> said: "This can be bad because memory gets fragmented. Usually symptoms are
>> like this: System is fast after start-up but will be slower and slower and
>> Slooooowwwer until next restart. Try to reduce it."
>> Did you have something in mind that the RAM should be applied to? OS
>> Caching? I don't see any other MySQL params that would help me-- am I'm
>> missing something?
Sasha> OS caching would be the most important factor, as your chances of having to
Sasha> touch the disk on an insert are much smaller. Large key buffer could still be
Sasha> better in your situation -- memory fragmentation is not as bad as having to
Sasha> touch the disk. I imagine Monty would have some enlightening things to say on
Sasha> this subject if he is not completely swamped with other things :-)
The key cache usually gives a lot of extra speed for writes but not
that much for reads; Check with mysqladmin extended-status how many
key-reads MySQL really has to do. You can safely make the key-cache
smaller if the 'key_reads' value doesn't go up much.