Difference between revisions of "Fog Tweaks"
(→Results) |
m (→Speed up DB queries) |
||
| Line 9: | Line 9: | ||
*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 | ||
| − | #Go to line <pre>define('DATABASE_HOST', 'localhost');</pre> | + | #Go to line: <pre>define('DATABASE_HOST', 'localhost');</pre> |
#Change to: <pre>define('DATABASE_HOST', 'p:127.0.0.1');</pre> | #Change to: <pre>define('DATABASE_HOST', 'p:127.0.0.1');</pre> | ||
| − | + | #Restart mysql: <pre>service mysql restart</pre> | |
| + | #Open this file /opt/fog/.fogsettings | ||
| + | #Go to line: <pre>snmysqlhost="";</pre> | ||
| + | #Change to: <pre>snmysqlhost="p:127.0.0.1";</pre> | ||
=Results= | =Results= | ||
Revision as of 15:03, 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 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
- 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
- Go to line:
snmysqlhost="";
- 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 | ✔ |
