Haafiz Dossa wrote:
> What kind of effect will disabling swap have on performance when selecting data from large tables?
It should depend on your system, its current load, etc...
It should probably lower performance, bacause trhe swap contains at least the data of dormant processes.
And above all, your question is not really related to MySQL... It is more a system (eg Linux) question than a MySQL question.
I'll suppose that disabling swap may lower the available virtual memory to MySQL (ie that MySQL can allocate, thru malloc, mmap, brk, ...) less memory without swap than with swap.
You did'nt explain why do you ask such a question...
--
Basile STARYNKEVITCH ::::
http://starynkevitch.net/Basile/