tag:blogger.com,1999:blog-7476449567742726187.post4453129384755432542..comments2023-12-18T12:25:52.296-08:00Comments on Database Soup: Red Hat Kernel cache clearing issueJosh Berkushttp://www.blogger.com/profile/09671139717468724246noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-7476449567742726187.post-24954575384068878102013-04-24T11:08:07.253-07:002013-04-24T11:08:07.253-07:00I just found relation between free unused memory a...I just found relation between free unused memory and a count of active process. ~1GB per backend.<br /><br />in 376GB total memmory and 32 core<br /><br />if ( user cpu + io wait ) is 145% then i have ~140GB freeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-16228248153636529302013-04-18T05:27:10.706-07:002013-04-18T05:27:10.706-07:00another one http://comments.gmane.org/gmane.comp.d...another one http://comments.gmane.org/gmane.comp.db.sqlite.general/79457Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-60525961413318264672013-04-17T03:57:11.593-07:002013-04-17T03:57:11.593-07:00was there any NFS ?was there any NFS ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-85647319111153267872013-04-16T00:29:40.383-07:002013-04-16T00:29:40.383-07:00Josh, do you know the model of CPUs with which thi...Josh, do you know the model of CPUs with which this issue was seen? amd/intel? I have got a similar case on intel, amd does work well. But it could be just a coincidence.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-86153636992493303792012-12-30T13:25:04.643-08:002012-12-30T13:25:04.643-08:00Of course, i always use echo 3 > /proc/sys/vm/d...Of course, i always use echo 3 > /proc/sys/vm/drop_caches<br /><br />Matias Colli<br />RHCSALic. Matias Collihttps://www.blogger.com/profile/05538970552645092041noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-8611637162815635192012-09-11T06:55:47.840-07:002012-09-11T06:55:47.840-07:00The buffers and caches can be cleared using these ...The buffers and caches can be cleared using these commands (at least in Linux 2.6.16 and later kernels):<br /><br /> To free pagecache:<br /> <br /> echo 1 > /proc/sys/vm/drop_caches<br /> <br /> To free dentries and inodes:<br /> <br /> echo 2 > /proc/sys/vm/drop_caches<br /> <br /> To free pagecache, dentries and inodes:<br /> <br /> echo 3 > /proc/sys/vm/drop_caches<br /><br />Matias Colli<br />RHCSALic. Matias Collihttps://www.blogger.com/profile/05538970552645092041noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-28331180894710847762012-04-26T14:56:48.610-07:002012-04-26T14:56:48.610-07:00Thanks! That narrows it down even further.
Now t...Thanks! That narrows it down even further.<br /><br />Now the other question is when the problem was introduced ...Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-3536190423984147352012-04-26T02:50:54.305-07:002012-04-26T02:50:54.305-07:002.6.32-131.0.15.el6.x86_64 doesn't seem to hav...2.6.32-131.0.15.el6.x86_64 doesn't seem to have this problem so it must have been fixed before that.Tuxiehttps://www.blogger.com/profile/05256735395978506779noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-28785599728891145722012-04-25T01:37:00.764-07:002012-04-25T01:37:00.764-07:00Do you know which exact version fixed this?Do you know which exact version fixed this?Tuxiehttps://www.blogger.com/profile/05256735395978506779noreply@blogger.com