How can I avoid running out of space when doing certain complex table joins?
Some mSQL operations involving table joins can consume large amounts of temporary disk space. You can change the location of this temporary storage area using the following procedure: • Shutdown the mSQL database server. msqladmin shutdown • Remove the msqldb/.tmp directory from your mSQL installation directory. For example, if you installed mSQL in /usr/local/Minerva run the following command: rm -rf /usr/local/Minerva/msqldb/.tmp • Create a symbolic link from a directory with lots of space to the msqldb/.tmp directory: ln -s /lots/of/space /usr/local/Minerva/msqldb/.tmp • Restart the mSQL database server.
Related Questions
- If records are added to the CallList table on the fly while a campaign is running and the campaign is using a filter to select the records. How do the new records get picked up?
- How can I avoid running out of space when doing certain complex table joins?
- Does Alex Ferguson avoid certain nationalities to work for him at Man Utd?
