Set the QuerySurge Database Tmp Directory (Windows)

Versions: 8.0+

Set the QuerySurge™ Database Tmp Directory (Windows)

1)      Make sure all users are out of the system and that no Scenarios are executing.

2)      For the following steps, log into each QuerySurge deployment box as Administrator.

3)      Navigate to the Windows Services console (services.msc).

4)      Using the Windows Services console, stop the QuerySurge services in the following order (whether they are on the same box or different boxes):

a)      Stop QuerySurge Agent

b)      Stop QuerySurge Statsmon

c)       Stop QuerySurge Tomcat

d)      Stop QuerySurge MySQL

The console will show the Status for each of the four QuerySurge services as blank:

 

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".

5)      In your QuerySurge installation directory, find the mysql directory (<QuerySurge Install Dir\QuerySurge\ mysql).

6)      In this directory, find the my.ini file. Make a backup copy of this file.

7)      Open the my.ini file in a text editor. You may need to run the editor as Administrator in order to edit the file.

8)      Search the file for: datadir. The default entry is:
datadir="C:\Program Files\QuerySurge/mysql/data"

9)      Search the file for: tmpdir. By default, this entry does not appear in the file, so you may not find it.

10)   If you have a tmpdir entry, edit it carefully; otherwise carefully create a new tmpdir entry under the datadir entry for the new tmp directory. Note that your entry must follow the same forward-slash and back-slash pattern as for the datadir entry. In the following example, we have created the new tmpdir entry for a directory on the D: drive:

tmpdir="D:\QuerySurge/mysql/tmp"

For QuerySurge versions 10.1 and greater, also create a new innodb_temp_tablespaces_dir entry under the tmpdir entry:

innodb_temp_tablespaces_dir="D:\QuerySurge/mysql/tmp"

11)  Continuing with this example, create a QuerySurge directory on the D:\ drive. Under the QuerySurge directory, create a mysql directory. Under the mysql directory, create a tmp directory.

12)  Using the Windows Services console, start the QuerySurge MySQL service:

If the database has started, then the notation “Started” or "Running" should appear in the Status column.

13)  If you have not edited the my.ini 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.ini (from step 6), 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.)

14)   Once the database has started, start the remaining QuerySurge services in the following order:

a)      Start QuerySurge Tomcat

b)      Start QuerySurge Statsmon

c)       Start QuerySurge Agent

15)   Log in to QuerySurge as a final check. Your QuerySurge database tmp directory should now be changed to the value you entered for tmpdir and innodb_temp_tablespaces_dir (if applicable) in my.ini.