Page History

...

tmp_table_size

max_heap_table_size

Key buffer size 

If your VIVO database uses MySQL’s traditional MyISAM storage engine, consult the documentation for the key_buffer_size parameter.  Increasing this value can yield significant performance benefit.

InnoDB buffer pool size

If your VIVO database uses MySQL’s newer InnoDB storage engine, consult the documentation for the innodb_buffer_pool_size parameter.  Setting this value as large as possible given available memory will improve performance.

Transaction logging 

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

...