sort_buffer?

[werehere]

I want to take the sort_buffer down to 500k instead of the default 2MB in MySQL.

I do not have tons of ram on my server, but have lots of connections, and I want to know if this is still safe and I would like to hear that the forum will still run with it set to 500k.

Any ideas on this anyone?

[John]

I would recommend keeping the sort buffer fairly high, especially if you have a lot of posts. It will need the ful 2mb or more if a search returns a lot of posts.

The requirements for the sort buffer have been optimised in the next version, so you may be able to get away with 500k. If you start getting errors such as table 'SQLxxxxxx' is full, then you will have to boost it up a bit.

John

[werehere]

Seems to be a touch better now, and this is somewhat temporary until we get the extra ram installed.