WaffleGrid

Change default parms on several system variables to be optimal for waffle

Bug #386193 reported by MadMatt
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
WaffleGrid
New
Undecided
Yves Trudeau

Bug Description

I would make the following values the default for waffle grid :

innodb_file_per_table=1
innodb_memcached_servers='localhost'
innodb_read_io_threads=1
innodb_write_io_threads=1
innodb_io_capacity=400
innodb_enable_seq_readahead=0
innodb_enable_rnd_readahead=0

Revision history for this message
Yves Trudeau (y-trudeau) wrote :

Easy enough. It will still be possible to override in my.cnf.

Changed in wafflegrid:
assignee: nobody → Yves Trudeau (y-trudeau)
Revision history for this message
Yves Trudeau (y-trudeau) wrote :

I disagree with one of these.

innodb_write_io_threads=1 is too low, with the new code in buf0buf for mode 1, we benefit of more write threads. I suggest innodb_write_io_threads=4

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.