LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-19-2015, 03:47 PM   #1
ASTRAPI
Member
 
Registered: Feb 2007
Posts: 210

Rep: Reputation: 16
Question How can i create Mysql tmp partition as ram partition on Debian 7?


Hi

How can i create Mysql tmp partition as ram tmpfs partition on Debian 7?

Thanks

Last edited by ASTRAPI; 03-19-2015 at 03:54 PM.
 
Old 03-20-2015, 09:58 AM   #2
jpollard
Senior Member
 
Registered: Dec 2012
Location: Washington DC area
Distribution: Fedora, CentOS, Slackware
Posts: 4,713

Rep: Reputation: 1279Reputation: 1279Reputation: 1279Reputation: 1279Reputation: 1279Reputation: 1279Reputation: 1279Reputation: 1279Reputation: 1279
The same way you create the Mysql tmp directory in the first place.

the only change is to mount it as tmpfs. You will also have to add it to the /etc/fstab to get it mounted on boot.

The major problem is that tmpfs by default can take half your memory. So if you have a large database you also will need a large swap - though you can start small, and expand. You do run the risk of page fault storms as the database itself will be page faulting data in/out, as well as the tmpfs.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
script to create partition and file system on the partition mukheema Red Hat 1 02-03-2012 01:29 PM
Possibility to create swap partition if extended partition is out of space? bhavisavla Linux - Newbie 1 09-12-2011 07:39 AM
Changing /tmp from it's own partition back to root partition branisd SUSE / openSUSE 3 06-10-2010 03:20 AM
Using partition magic to create Linux partition then install EviLBoX Linux - General 5 09-12-2008 06:01 AM
Need to decrease a folder and create a new partition from the partition itself.... guy_ripper Linux - Software 2 10-29-2006 11:47 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 05:43 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration