|
|||||||||||
|
Re: MySQL and writing RAMFS for tmp question
From: Vladimir Shebordaev <vladimir.shebordaev(at)gmail.com>
Date: Wed Jul 25 2007 - 23:34:20 EDT
tmpfs does not use ramfs in anyway, so there is no point in "direct" ramfs usage though. By the way, I use that size=700M tmpfs mount option to mostly avoid swapping. It is my workstation, I run Gnome desktop with all its niceties, so probably I have to go to the nearest retail shop to bye more RAM chips. The system locks up later, when the swap space is exhausted. In the hope it helps.
Regards,
Mariella Petrini пиÑеÑ: > Hi, > > I had already tried tmpfs, but I wanted to use ramfs > directtly. > I have been able to make it working also with ramfs. > The problem was the following: > I set properly the permissions on the mount point > (before doing the mount), but after done the mount the > permissions had to be reset again. > > > These are the two ways I used ramfs: > > 1) > mount -t ramfs ramfs /space > > 2) > dd if=/dev/zero of=/dev/ram1 bs=512 count=97800 > mkfs.ext3 /dev/ram1 > mount /dev/ram1 /space > > > Thanks, > > Mariella > > > > --- Vladimir Shebordaev > >> Hi! >> >> Would you please elaborate in what a way did you >> mount ramfs on >> /tmp? Probably, your mysqld has literally got low >> credentials on >> it. Either your ramdisk has already been choked. >> Also ramfs is >> not so widely used for user space applications and >> primarily >> intended for kernel boot-up purposes. It is almost >> obsoleted by now. >> >> I'd suggest to try tmpfs instead. I get any problem >> with neither >> mysql-5.0.27 from Fedora Core 6 nor stock >> mysql-5.0.48 starting >> up having tmpdir on it if I >> >> mount -t tmpfs -orw,size=700M,mode=1777 /tmp /tmp >> >> If you are inclined to also try it, please notice >> that >> "size=<instance_size>" mount option. The default is >> to use not >> more than a half of your physical memory, i.e. not >> including the >> swap. It can appear too small for real life mysqld >> instance. But >> tmpfs can swap unlikely to ramfs. So, you can use >> some swap space >> for it. But not too much though. It can eat up all >> your swap, so >> that even OOM killer will not be able to reclaim >> the memory and >> the system will deadlock. As for me I've set >> size=700M with my >> 2,5G RAM and run into lockups if I let it expand >> above this amount. >> >> In the hope it helps. >> >> Regards, >> Vladimir >> >> Mariella Petrini ÿøÃËõÃâ: >>> Hi, >>> >>> Is there way with MySQL 5.0.45 on Linux Debian to >>> specify tmpdir (in my.cnf) to a directory on a >> RAMFS >>> filesystem. >>> I have tried but MySQL did not even start (it >>> generated an error saying that it could not write >>> ....) >>> >>> Thanks in advance for your help. >>> >>> I look forward to hearing from you, >>> >>> Mariella >>> >>> >>> >>> >>> >>> > ____________________________________________________________________________________ >>> Fussy? Opinionated? Impossible to please? Perfect. >> Join Yahoo!'s user panel and lay it on us. >> > http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 >>> >> > > > > > ____________________________________________________________________________________ > Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. > http://autos.yahoo.com/carfinder/ > -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/internals?unsub=lists@pantek.comReceived on Wed Jul 25 23:35:15 2007 This archive was generated by hypermail 2.1.8 : Thu Aug 09 2007 - 19:06:21 EDT |
||||||||||
|
|||||||||||