mysql55RDS可配置参数IT168文库.docx
《mysql55RDS可配置参数IT168文库.docx》由会员分享,可在线阅读,更多相关《mysql55RDS可配置参数IT168文库.docx(104页珍藏版)》请在冰豆网上搜索。
mysql55RDS可配置参数IT168文库
allow-suspicious-udfs
No
engine-default
static
Controlswhetheruser-definedfunctionsthathaveonlyanxxxsymbolforthemainfunctioncanbeloaded
auto_increment_increment
Yes
engine-default
dynamic
Intendedforusewithmaster-to-masterreplication,andcanbeusedtocontroltheoperationofAUTO_INCREMENTcolumns
auto_increment_offset
Yes
engine-default
dynamic
DeterminesthestartingpointfortheAUTO_INCREMENTcolumnvalue
autocommit
Yes
engine-default
dynamic
Setstheautocommitmode
automatic_sp_privileges
Yes
engine-default
dynamic
Whenthisvariablehasavalueof1(thedefault),theserverautomaticallygrantstheEXECUTEandALTERROUTINEprivilegestothecreatorofastoredroutine,iftheusercannotalreadyexecuteandalterordroptheroutine.
back_log
Yes
engine-default
static
ThenumberofoutstandingconnectionrequestsMySQLcanhave
basedir
/rdsdbbin/mysql
No
system
static
TheMySQLinstallationbasedirectory.
binlog_cache_size
32768
Yes
system
dynamic
ThesizeofthecachetoholdtheSQLstatementsforthebinarylogduringatransaction.
binlog_format
MIXED
No
system
dynamic
Row/StatementorMixedreplication
bulk_insert_buffer_size
Yes
engine-default
dynamic
LimitsthesizeoftheMyISAMcachetreeinbytesperthread.
character-set-client-handshake
Yes
engine-default
static
Don'tignorecharactersetinformationsentbytheclient.
character_set_client
Yes
engine-default
dynamic
Thecharactersetforstatementsthatarrivefromtheclient.
character_set_connection
Yes
engine-default
dynamic
Thecharactersetusedforliteralsthatdonothaveacharactersetintroducerandfornumber-to-stringconversion.
character_set_database
Yes
engine-default
dynamic
Thecharactersetusedbythedefaultdatabase.
character_set_filesystem
Yes
engine-default
dynamic
Thefilesystemcharacterset.
character_set_results
Yes
engine-default
dynamic
Thecharactersetusedforreturningqueryresultstotheclient.
character_set_server
Yes
engine-default
dynamic
Theserver'sdefaultcharacterset.
collation_connection
Yes
engine-default
dynamic
Thecollationoftheconnectioncharacterset.
collation_server
Yes
engine-default
dynamic
Theserver'sdefaultcollation.
completion_type
Yes
engine-default
dynamic
Thetransactioncompletiontype(0-default,1-chain,2-release)
concurrent_insert
Yes
engine-default
dynamic
AllowsINSERTandSELECTstatementstorunconcurrentlyforMyISAMtablesthathavenofreeblocksinthemiddleofthedatafile.
connect_timeout
Yes
engine-default
dynamic
ThenumberofsecondsthattheMySQLdserverwaitsforaconnectpacketbeforerespondingwithBadhandshake.
datadir
/rdsdbdata/db/
No
system
static
MySQLdatadirectory
default_storage_engine
InnoDB
No
system
dynamic
Thedefaultstorageengine(tabletype).
default_time_zone
No
engine-default
static
Servercurrenttimezone
default_week_format
Yes
engine-default
dynamic
ThedefaultmodevaluetousefortheWEEK()function.
delay_key_write
Yes
engine-default
dynamic
DetermineswhenkeysareflushedforMyISAMtables
delayed_insert_limit
Yes
engine-default
dynamic
Afterinsertingdelayed_insert_limitdelayedrows,theINSERTDELAYEDhandlerthreadcheckswhetherthereareanySELECTstatementspending.Ifso,itallowsthemtoexecutebeforecontinuingtoinsertdelayedrows.
delayed_insert_timeout
Yes
engine-default
dynamic
HowmanysecondsanINSERTDELAYEDhandlerthreadshouldwaitforINSERTstatementsbeforeterminating.
delayed_queue_size
Yes
engine-default
dynamic
Ifthequeuebecomesfull,anyclientthatissuesanINSERTDELAYEDstatementwaitsuntilthereisroominthequeueagain.
div_precision_increment
Yes
engine-default
dynamic
Numberofdigitsbywhichtoincreasethescaleoftheresultofdivisionoperations.
event_scheduler
Yes
engine-default
dynamic
IndicatesthestatusoftheEventScheduler
flush
No
engine-default
dynamic
IfON,theserverflushesallchangestodiskaftereachSQLstatement.
flush_time
Yes
engine-default
dynamic
Freesupresourcesandsynchronizeunflusheddatatodisk.Recommendedonlyonsystemswithminimalresources.
ft_boolean_syntax
No
engine-default
dynamic
Thelistofoperatorssupportedbybooleanfull-textsearches
ft_max_word_len
Yes
engine-default
static
MaximumlengthofthewordtobeincludedinaFULLTEXTindex.
ft_min_word_len
Yes
engine-default
static
MinimumlengthofthewordtobeincludedinaFULLTEXTindex.
ft_query_expansion_limit
Yes
engine-default
static
Numberoftopmatchestouseforfull-textsearchesperformedusingWITHQUERYEXPANSION.
ft_stopword_file
Yes
engine-default
static
FileforFullSearchStopWords.NULLusesDefault,/dev/nulltodisableStopWords
general_log
Yes
engine-default
dynamic
Whetherthegeneralquerylogisenabled
group_concat_max_len
Yes
engine-default
dynamic
MaximumallowedresultlengthinbytesfortheGROUP_CONCAT().
init_connect
Yes
engine-default
dynamic
Stringtobeexecutedbytheserverforeachclientthatconnects.
innodb_adaptive_flushing
Yes
engine-default
dynamic
EnablesInnoDBAdaptiveFlushing(default=onforRDS)
innodb_adaptive_hash_index
Yes
engine-default
static
Whetherinnodbadaptivehashindexesareenabledordisabled
innodb_additional_mem_pool_size
2097152
Yes
system
static
Thesizeinbytesofamemorypoolinnodbusestostoredatadictionaryinformationandotherinternaldatastructures
innodb_autoextend_increment
Yes
engine-default
dynamic
Theincrementsize(inMB)forextendingthesizeofanauto-extendingtablespacefilewhenitbecomesfull
innodb_autoinc_lock_mode
Yes
engine-default
static
Thelockingmodetouseforgeneratingauto-incrementvalues
innodb_buffer_pool_instances
Yes
engine-default
static
ThenumberofregionsthattheInnoDBbufferpoolisdividedinto
innodb_buffer_pool_size
{DBInstanceClassMemory*3/4}
Yes
system
static
Thesizeinbytesofthememorybufferinnodbusestocachedataandindexesofitstables
innodb_change_buffering
Yes
engine-default
dynamic
ControlsInnoDBchangebuffering
innodb_commit_concurrency
Yes
engine-default
static
Thenumberofthreadsthatcancommitatthesametime.
innodb_concurrency_tickets
Yes
engine-default
dynamic
NumberoftimesathreadcanenterandleaveInnodbbeforeitissubjecttoinnodb-thread-concurrency
innodb_data_home_dir
/rdsdbdata/db/innodb
No
system
static
Directorywhereinnodbfilesarestored
innodb_file_format
Yes
engine-default
dynamic
SetsInnoDBPlug-indefaultfileformat.
innodb_file_per_table
1
Yes
system
static
UsetablespacesorfilesforInnodb.
innodb_flush_log_at_trx_commit
Yes
engine-default
dynamic
DeterminesInnodbtransactiondurability
innodb_flush_method
O_DIRECT
No
system
static
DeterminesInnodbflushmethod
innodb_force_load_corrupted
No
engine-default
static
LetsInnoDBloadtablesatstartupthataremarkedascorrupted
innodb_io_capacity
Yes
engine-default
dynamic
ThemaximumnumberofI/OoperationspersecondthatInnoDBwillperform.
innodb_large_prefix
Yes
engine-default
dynamic
EnablesordisablesInnodbLargePrefixforKeys
innodb_lock_wait_timeout
Yes
engine-default
static
Timeoutinsecondsaninnodbtransactionmaywaitforarowlockbeforegivingup
innodb_locks_unsafe_for_binlog
No
engine-default
static
Affectshowinnodbusesgaplockingforsearchesandindexscans
innodb_log_buffer_size
8388608
Yes
system
static
Thesizeinbytesofthebufferthatinnodbusestowritetothelogfilesondisk
innodb_log_file_size
134217728
No
system
static
Thesizeinbytesofeachlogfileinaloggroup
innodb_log_group_home_dir
/rdsdbdata/log/innodb
No
system
static
Thedirectorypathtotheinnodblogfiles
innodb_max_dirty_pages_pct
Yes
engine-default
dynamic
Maximumpercentageofdirtypagesinthebufferpool
innodb_max_purge_lag
Yes
engine-default
dynamic
ControlshowtodelayINSERT,UPDATE,andDELETEoperationswhenpurgeoperationsarelagging
innodb_old_blocks_pct
Yes
engine-default
dynamic
SpecifiestheapproximatepercentageoftheInnoDBbufferpoolusedfortheoldblocksublist.
innodb_old_blocks_time
Yes
engine-default
dynamic
Specifieshowlonginmilliseconds(ms)ablockinsertedintotheoldsublistmuststaythereafteritsfirstaccessbeforeitcanbemovedtothenewsublist.
innodb_open_files
Yes
engine-default
static
Relevantonlyifyouusemultipletablespacesininnodb.Itspecifiesthemaximumnumberof.ibdfilesthatinnodbcankeepopenatonetime
innodb_purge_batch_size
Yes
engine-default
static
Thegranularityofchanges,expressedinunitsofredologrecords,thattriggerapurgeoperation,flushingthechangedbufferpoolblockstodisk
innodb_purge_threads
Yes
engine-default
static
ThenumberofbackgroundthreadsdevotedtotheInnoDBpurgeoperation
innodb_random_read_ahead
Yes
engine-default
dynamic
EnablesordisablesInnodbRandomReadAhead
innodb_read_ahead_threshold
Yes
engine-default
dynamic
Controlsthesensitivityoflinearread-aheadthatInnoDBusestoprefetchpagesintothebuffercache.
innodb_read_io_threads
Yes
engine-default
static
ThenumberofI/OthreadsforreadoperationsinInnoDB.
innodb_replication_delay
Yes
engine-defa