Set the QuerySurge Database Tmp Directory (Linux)

Versions: 8.0+

Set the QuerySurge™ Database Tmp Directory (Linux)

1. Make sure all users are out of the system and that no executions are running.
2. For the following steps, log into each QuerySurge deployment box with administrative privileges.
3. Stop all of the QuerySurge services.
   • [sudo] service QuerySurge stop

   Note: While a database shutdown from the Windows Services console almost always leaves the data files intact, it is safer to use the "slow shutdown" procedure, which is described in our article QuerySurge Database Backup Procedures; see the section "Notes on QuerySurge Backups".

4. In your QuerySurge installation directory, find the mysql directory (/<QuerySurge Install Dir>/QuerySurge/mysql).
5.  In this directory, find the my.cnf file. Make a backup copy of this file.
6. Edit the my.cnf file with your preferred editor, such as vi.
7. Search the file for: tmpdir. The default entry is:
   tmpdir=/opt/QuerySurge/mysql/tmp
   
   
   For QuerySurge versions 10.1 and greater, also create a new innodb_temp_tablespaces_dir entry on the next line under the tmpdir entry:
   
   innodb_temp_tablespaces_dir=/opt/QuerySurge/mysql/tmp
   
8. Edit this file carefully. Modify the tmpdir entry to the new data directory, where you will be moving your database files.  In the following example, we have modified the tmpdir entry for a directory on /var/opt:
   tmpdir=/var/opt/QuerySurge/tmp
   
9. Continuing with this example, create a QuerySurge directory under /var/opt. Under the QuerySurge directory,  create a tmp directory by copying the entire data directory from your current installation directory (default is /opt/QuerySurge/mysql/tmp).
10. Start the QuerySurge MySQL service
    • [sudo] service QuerySurge start mysql
    If the database starts as expected you will see the message "mysql started at port <port number>"
    
    
    If you have not edited the my.cnf file correctly, the database should not start. If the database fails to start, check and fix your edits and try starting the database again.
    
    
    If you cannot start the database, revert back to your copy of my.cnf (from step 5), and start your database. Contact QuerySurge support. (You can create a helpdesk ticket from within QuerySurge itself, or on the QuerySurge website, www.querysurge.com.)
11. Once the database has started, start the remaining QuerySurge services in the following order:
    • [sudo] service QuerySurge start tomcat
    • [sudo] service QuerySurge start agent
    • [sudo] service QuerySurge start statsmon

12. Log in to QuerySurge as a final check. Your QuerySurge database tmp directory should now be changed to the value you entered for tmpdir in my.cnf.