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?