How can I fine tune Applications Manager Java & MySQL/ PgSQL?

How can I fine tune Applications Manager Java & MySQL/ PgSQL?

Here is how:

1.) Windows:

     a.) Open the wrapper.conf file from AppManagerHome\working\conf directory using WordPad (Run as Administrator) and change the Java memory values as below

         # Initial Java Heap Size (in MB)
         wrapper.java.initmemory=512

         
         # Maximum Java Heap Size (in MB)
         wrapper.java.maxmemory=2048


     b.) Open the startApplicationsManager.bat file from AppManagerHome\ directory (Using WordPad) change the Java memory values as below         
         -Xms512m -Xmx2048m
         

     c.) Open AppManagerHome\conf\AMServer.properties file with WordPad and check am.dbserver.type entry, if it is mysql then, under AppManagerHome\working\mysql\ directory backup the existing            my.ini file and replace it with the file attached in this wiki.

     d.) If the am.dbserver.type entry is pgsql, then under AppManagerHome\working\pgsql\data\amdb\ directory edit postgresql.conf file and change
       shared_buffers = 32MB as shared_buffers = 1024MB

     e.) Follow below steps and restart Applications Manager for the changes to take effect

         i)Start -> Run -> Services.msc -> stop the 'Manage Engine Applications Manager' service
           
         ii)Execute below command from AppManagerHome\ directory (open the command prompt using 'Run as Administrator' option)
 
         shutdownApplicationsManager.bat -force

         iii)Start -> Run -> Services.msc -> start the 'ManageEngine Applications Manager' service


2.) Linux:

       
     a.) Open the startApplicationsManager.sh file from AppManagerHome/ directory (Using vi editor) and change the Java memory values as below
         -Xms512m -Xmx2048m

     b.) Open AppManagerHome/conf/AMServer.properties file with WordPad and check am.dbserver.type entry, if it is mysql then, under AppManagerHome/working/mysql/ directory backup the existing          my.ini file and replace it with the file attached in this wiki.

     c.) If the am.dbserver.type entry is pgsql, then under AppManagerHome\working\pgsql\data\amdb\ directory edit postgresql.conf file and change
       shared_buffers = 32MB as shared_buffers = 1024MB

     d.) Execute below commands from AppManagerHome directory to restart the Applications Manager for the changes to take effect

          sh shutdownApplicationsManager.sh

         sh shutdownApplicationsManager.sh -force

         nohup sh startApplicationsManager.sh &



Note
1.) If the Applications Manager server has less than 4 GB memory,

           a.) Replace 2048 as 1024 in the parameter "-Xms512m -Xmx2048m" in the startApplicationsManager.bat (or sh)  files and  "wrapper.java.maxmemory=2048" in wrapper.conf file

           b.) Replace 1024 as 512 in the parameter "set-variable    = key_buffer=1024M"  in the my.ini file

           c.) Replace 1024 as 512 in the parameter "shared_buffers = 1024MB"  in the postgresql.conf file

           2.) You can click on the Support tab -> under the “Installation Information” -> “Working Directory” is the AppManagerHome directory.

If you have any questions, please contact support ( appmanager-support@manageengine.com )
          • Related Articles

          • How to view data under Session & Performance tab in MySQL monitor?

            Note: If the server is a MariaDB server, check whether the SYS database is installed by executing the below query on MariaDB shell: show databases; If the output does not contain the SYS database, then install the SYS database suitable for the ...
          • Maintenance of Applications Manager

            Applications Manager with MySQL database Open services.msc, stop “ManageEngine Applications Manager” service or via command prompt with administrator permission. If using command prompt, navigate to <Applications Manager Home> directory and execute ...
          • How can I upgrade the MySQL connector.jar?

            For all the following issues mentioned below, the solution is same. Invalid authorization specification message from server. Unknown character set index for field '255' received from server. Communication link failure: javax.net.ssl.SSLException. ...
          • Applications Manager DB Maintenance for PGSQL Backend

            Windows Installations Note: Please take complete db backup using the <AppManager Home>\bin\BackupPGSQLDB.bat (or BackupPGSQLDB.sh) script without fail before following the below steps: Open services.msc, stop “ManageEngine Applications ...
          • Connecting to Applications Manager's bundled database

            How can I connect to Applications Manager's back-end database? Note: Take a backup of the AppManager directory before modifying anything in the database. Check am.dbserver.type value in <Applications Manager Home>\conf\AMServer.properties file to ...