[jacquesm]

Size your server properly and know the memory requirements of your application. That way you can guarantee that you will never hit swap.

[spudlyo]

That's a lot easier said than done. Unless you use ulimit to strictly enforce process memory limits (tricky) it's nearly impossible to know the how much memory a large complicated program (like MySQL) will allocate.