Fr3d
12-31-2006, 04:14 PM
I have 4GB of swap space on my server, and 1GB of ram. According to "htop" (a nicer version of "top"), the system rarely uses more than about 40-50% of the ram, but about 300-500MB of swap space.
My mysqld server is causing a lot of lag at busy times, due to the size of the database I have... But when I increase the cache sizes, it just uses more swap, not ram... Which is a waste of time, as it's still on disk.
How can I stop it using swap space, and make it use the other unused half of my ram?
My mysqld server is causing a lot of lag at busy times, due to the size of the database I have... But when I increase the cache sizes, it just uses more swap, not ram... Which is a waste of time, as it's still on disk.
How can I stop it using swap space, and make it use the other unused half of my ram?