Can i use this path for better performance as tmp ?

Hi

I have a soft Raid 5 with this info:

---

Code:

/dev/md2        289G  162G  113G  59% /
tmpfs            64G     0   64G   0% /dev/shm
/dev/md0        488M  144M  320M  31% /boot
/dev/md1         64G  813M   63G   2% /tmp
tmpfs            64G  813M   63G   2% /tmp

Can i change this:

Code:

tmpdir=/home/mysqltmp

to

Code:

tmpdir=/dev/shm

for better temp performance as this is tmpfs ?

Thanks

 

Yes i know that i will never use 64gb for temp but is this a problem to use it ?

Any negatives because of the big size?

This is what i have now:

Code:

4.0K  /home/mysqltmp

 

Yes i was thinking also to use /tmp but as the /dev/shm is not used at all i was think to use this one but i am not sure if it is better or not....

 

It will be great if George comment here about /tmp and /dev/shm and about the big sizes if it is a problem and which one is better to use

 

Also do we need to force using ram by adding this on my.cnf?

Code:

tmp_table_size=2K

 

Also do we need to force using ram by adding this on my.cnf?

Code:

tmp_table_size=2K

 

I thought that was default for Centminmod and permanent change using fstab.... Why not add as default something like this?

Also i am waiting for the last answer George about forcing it to use tmpfs using:

Code:

tmp_table_size=2K

Thanks !

 

No i am not talking about default values for Centminmod to changed....

I am talking about Centminmod auto create a tmpfs and use this as tmpdir=

 

The db size is 18gb about and the /tmp is 64gb.

Do you think that is enough and i will not have any problems?

I mean the /tmp must be related to size of the db?