tag:blogger.com,1999:blog-31421954.post5117314473788381957..comments2023-10-30T08:23:12.960-07:00Comments on mySQL DBA, Architecture, Dev, Scale, HA, Code : Linux 64-bit, MySQL, Swap and MemoryDathan Pattishallhttp://www.blogger.com/profile/00356367514107959723noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-31421954.post-55767328515976552372008-08-14T12:26:00.000-07:002008-08-14T12:26:00.000-07:00how would you define swap with respect to linux an...how would you define swap with respect to linux and what is the typical size of the swap space?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31421954.post-82610757791062774622008-05-03T01:48:00.000-07:002008-05-03T01:48:00.000-07:00Actually turning off swap is the best thing to do....Actually turning off swap is the best thing to do. I've never heard of kswap problems ... ??Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31421954.post-47305438548353124512008-05-02T14:13:00.000-07:002008-05-02T14:13:00.000-07:00Don's method is pretty good. Messing with swppines...Don's method is pretty good. Messing with swppiness doesn't really help. Its the fact that the VM cannot nor will not pull from system cache over swap.<BR/><BR/>Doing the last step in the post is prob the best and fastest method to get rid of swap - when you don't want to make ram-disks for swap.Dathan Pattishallhttps://www.blogger.com/profile/00356367514107959723noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-35632154440641373922008-05-02T07:09:00.000-07:002008-05-02T07:09:00.000-07:00Hi Dathan,do you use swappiness? I usually set it ...Hi Dathan,<BR/><BR/>do you use swappiness? I usually set it to 5 on my boxes, and then allocate about 80% of memory to the innodb buffer pool. Works fine, I eventually get some swapped in pages but they are never swapped out, so it doesn't really matter.Unknownhttps://www.blogger.com/profile/14357784876300417395noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-70653299970946782002008-05-01T19:33:00.000-07:002008-05-01T19:33:00.000-07:00reboot as a solution is evilreboot as a solution is evilAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-31421954.post-5811011435259206192008-05-01T18:49:00.000-07:002008-05-01T18:49:00.000-07:00Which are the best among the three choices you gav...Which are the best among the three choices you gave? It seems the third is the best simple in operation and is influence at least.dd_maclehttps://www.blogger.com/profile/01436640087997043872noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-79233126760166805162008-05-01T18:27:00.000-07:002008-05-01T18:27:00.000-07:00Hey Dathan,I hate this stupid problem, but I have ...Hey Dathan,<BR/><BR/>I hate this stupid problem, but I have a slightly different approach: http://blogs.smugmug.com/don/2008/05/01/mysql-and-the-linux-swap-problem/<BR/><BR/>Hope that helps!Anonymousnoreply@blogger.com