Difference between revisions of "SUNScholar/Optimisations/Database"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
#Go to: http://wiki.lib.sun.ac.za/index.php/SUNScholar/Install_DSpace/S04 | #Go to: http://wiki.lib.sun.ac.za/index.php/SUNScholar/Install_DSpace/S04 | ||
#Search the relevant <tt>'''build.properties'''</tt> file for '''''db.maxconnections = 50''''' change the number of connection to 150. | #Search the relevant <tt>'''build.properties'''</tt> file for '''''db.maxconnections = 50''''' change the number of connection to 150. | ||
| − | # | + | #And then [[Rebuild_DSpace|rebuild Dspace]]. |
==Enable the PostgreSQL DB to accept more connections== | ==Enable the PostgreSQL DB to accept more connections== | ||
Revision as of 14:26, 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. The symptom is usually a blank screen.
Allow DSpace to make more DB connections
To do this you will need to modify the DSpace configuration to make more connections.
- Go to: http://wiki.lib.sun.ac.za/index.php/SUNScholar/Install_DSpace/S04
- Search the relevant build.properties file for db.maxconnections = 50 change the number of connection to 150.
- And then rebuild Dspace.
Enable the PostgreSQL DB to accept more connections
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
