Difference between revisions of "SUNScholar/Optimisations/Database"
Jump to navigation
Jump to search
m |
m (→Introduction) |
||
| Line 3: | Line 3: | ||
</center> | </center> | ||
==Introduction== | ==Introduction== | ||
| − | As our repository became more popular we noticed that the number database connections increased alarmingly. It is normal web application programming practice to release/sever database connections after a particular programming task on the database is done. However with a large number of web site vistors in short period of time the number database connections available soon ran out, so we adjusted DSpace and PostgreSQL to accommodate more visitors in a short period of time. | + | As our repository became more popular we noticed that the number database connections increased alarmingly. It is normal web application programming practice to release/sever database connections after a particular programming task on the database is done. |
| + | |||
| + | However with a large number of web site vistors in a short period of time the number database connections available soon ran out, so we adjusted DSpace and PostgreSQL to accommodate more visitors in a short period of time. | ||
*Increase connection pool parameters | *Increase connection pool parameters | ||
Revision as of 14:10, 26 June 2015
Back to Optimisations
Introduction
As our repository became more popular we noticed that the number database connections increased alarmingly. It is normal web application programming practice to release/sever database connections after a particular programming task on the database is done.
However with a large number of web site vistors in a short period of time the number database connections available soon ran out, so we adjusted DSpace and PostgreSQL to accommodate more visitors in a short period of time.
- Increase connection pool parameters
The following db connection parameters are used:
max_connections = 200 max_idle_connections = 400
These paremeters are set in the "build.properties" and "postgresql.conf" files.
Check the relevant wiki guide sections for more details.
- Fix "browse index" configuration to reduce the PostgreSQL database server query load.
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Browse_Indexes
- Vacumn the database regularly
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Daily_Admin
