Difference between revisions of "Fog Tweaks"
m (→Tweaks) |
m (→Tweaks) |
||
| Line 2: | Line 2: | ||
*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. | *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'''. | + | *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. |
*<span style="background-color:RED; color:Orange;">'''DO AT YOUR OWN RISK'''</span> | *<span style="background-color:RED; color:Orange;">'''DO AT YOUR OWN RISK'''</span> | ||
*'''Pros''' description of the good | *'''Pros''' description of the good | ||
| Line 10: | Line 10: | ||
== Speed up DB queries == | == Speed up DB queries == | ||
| + | === Persisten 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 | *Use a '''Persistent DB Connection'''. This uses the already established connection to get the data, rather than reopening the socket or TCP link | ||
#Open this file '''/var/www/fog/lib/fog/Config.class.php''' | #Open this file '''/var/www/fog/lib/fog/Config.class.php''' | ||
| Line 18: | Line 19: | ||
#Go to line: <pre>snmysqlhost="";</pre> | #Go to line: <pre>snmysqlhost="";</pre> | ||
#Change to: <pre>snmysqlhost="p:127.0.0.1";</pre> | #Change to: <pre>snmysqlhost="p:127.0.0.1";</pre> | ||
| + | *If you DB is on another server, use p:[ipaddress of DB server]. | ||
=Results= | =Results= | ||
Revision as of 16:09, 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.
- 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
Persisten 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
- Open this file /var/www/fog/lib/fog/Config.class.php
- Go to line:
define('DATABASE_HOST', 'localhost'); - Change to:
define('DATABASE_HOST', 'p:127.0.0.1'); - Restart mysql:
service mysql restart
- Open this file /opt/fog/.fogsettings (so updates/upgrades to overwrite the settings above)
- Go to line:
snmysqlhost="";
- 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 | ✔ |
