Fog Tweaks

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.
• ALL these Settings must be changed by the FOG User. If tested continuously and fully approved then these may make it into the Default Setup of fog.
• DO AT YOUR OWN RISK
• 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
• Dev. Approved One or multiple developers of Fog has approved this setting to be used in most installations of FOG.

Persistent DB Connection

• 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/upgrades to overwrite the settings above)
  6. Go to line:

     snmysqlhost="";

  7. Change to:

     snmysqlhost="p:127.0.0.1";

• If you DB is on another server, use p:[ipaddress of DB server].

= PHP Session Expiring

• Known bug in Ubuntu's config. It's running fuser for each PHP session file easily racking up thousands of processes.
  1. Open this file /etc/cron.d/php5
  2. Go to line:

     09,39 *    * * *    root  [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type f -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir fuser -s {} 2>/dev/null \; -delete

  3. Change to:

     09,39 *    * * *    root  [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type f -cmin +$(/usr/lib/php5/maxlifetime) -delete

  4. Restart apache

     service apache2 restart

Results

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