[CentOS] MySQL on tmpfs?

Thu Jul 27 18:52:41 UTC 2006
Mike Kercher <mike at vesol.com>

 

> -----Original Message-----
> From: centos-bounces at centos.org 
> [mailto:centos-bounces at centos.org] On Behalf Of William L. Maltby
> Sent: Thursday, July 27, 2006 1:11 PM
> To: CentOS General List
> Subject: Re: [CentOS] MySQL on tmpfs?
> 
> On Thu, 2006-07-27 at 19:58 +0200, Alexander Dalloz wrote:
> > Mike Kercher schrieb:
> > 
> > >Has anyone ever mounted their /var/lib/mysql on a tmpfs or ramfs?  
> > >Are there any performance gains to be made doing this?
> > >
> > A foolish idea to me. You imagine what happens if the 
> machine hangs up?
> 
> I wasn't going to say anything because he used "mount", not 
> "create", "generate", "make", etc. I presummed he just wanted 
> to mount the directory there. No harm, but no goin either. In 
> fact, a very smal teensy-weensy loss probably, due to the 
> extra step to get to things.
> 
> > 
> > Alexander
> > 

Thanks for the input folks!

Mike