Versions Compared

Old Version 7

changes.mady.by.user Alex Viggio

Saved on

compared with

New Version 8

changes.mady.by.user Mark Fallu

Saved on

Key

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

...

https://github.com/rackerhacker/MySQLTuner-perl
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

...