Versions Compared

Old Version 3

changes.mady.by.user Joseph Baxter

Saved on

compared with

New Version 4

changes.mady.by.user Joseph Baxter

Saved on

Key

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

...

Expand
titleFine tuning

mysqld settings:

ft_min_word_len

3

key_buffer_size

384M

max_allowed_packet

16M

thread_stack256K

thread_cache_size

8

max_connections

500

query-cache-type

1

query_cache_limit

5M

query_cache_size

500M

max_heap_table_size

536870912

tmp_table_size

536870912

table_open_cache

2500

log-bin

mysql-bin

binlog_format

mixed

innodb settings:


Warning

Not convinced these are improvements on the default settings of mysql 5.7+. So I would only change them if you know what you are doing.

innodb_buffer_pool_size

2000M


innodb_additional_mem_pool_size

200M

deprecated

innodb_log_buffer_size

5M


innodb_flush_log_at_trx_commit

1


innodb_lock_wait_timeout

50


On systems with networked file storage (SANS) with slow disk IO times considerer usinginnodb_flush_log_at_trx_commit = 2. See 'adaptive flushing' for a description of the consequence.

mysqldump settings:

quick


max_allowed_packet

24M


...