VIVO Documentation
Old Release
This documentation relates to an old version of VIVO, version 1.9.x. Looking for another version? See all documentation.
Background
This is a new page – please bear with us as we gather the content
From the VIVO 1.5 Installation Guide
The MySQL database
Essentially all of the data that you store in VIVO will be given to MySQL for storage. The actual location of this data depends on what system you have, and on how you install MySQL but you won’t need to know the location. You will access the data through VIVO, or occasionally through the MySQL client application.
MySQL 5.1 or higher, http://www.mysql.com
Configuration considerations
The Jena SDB triple store used by default with VIVO can be configured to use a number of databases but is most commonly used with MySQL in the VIVO community.
Issues to be aware of
- A new installation of VIVO initially expects to be connected to an empty VIVO database that has been created with the character set UTF-8 so that the VIVO can read, store, and display characters encoded as Unicode
- Configuring the number of connections
Tuning MySQL
From Stony Brook –
By popular request, I've been asked to re-send information about the MySQLTuner tool. It helped give us feedback on several key mysql tuning parameters. And it gives suggestions on settings that may help your system run more efficiently, and thus your VIVO run a little bit faster.
The mysqltuner.pl script can be found at:
Overview
Content Tools
All content on the LYRASIS Wiki is licensed under the CC BY (Attribution) license
, unless otherwise noted.