13.7.14.1. New Parameters

Throughout the course of development, InnoDB 1.1 and its predecessor the InnoDB Plugin introduced new configuration parameters. The following table summarizes those parameters:

Table 13.10. InnoDB 1.1 New Parameter Summary

NameCmd-LineOption FileSystem VarScopeDynamicDefault
innodb_adaptive_flushingYESYESYESGLOBALYESTRUE
innodb_buffer_pool_instancesYESYESYESGLOBALYESTRUE
innodb_change_bufferingYESYESYESGLOBALYESinserts
innodb_file_formatYESYESYESGLOBALYESAntelope
innodb_file_format_checkYESYESYESGLOBALNO1
innodb_file_format_maxYESYESYESGLOBALYESAntelope for a new database; Barracuda if any tables using that file format exist in the database
innodb_io_capacityYESYESYESGLOBALYES200
innodb_old_blocks_pctYESYESYESGLOBALYES37
innodb_old_blocks_timeYESYESYESGLOBALYES0
innodb_purge_batch_sizeYESYESYESGLOBALYES0
innodb_purge_threadsYESYESYESGLOBALYES0
innodb_read_ahead_thresholdYESYESYESGLOBALYES56
innodb_read_io_threadsYESYESYESGLOBALNO4
innodb_spin_wait_delayYESYESYESGLOBALYES6
innodb_stats_sample_pagesYESYESYESGLOBALYES8
innodb_strict_modeYESYESYESGLOBAL|SESSIONYESFALSE
innodb_use_native_aioYESYESYESGLOBALNOTRUE
innodb_use_sys_mallocYESYESYESGLOBALNOTRUE
innodb_write_io_threadsYESYESYESGLOBALNO4
Copyright © 2010-2017 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout