When I run a couple scripts from the vBulletin software (like uninstalling a plugin) it takes forever.
When monitoring the memory usage, it shows this =>
-/+ buffers/cache: 158 381 Swap: 255 10 245
It seems that MySQL is only using a certain amount and once it does it tries to use the swap instead?
I have a 512MB slice and right now my key buffer is at 16M and max_allowed_packet is at 16M.
Is there something else I should increase or can I increase those variables and still be safe?