gist: 22839 - temporary store mysql db in tmpfs- GitHub


  
    
      Text only #
    
    
      
      
        embed
        
      
      
      
      raw
    
  
  
  
    
      
        
          
            
            1
2
3
4
5
6
7
8
9

          
          
            
              # temporary store mysql db in tmpfs (ram)
mkdir /mnt-tmpfs
chown mysql:mysql /mnt-tmpfs/
mount -t tmpfs -o mode=700,uid=0,gid=0,size=200M tmpfs /mnt-tmpfs/
/etc/init.d/mysql stop
cp -a /var/lib/mysql/* /mnt-tmpfs/
mv /var/lib/mysql /var/lib/mysql.old
ln -s /mnt-tmpfs/ /var/lib/mysql
Description:	temporary store mysql db in tmpfs
Public Clone URL:	git://gist.github.com/22839.git Give this clone URL to anyone. `git clone git://gist.github.com/22839.git gist-22839`
Embed All Files:	show embed