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.

Speed up DB queries

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

Results

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