Page History

...

A production VIVO installation often involves an Apache web server, the Tomcat servlet container, and a MySQL database server.  The numbers of available connections between each of these servers should be set to prevent unncessary bottlenecks.  Thus, the maximum number of database connections should slightly exceed the number of possible concurrent Tomcat threads, which should in turn exceed the number of simultaneous Apache connections.

...

Changing MySQL’s transaction logging settings can lead to dramatic improvements to the speed at which triples are added to or removed from the database.  For more details, see „Writing the MySQL transaction log” here: https: //wiki.duraspace.org/display/VIVO/MySQL + configuration, + tuning, + and + troubleshooting

Additional discussion

Work in progress at https://docs.google.com/a/symplectic.co.uk/document/d/1ylp9HEzJiBsBP6vx1vd-Irf8o3Ff-5vDhytOVTI5_Ho/edit#heading=h.vdtjwwvnjdn7