MySQL Forums
Forum List  »  Performance

Re: disabling swap
Posted by: STARYNKEVITCH Basile
Date: December 11, 2004 04:48AM

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/

Options: ReplyQuote


Subject
Views
Written By
Posted
3358
December 11, 2004 02:58AM
Re: disabling swap
2742
December 11, 2004 04:48AM
2530
December 11, 2004 01:08PM
2447
December 11, 2004 02:56PM
6016
December 11, 2004 08:48PM
2635
December 15, 2004 01:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.