C.3. Parameters with New Defaults

For better out-of-the-box performance, InnoDB Plugin 1.0.4 changes the default values for the following configuration parameters:

Table C.2. InnoDB Plugin Parameters with New Defaults

NameOld DefaultNew Default
innodb_additional_mem_pool_size1MB8MB
innodb_buffer_pool_size8MB128MB
innodb_log_buffer_size1MB8MB
innodb_max_dirty_pages_pct9075
innodb_sync_spin_loops2030
innodb_thread_concurrency80

User Comments
  Posted by Daniël van Eeden on December 23, 2010
Since 5.5.5 the default-storage-engine is set to InnoDB by default.
Sign Up Login You must be logged in to post a comment.