Difference between revisions of "SUNScholar/Optimisations/Database"
Jump to navigation
Jump to search
m (→Introduction) |
|||
| Line 8: | Line 8: | ||
==Allow DSpace to make more DB connections== | ==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 <tt>'''build.properties'''</tt> file for '''''db.maxconnections = 50'''' change the number of connection to 150. | |
| − | + | #Then rebuild Dspace. | |
| − | + | ||
==Enable the PostgreSQL DB to accept more connections== | ==Enable the PostgreSQL DB to accept more connections== | ||
Revision as of 14:25, 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.
- 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
