
| vpngMaxOptimizationRuntime | 3 | 13:42:41 | NULL | | paramName | paramValue | last_updated | last_updatedby | SELECT * FROM sgms_config WHERE paramName IN ('vpngMaxOptimizationRuntime', 'vpngOptimizationTime')
#WORKBENCH MYSQL OPTIMIZER UPDATE#
Update sgms_config set paramValue = '1' where paramName='vpngOptimizationTime' ĭ) The final results should be the same as the one below:

Update sgms_config set paramValue='2' where paramName='vpngMaxOptimizationRuntime' If results do display use the following commands: Insert into sgms_config(paramNAme,paramValue) values ('vpngOptimizationTime','1') Insert into sgms_config(paramNAme,paramValue) values ('vpngMaxOptimizationRuntime','2') and

ī) Then use this command and check if it displays anything: SELECT * FROM sgms_config WHERE paramName IN ('vpngMaxOptimizationRuntime', 'vpngOptimizationTime') Ĭ) If there is nothing there, use commands: NET Framework 4 and Microsoft Visual C++ 2010 Redistributable Package installed).ī) Open MySQL Workbench and set up new connection to your database - as "Hostname" use the IP address of your GMS/Analyzer.Ī) Type the command: use sgmsdb and click on "execute".
#WORKBENCH MYSQL OPTIMIZER INSTALL#
Step 1: Creating connection to the database.Ī) Download MySQL Workbench and install it on a PC which is on the same subnet as the GMS/Analyzer. The issue is that "Next Scheduled Email/Archive Time" can't be changed and it comes with the error that Optimization is in progress.
