Difference between revisions of "Fog Tweaks"

From FOG Project
Jump to: navigation, search
(Tweaks)
(Tweaks)
Line 4: Line 4:
 
*'''Pros'' description of the good
 
*'''Pros'' description of the good
 
*'''Cons''' description of the bad
 
*'''Cons''' description of the bad
*'''PvC Rating''' scale of 1 to 10, 1 being the ALL '''Con''' and 10 being ALL '''Pro'''
+
*'''PvC''' A rating scale of 1 to 10, 1 being the ALL '''Con''' and 10 being ALL '''Pro'''
 
== Speed up DB queries ==
 
== Speed up DB queries ==
  

Revision as of 15:15, 11 December 2014

Tweaks

  • The following sections are devoted to strictly performance. If there are always pros and cons when tweaking to read carefully. All Pros/Cons should be added.
  • 'Pros description of the good
  • Cons description of the bad
  • PvC A rating scale of 1 to 10, 1 being the ALL Con and 10 being ALL Pro

Speed up DB queries

  • Use a Persistent DB Connection. This uses the already established connection to get the data, rather than reopening the socket or TCP link
  1. Open this file /var/www/fog/lib/fog/Config.class.php
  2. Go to line:
    define('DATABASE_HOST',         'localhost');
  3. Change to:
    define('DATABASE_HOST',         'p:127.0.0.1');
  4. Restart mysql:
    service mysql restart
  5. Open this file /opt/fog/.fogsettings (so updates to overwrite the settings above)
  6. Go to line:
    snmysqlhost="";
  7. Change to:
    snmysqlhost="p:127.0.0.1";

Results

Option Pros Cons PvC TOM Approved
Persistent DB Connection Speed in Web GUI response time Connection is always open 9