Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've heard that you can do something like the following in my.cnf to get better performance:

tmpdir = /dev/shm

I'm running MariaDB and wondering is this a good idea? All it does it create the temporary tables in memory and not disk correct.

Do I need to make certain changes in /etc/sysctl.conf so /dev/shm has space?

share|improve this question

closed as not a real question by Michael Hampton, Ward, poige, MadHatter, Khaled Apr 24 '13 at 12:30

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Are you trying to solve a problem here? – Michael Hampton Apr 24 '13 at 0:08
Reduce load. Improve perfoamnce. – Tiffany Walker Apr 24 '13 at 0:22
up vote 0 down vote accepted

I dont think that MariaDB will have any bonus writing to a tmpfs file system then it would writing to its own memory pool considering it things its writing to disk so it will be calling thinks like flush and fsync when it wont need to. What you may want to do.

You will want to make some changes to the tmp_table_size, when you have more memory then you have in tmp_table_size, it will flush everything to disk.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.