Versions Compared

Old Version 8

changes.mady.by.user Mark Fallu

Saved on

compared with

New Version 9

changes.mady.by.user Jim Blake

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

see alsoTomcat server.xml configuration to support non-Roman characters (UTF-8)

Tuning MySQL

Panel

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:

https://github.com/rackerhacker/MySQLTuner-perl

Panel
From Mark at Griffith Uni -
We use an enterprise hosted MySQL ie. remote to our vivo server via gigabit ethernet.  In this configuration we have found MySQL to be a real performance bottleneck.  Here are some parameters that we have found it worthwhile experimenting with:
innodb_flush_log_at_trx_commit=2
  • this resulted in about a 3x speedup (especially for big ingests)

tmp_table_size

max_heap_table_size

key_buffer_size (needed because many of our queries include a group or sort)

Writing the MySQL transaction log

...