Re: MySQL and writing RAMFS for tmp question

From: Mariella Petrini <mariellapetrini(at)yahoo.com>
Date: Thu Jul 26 2007 - 09:47:21 EDT

I have been using 1) with MySQL 5.0.45 for tmpdir and according to the measurements taken I got an improvement (when "copying to tmp tables") on the query response time of the order of 0.0x (which in my case it is good)

Mariella

• Stewart Smith <stewart@mysql.com> wrote:

> On Wed, 2007-07-25 at 19:51 -0700, Mariella Petrini
> wrote:
> > 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
>
> This is quite silly as tmpfs uses the normal cache
> (just with no disk
> backing) and ramfs is then using RAM as a block
> device... which then
> running ext3 on (which does journalling and other
> pointless things).
>
> ramfs will be heaps more efficient. really. the
> tmpfs code is lovely and
> simple :)
> --
> Stewart Smith, Senior Software Engineer
> MySQL AB, www.mysql.com
> Office: +14082136540 Ext: 6616
> VoIP: 6616@sip.us.mysql.com
> Mobile: +61 4 3 8844 332
>
> Jumpstart your cluster:
>

http://www.mysql.com/consulting/packaged/cluster.html
>
       

---

Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. http://sims.yahoo.com/

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

Received on Thu Jul 26 10:29:20 2007