Re: MySQL and writing RAMFS for tmp question

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
>
>

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek