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

   snmysqlhost="";

7. Change to:

   snmysqlhost="p:127.0.0.1";

Results

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