API tools faq
paste
Advertisement
bslinger

Untitled

bslinger
Jun 25th, 2019
283
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 50.87 KB | None | 0 0
raw download clone embed print report
  1. {
  2.     "Marker": "aW5ub2RiX2Z0X3Jlc3VsdF9jYWNoZV9saW1pdA==",
  3.     "Parameters": [
  4.         {
  5.             "ApplyMethod": "pending-reboot",
  6.             "Description": "Controls whether user-defined functions that have only an xxx symbol for the main function can be loaded",
  7.             "DataType": "boolean",
  8.             "AllowedValues": "0,1",
  9.             "Source": "engine-default",
  10.             "IsModifiable": false,
  11.             "ParameterName": "allow-suspicious-udfs",
  12.             "ApplyType": "static"
  13.         },
  14.         {
  15.             "ApplyMethod": "pending-reboot",
  16.             "Description": "Intended for use with master-to-master replication, and can be used to control the operation of AUTO_INCREMENT columns",
  17.             "DataType": "integer",
  18.             "AllowedValues": "1-65535",
  19.             "Source": "engine-default",
  20.             "IsModifiable": true,
  21.             "ParameterName": "auto_increment_increment",
  22.             "ApplyType": "dynamic"
  23.         },
  24.         {
  25.             "ApplyMethod": "pending-reboot",
  26.             "Description": "Determines the starting point for the AUTO_INCREMENT column value",
  27.             "DataType": "integer",
  28.             "AllowedValues": "1-65535",
  29.             "Source": "engine-default",
  30.             "IsModifiable": true,
  31.             "ParameterName": "auto_increment_offset",
  32.             "ApplyType": "dynamic"
  33.         },
  34.         {
  35.             "ApplyMethod": "pending-reboot",
  36.             "Description": "Sets the autocommit mode",
  37.             "DataType": "boolean",
  38.             "AllowedValues": "0,1",
  39.             "Source": "engine-default",
  40.             "IsModifiable": true,
  41.             "ParameterName": "autocommit",
  42.             "ApplyType": "dynamic"
  43.         },
  44.         {
  45.             "ApplyMethod": "pending-reboot",
  46.             "Description": "When this variable has a value of 1 (the default), the server automatically grants the EXECUTE and ALTER ROUTINE privileges to the creator of a stored routine, if the user cannot already execute and alter or drop the routine.",
  47.             "DataType": "boolean",
  48.             "AllowedValues": "0,1",
  49.             "Source": "engine-default",
  50.             "IsModifiable": true,
  51.             "ParameterName": "automatic_sp_privileges",
  52.             "ApplyType": "dynamic"
  53.         },
  54.         {
  55.             "ApplyMethod": "pending-reboot",
  56.             "Description": "The number of outstanding connection requests MySQL can have",
  57.             "DataType": "integer",
  58.             "AllowedValues": "1-65535",
  59.             "Source": "engine-default",
  60.             "IsModifiable": true,
  61.             "ParameterName": "back_log",
  62.             "ApplyType": "static"
  63.         },
  64.         {
  65.             "ApplyMethod": "pending-reboot",
  66.             "Description": "The MySQL installation base directory.",
  67.             "DataType": "string",
  68.             "IsModifiable": false,
  69.             "Source": "system",
  70.             "ParameterValue": "/rdsdbbin/mysql",
  71.             "ParameterName": "basedir",
  72.             "ApplyType": "static"
  73.         },
  74.         {
  75.             "ApplyMethod": "pending-reboot",
  76.             "Description": "The size of the cache to hold the SQL statements for the binary log during a transaction.",
  77.             "DataType": "integer",
  78.             "IsModifiable": true,
  79.             "AllowedValues": "4096-18446744073709547520",
  80.             "Source": "system",
  81.             "ParameterValue": "32768",
  82.             "ParameterName": "binlog_cache_size",
  83.             "ApplyType": "dynamic"
  84.         },
  85.         {
  86.             "ApplyMethod": "pending-reboot",
  87.             "Description": "When enabled, this variable causes the master to write a checksum for each event in the binary log.",
  88.             "DataType": "string",
  89.             "AllowedValues": "NONE,CRC32",
  90.             "Source": "engine-default",
  91.             "IsModifiable": true,
  92.             "ParameterName": "binlog_checksum",
  93.             "ApplyType": "dynamic"
  94.         },
  95.         {
  96.             "ApplyMethod": "pending-reboot",
  97.             "Description": "Controls what happens when the server cannot write to the binary log.",
  98.             "DataType": "string",
  99.             "AllowedValues": "IGNORE_ERROR,ABORT_SERVER",
  100.             "Source": "engine-default",
  101.             "IsModifiable": false,
  102.             "ParameterName": "binlog_error_action",
  103.             "MinimumEngineVersion": "5.6.22",
  104.             "ApplyType": "dynamic"
  105.         },
  106.         {
  107.             "ApplyMethod": "pending-reboot",
  108.             "Description": "Row-based, Statement-based or Mixed replication",
  109.             "DataType": "string",
  110.             "IsModifiable": true,
  111.             "AllowedValues": "ROW,STATEMENT,MIXED",
  112.             "Source": "system",
  113.             "ParameterValue": "MIXED",
  114.             "ParameterName": "binlog_format",
  115.             "ApplyType": "dynamic"
  116.         },
  117.         {
  118.             "ApplyMethod": "pending-reboot",
  119.             "Description": "How long in microseconds to keep reading transactions from the flush queue before proceeding with the group commit (and syncing the log to disk, if sync_binlog is greater than 0). If the value is 0 (the default), there is no timeout and the server keeps reading new transactions until the queue is empty.",
  120.             "DataType": "integer",
  121.             "AllowedValues": "0-100000",
  122.             "Source": "engine-default",
  123.             "IsModifiable": true,
  124.             "ParameterName": "binlog_max_flush_queue_time",
  125.             "ApplyType": "dynamic"
  126.         },
  127.         {
  128.             "ApplyMethod": "pending-reboot",
  129.             "Description": "If this variable is enabled (the default), transactions are committed in the same order they are written to the binary log. If disabled, transactions may be committed in parallel.",
  130.             "DataType": "boolean",
  131.             "AllowedValues": "0,1",
  132.             "Source": "engine-default",
  133.             "IsModifiable": true,
  134.             "ParameterName": "binlog_order_commits",
  135.             "ApplyType": "dynamic"
  136.         },
  137.         {
  138.             "ApplyMethod": "pending-reboot",
  139.             "Description": "Whether the server logs full or minmal rows with row-based replication.",
  140.             "DataType": "string",
  141.             "AllowedValues": "full,minimal,noblob",
  142.             "Source": "engine-default",
  143.             "IsModifiable": true,
  144.             "ParameterName": "binlog_row_image",
  145.             "ApplyType": "dynamic"
  146.         },
  147.         {
  148.             "ApplyMethod": "pending-reboot",
  149.             "Description": "When enabled, it causes a MySQL 5.6.2 or later server to write informational log events such as row query log events into its binary log.",
  150.             "DataType": "boolean",
  151.             "AllowedValues": "0,1",
  152.             "Source": "engine-default",
  153.             "IsModifiable": true,
  154.             "ParameterName": "binlog_rows_query_log_events",
  155.             "ApplyType": "dynamic"
  156.         },
  157.         {
  158.             "ApplyMethod": "pending-reboot",
  159.             "Description": "This variable determines the size of the cache for the binary log to hold nontransactional statements issued during a transaction.",
  160.             "DataType": "integer",
  161.             "AllowedValues": "4096-18446744073709547520",
  162.             "Source": "engine-default",
  163.             "IsModifiable": true,
  164.             "ParameterName": "binlog_stmt_cache_size",
  165.             "ApplyType": "dynamic"
  166.         },
  167.         {
  168.             "ApplyMethod": "pending-reboot",
  169.             "Description": "Use the renamed binlog_error_action to control what happens when the server cannot write to the binary log.",
  170.             "DataType": "string",
  171.             "AllowedValues": "IGNORE_ERROR,ABORT_SERVER",
  172.             "Source": "engine-default",
  173.             "IsModifiable": false,
  174.             "ParameterName": "binlogging_impossible_mode",
  175.             "MinimumEngineVersion": "5.6.21",
  176.             "ApplyType": "dynamic"
  177.         },
  178.         {
  179.             "ApplyMethod": "pending-reboot",
  180.             "Description": "This variable controls the block encryption mode for block-based algorithms such as AES. It affects encryption for AES_ENCRYPT() and AES_DECRYPT().",
  181.             "DataType": "string",
  182.             "AllowedValues": "aes-128-ecb,aes-192-ecb,aes-256-ecb,aes-128-cbc,aes-192-cbc,aes-256-cbc",
  183.             "Source": "engine-default",
  184.             "IsModifiable": true,
  185.             "ParameterName": "block_encryption_mode",
  186.             "MinimumEngineVersion": "5.6.17",
  187.             "ApplyType": "dynamic"
  188.         },
  189.         {
  190.             "ApplyMethod": "pending-reboot",
  191.             "Description": "Limits the size of the MyISAM cache tree in bytes per thread.",
  192.             "DataType": "integer",
  193.             "AllowedValues": "0-18446744073709547520",
  194.             "Source": "engine-default",
  195.             "IsModifiable": true,
  196.             "ParameterName": "bulk_insert_buffer_size",
  197.             "ApplyType": "dynamic"
  198.         },
  199.         {
  200.             "ApplyMethod": "pending-reboot",
  201.             "Description": "Don't ignore character set information sent by the client.",
  202.             "DataType": "boolean",
  203.             "AllowedValues": "0,1",
  204.             "Source": "engine-default",
  205.             "IsModifiable": true,
  206.             "ParameterName": "character-set-client-handshake",
  207.             "ApplyType": "static"
  208.         },
  209.         {
  210.             "ApplyMethod": "pending-reboot",
  211.             "Description": "The character set for statements that arrive from the client.",
  212.             "DataType": "string",
  213.             "AllowedValues": "big5,dec8,cp850,hp8,koi8r,latin1,latin2,swe7,ascii,ujis,sjis,hebrew,tis620,euckr,koi8u,gb2312,greek,cp1250,gbk,latin5,armscii8,utf8,cp866,keybcs2,macce,macroman,cp852,latin7,utf8mb4,cp1251,cp1256,cp1257,binary,geostd8,cp932,eucjpms",
  214.             "Source": "engine-default",
  215.             "IsModifiable": true,
  216.             "ParameterName": "character_set_client",
  217.             "ApplyType": "dynamic"
  218.         },
  219.         {
  220.             "ApplyMethod": "pending-reboot",
  221.             "Description": "The character set used for literals that do not have a character set introducer and for number-to-string conversion.",
  222.             "DataType": "string",
  223.             "AllowedValues": "big5,dec8,cp850,hp8,koi8r,latin1,latin2,swe7,ascii,ujis,sjis,hebrew,tis620,euckr,koi8u,gb2312,greek,cp1250,gbk,latin5,armscii8,utf8,ucs2,cp866,keybcs2,macce,macroman,cp852,latin7,utf8mb4,cp1251,utf16,cp1256,cp1257,utf32,binary,geostd8,cp932,eucjpms",
  224.             "Source": "engine-default",
  225.             "IsModifiable": true,
  226.             "ParameterName": "character_set_connection",
  227.             "ApplyType": "dynamic"
  228.         },
  229.         {
  230.             "ApplyMethod": "pending-reboot",
  231.             "Description": "The character set used by the default database.",
  232.             "DataType": "string",
  233.             "AllowedValues": "big5,dec8,cp850,hp8,koi8r,latin1,latin2,swe7,ascii,ujis,sjis,hebrew,tis620,euckr,koi8u,gb2312,greek,cp1250,gbk,latin5,armscii8,utf8,ucs2,cp866,keybcs2,macce,macroman,cp852,latin7,utf8mb4,cp1251,utf16,cp1256,cp1257,utf32,binary,geostd8,cp932,eucjpms",
  234.             "Source": "engine-default",
  235.             "IsModifiable": true,
  236.             "ParameterName": "character_set_database",
  237.             "ApplyType": "dynamic"
  238.         },
  239.         {
  240.             "ApplyMethod": "pending-reboot",
  241.             "Description": "The file system character set.",
  242.             "DataType": "string",
  243.             "AllowedValues": "big5,dec8,cp850,hp8,koi8r,latin1,latin2,swe7,ascii,ujis,sjis,hebrew,tis620,euckr,koi8u,gb2312,greek,cp1250,gbk,latin5,armscii8,utf8,ucs2,cp866,keybcs2,macce,macroman,cp852,latin7,utf8mb4,cp1251,utf16,cp1256,cp1257,utf32,binary,geostd8,cp932,eucjpms",
  244.             "Source": "engine-default",
  245.             "IsModifiable": true,
  246.             "ParameterName": "character_set_filesystem",
  247.             "ApplyType": "dynamic"
  248.         },
  249.         {
  250.             "ApplyMethod": "pending-reboot",
  251.             "Description": "The character set used for returning query results to the client.",
  252.             "DataType": "string",
  253.             "AllowedValues": "big5,dec8,cp850,hp8,koi8r,latin1,latin2,swe7,ascii,ujis,sjis,hebrew,tis620,euckr,koi8u,gb2312,greek,cp1250,gbk,latin5,armscii8,utf8,ucs2,cp866,keybcs2,macce,macroman,cp852,latin7,utf8mb4,cp1251,utf16,cp1256,cp1257,utf32,binary,geostd8,cp932,eucjpms",
  254.             "Source": "engine-default",
  255.             "IsModifiable": true,
  256.             "ParameterName": "character_set_results",
  257.             "ApplyType": "dynamic"
  258.         },
  259.         {
  260.             "ApplyMethod": "pending-reboot",
  261.             "Description": "The server's default character set.",
  262.             "DataType": "string",
  263.             "AllowedValues": "big5,dec8,cp850,hp8,koi8r,latin1,latin2,swe7,ascii,ujis,sjis,hebrew,tis620,euckr,koi8u,gb2312,greek,cp1250,gbk,latin5,armscii8,utf8,ucs2,cp866,keybcs2,macce,macroman,cp852,latin7,utf8mb4,cp1251,utf16,cp1256,cp1257,utf32,binary,geostd8,cp932,eucjpms",
  264.             "Source": "engine-default",
  265.             "IsModifiable": true,
  266.             "ParameterName": "character_set_server",
  267.             "ApplyType": "dynamic"
  268.         },
  269.         {
  270.             "ApplyMethod": "pending-reboot",
  271.             "Description": "The collation of the connection character set.",
  272.             "DataType": "string",
  273.             "AllowedValues": "big5_chinese_ci,big5_bin,dec8_swedish_ci,dec8_bin,cp850_general_ci,cp850_bin,hp8_english_ci,hp8_bin,koi8r_general_ci,koi8r_bin,latin1_german1_ci,latin1_swedish_ci,latin1_danish_ci,latin1_german2_ci,latin1_bin,latin1_general_ci,latin1_general_cs,latin1_spanish_ci,latin2_czech_cs,latin2_general_ci,latin2_hungarian_ci,latin2_croatian_ci,latin2_bin,swe7_swedish_ci,swe7_bin,ascii_general_ci,ascii_bin,ujis_japanese_ci,ujis_bin,sjis_japanese_ci,sjis_bin,hebrew_general_ci,hebrew_bin,tis620_thai_ci,tis620_bin,euckr_korean_ci,euckr_bin,koi8u_general_ci,koi8u_bin,gb2312_chinese_ci,gb2312_bin,greek_general_ci,greek_bin,cp1250_general_ci,cp1250_czech_cs,cp1250_croatian_ci,cp1250_bin,cp1250_polish_ci,gbk_chinese_ci,gbk_bin,latin5_turkish_ci,latin5_bin,armscii8_general_ci,armscii8_bin,utf8_general_ci,utf8_bin,utf8_unicode_ci,utf8_icelandic_ci,utf8_latvian_ci,utf8_romanian_ci,utf8_slovenian_ci,utf8_polish_ci,utf8_estonian_ci,utf8_spanish_ci,utf8_swedish_ci,utf8_turkish_ci,utf8_czech_ci,utf8_danish_ci,utf8_lithuanian_ci,utf8_slovak_ci,utf8_spanish2_ci,utf8_roman_ci,utf8_persian_ci,utf8_esperanto_ci,utf8_hungarian_ci,utf8_sinhala_ci,ucs2_general_ci,ucs2_bin,ucs2_unicode_ci,ucs2_icelandic_ci,ucs2_latvian_ci,ucs2_romanian_ci,ucs2_slovenian_ci,ucs2_polish_ci,ucs2_estonian_ci,ucs2_spanish_ci,ucs2_swedish_ci,ucs2_turkish_ci,ucs2_czech_ci,ucs2_danish_ci,ucs2_lithuanian_ci,ucs2_slovak_ci,ucs2_spanish2_ci,ucs2_roman_ci,ucs2_persian_ci,ucs2_esperanto_ci,ucs2_hungarian_ci,ucs2_sinhala_ci,cp866_general_ci,cp866_bin,keybcs2_general_ci,keybcs2_bin,macce_general_ci,macce_bin,macroman_general_ci,macroman_bin,cp852_general_ci,cp852_bin,latin7_estonian_cs,latin7_general_ci,latin7_general_cs,latin7_bin,utf8mb4_general_ci,utf8mb4_bin,utf8mb4_unicode_ci,utf8mb4_icelandic_ci,utf8mb4_latvian_ci,utf8mb4_romanian_ci,utf8mb4_slovenian_ci,utf8mb4_polish_ci,utf8mb4_estonian_ci,utf8mb4_spanish_ci,utf8mb4_swedish_ci,utf8mb4_turkish_ci,utf8mb4_czech_ci,utf8mb4_danish_ci,utf8mb4_lithuanian_ci,utf8mb4_slovak_ci,utf8mb4_spanish2_ci,utf8mb4_roman_ci,utf8mb4_persian_ci,utf8mb4_esperanto_ci,utf8mb4_hungarian_ci,utf8mb4_sinhala_ci,cp1251_bulgarian_ci,cp1251_ukrainian_ci,cp1251_bin,cp1251_general_ci,cp1251_general_cs,utf16_general_ci,utf16_bin,utf16_unicode_ci,utf16_icelandic_ci,utf16_latvian_ci,utf16_romanian_ci,utf16_slovenian_ci,utf16_polish_ci,utf16_estonian_ci,utf16_spanish_ci,utf16_swedish_ci,utf16_turkish_ci,utf16_czech_ci,utf16_danish_ci,utf16_lithuanian_ci,utf16_slovak_ci,utf16_spanish2_ci,utf16_roman_ci,utf16_persian_ci,utf16_esperanto_ci,utf16_hungarian_ci,utf16_sinhala_ci,cp1256_general_ci,cp1256_bin,cp1257_lithuanian_ci,cp1257_bin,cp1257_general_ci,utf32_general_ci,utf32_bin,utf32_unicode_ci,utf32_icelandic_ci,utf32_latvian_ci,utf32_romanian_ci,utf32_slovenian_ci,utf32_polish_ci,utf32_estonian_ci,utf32_spanish_ci,utf32_swedish_ci,utf32_turkish_ci,utf32_czech_ci,utf32_danish_ci,utf32_lithuanian_ci,utf32_slovak_ci,utf32_spanish2_ci,utf32_roman_ci,utf32_persian_ci,utf32_esperanto_ci,utf32_hungarian_ci,utf32_sinhala_ci,binary,geostd8_general_ci,geostd8_bin,cp932_japanese_ci,cp932_bin,eucjpms_japanese_ci,eucjpms_bin",
  274.             "Source": "engine-default",
  275.             "IsModifiable": true,
  276.             "ParameterName": "collation_connection",
  277.             "ApplyType": "dynamic"
  278.         },
  279.         {
  280.             "ApplyMethod": "pending-reboot",
  281.             "Description": "The server's default collation.",
  282.             "DataType": "string",
  283.             "AllowedValues": "big5_chinese_ci,big5_bin,dec8_swedish_ci,dec8_bin,cp850_general_ci,cp850_bin,hp8_english_ci,hp8_bin,koi8r_general_ci,koi8r_bin,latin1_german1_ci,latin1_swedish_ci,latin1_danish_ci,latin1_german2_ci,latin1_bin,latin1_general_ci,latin1_general_cs,latin1_spanish_ci,latin2_czech_cs,latin2_general_ci,latin2_hungarian_ci,latin2_croatian_ci,latin2_bin,swe7_swedish_ci,swe7_bin,ascii_general_ci,ascii_bin,ujis_japanese_ci,ujis_bin,sjis_japanese_ci,sjis_bin,hebrew_general_ci,hebrew_bin,tis620_thai_ci,tis620_bin,euckr_korean_ci,euckr_bin,koi8u_general_ci,koi8u_bin,gb2312_chinese_ci,gb2312_bin,greek_general_ci,greek_bin,cp1250_general_ci,cp1250_czech_cs,cp1250_croatian_ci,cp1250_bin,cp1250_polish_ci,gbk_chinese_ci,gbk_bin,latin5_turkish_ci,latin5_bin,armscii8_general_ci,armscii8_bin,utf8_general_ci,utf8_bin,utf8_unicode_ci,utf8_icelandic_ci,utf8_latvian_ci,utf8_romanian_ci,utf8_slovenian_ci,utf8_polish_ci,utf8_estonian_ci,utf8_spanish_ci,utf8_swedish_ci,utf8_turkish_ci,utf8_czech_ci,utf8_danish_ci,utf8_lithuanian_ci,utf8_slovak_ci,utf8_spanish2_ci,utf8_roman_ci,utf8_persian_ci,utf8_esperanto_ci,utf8_hungarian_ci,utf8_sinhala_ci,ucs2_general_ci,ucs2_bin,ucs2_unicode_ci,ucs2_icelandic_ci,ucs2_latvian_ci,ucs2_romanian_ci,ucs2_slovenian_ci,ucs2_polish_ci,ucs2_estonian_ci,ucs2_spanish_ci,ucs2_swedish_ci,ucs2_turkish_ci,ucs2_czech_ci,ucs2_danish_ci,ucs2_lithuanian_ci,ucs2_slovak_ci,ucs2_spanish2_ci,ucs2_roman_ci,ucs2_persian_ci,ucs2_esperanto_ci,ucs2_hungarian_ci,ucs2_sinhala_ci,cp866_general_ci,cp866_bin,keybcs2_general_ci,keybcs2_bin,macce_general_ci,macce_bin,macroman_general_ci,macroman_bin,cp852_general_ci,cp852_bin,latin7_estonian_cs,latin7_general_ci,latin7_general_cs,latin7_bin,utf8mb4_general_ci,utf8mb4_bin,utf8mb4_unicode_ci,utf8mb4_icelandic_ci,utf8mb4_latvian_ci,utf8mb4_romanian_ci,utf8mb4_slovenian_ci,utf8mb4_polish_ci,utf8mb4_estonian_ci,utf8mb4_spanish_ci,utf8mb4_swedish_ci,utf8mb4_turkish_ci,utf8mb4_czech_ci,utf8mb4_danish_ci,utf8mb4_lithuanian_ci,utf8mb4_slovak_ci,utf8mb4_spanish2_ci,utf8mb4_roman_ci,utf8mb4_persian_ci,utf8mb4_esperanto_ci,utf8mb4_hungarian_ci,utf8mb4_sinhala_ci,cp1251_bulgarian_ci,cp1251_ukrainian_ci,cp1251_bin,cp1251_general_ci,cp1251_general_cs,utf16_general_ci,utf16_bin,utf16_unicode_ci,utf16_icelandic_ci,utf16_latvian_ci,utf16_romanian_ci,utf16_slovenian_ci,utf16_polish_ci,utf16_estonian_ci,utf16_spanish_ci,utf16_swedish_ci,utf16_turkish_ci,utf16_czech_ci,utf16_danish_ci,utf16_lithuanian_ci,utf16_slovak_ci,utf16_spanish2_ci,utf16_roman_ci,utf16_persian_ci,utf16_esperanto_ci,utf16_hungarian_ci,utf16_sinhala_ci,cp1256_general_ci,cp1256_bin,cp1257_lithuanian_ci,cp1257_bin,cp1257_general_ci,utf32_general_ci,utf32_bin,utf32_unicode_ci,utf32_icelandic_ci,utf32_latvian_ci,utf32_romanian_ci,utf32_slovenian_ci,utf32_polish_ci,utf32_estonian_ci,utf32_spanish_ci,utf32_swedish_ci,utf32_turkish_ci,utf32_czech_ci,utf32_danish_ci,utf32_lithuanian_ci,utf32_slovak_ci,utf32_spanish2_ci,utf32_roman_ci,utf32_persian_ci,utf32_esperanto_ci,utf32_hungarian_ci,utf32_sinhala_ci,binary,geostd8_general_ci,geostd8_bin,cp932_japanese_ci,cp932_bin,eucjpms_japanese_ci,eucjpms_bin",
  284.             "Source": "engine-default",
  285.             "IsModifiable": true,
  286.             "ParameterName": "collation_server",
  287.             "ApplyType": "dynamic"
  288.         },
  289.         {
  290.             "ApplyMethod": "pending-reboot",
  291.             "Description": "The transaction completion type (0 - default, 1 - chain, 2 - release)",
  292.             "DataType": "integer",
  293.             "AllowedValues": "0-2",
  294.             "Source": "engine-default",
  295.             "IsModifiable": true,
  296.             "ParameterName": "completion_type",
  297.             "ApplyType": "dynamic"
  298.         },
  299.         {
  300.             "ApplyMethod": "pending-reboot",
  301.             "Description": "Allows INSERT and SELECT statements to run concurrently for MyISAM tables that have no free blocks in the middle of the data file.",
  302.             "DataType": "integer",
  303.             "AllowedValues": "0-2",
  304.             "Source": "engine-default",
  305.             "IsModifiable": true,
  306.             "ParameterName": "concurrent_insert",
  307.             "ApplyType": "dynamic"
  308.         },
  309.         {
  310.             "ApplyMethod": "pending-reboot",
  311.             "Description": "The number of seconds that the MySQLd  server waits for a connect packet before responding with Bad handshake.",
  312.             "DataType": "integer",
  313.             "AllowedValues": "2-31536000",
  314.             "Source": "engine-default",
  315.             "IsModifiable": true,
  316.             "ParameterName": "connect_timeout",
  317.             "ApplyType": "dynamic"
  318.         },
  319.         {
  320.             "ApplyMethod": "pending-reboot",
  321.             "Description": "Write a core file if mysqld dies.",
  322.             "DataType": "boolean",
  323.             "AllowedValues": "0,1",
  324.             "Source": "engine-default",
  325.             "IsModifiable": false,
  326.             "ParameterName": "core-file",
  327.             "ApplyType": "static"
  328.         },
  329.         {
  330.             "ApplyMethod": "pending-reboot",
  331.             "Description": "MySQL data directory",
  332.             "DataType": "string",
  333.             "IsModifiable": false,
  334.             "Source": "system",
  335.             "ParameterValue": "/rdsdbdata/db/",
  336.             "ParameterName": "datadir",
  337.             "ApplyType": "static"
  338.         },
  339.         {
  340.             "ApplyMethod": "pending-reboot",
  341.             "Description": "The default storage engine (table type).",
  342.             "DataType": "string",
  343.             "IsModifiable": false,
  344.             "AllowedValues": "InnoDB,MRG_MYISAM,BLACKHOLE,CSV,MEMORY,FEDERATED,ARCHIVE,MyISAM",
  345.             "Source": "system",
  346.             "ParameterValue": "InnoDB",
  347.             "ParameterName": "default_storage_engine",
  348.             "ApplyType": "dynamic"
  349.         },
  350.         {
  351.             "ApplyMethod": "pending-reboot",
  352.             "Description": "Server current time zone",
  353.             "DataType": "string",
  354.             "Source": "engine-default",
  355.             "IsModifiable": false,
  356.             "ParameterName": "default_time_zone",
  357.             "ApplyType": "static"
  358.         },
  359.         {
  360.             "ApplyMethod": "pending-reboot",
  361.             "Description": "The default storage engine for TEMPORARY tables.",
  362.             "DataType": "string",
  363.             "Source": "engine-default",
  364.             "IsModifiable": false,
  365.             "ParameterName": "default_tmp_storage_engine",
  366.             "ApplyType": "dynamic"
  367.         },
  368.         {
  369.             "ApplyMethod": "pending-reboot",
  370.             "Description": "The default mode value to use for the WEEK() function.",
  371.             "DataType": "integer",
  372.             "AllowedValues": "0-7",
  373.             "Source": "engine-default",
  374.             "IsModifiable": true,
  375.             "ParameterName": "default_week_format",
  376.             "ApplyType": "dynamic"
  377.         },
  378.         {
  379.             "ApplyMethod": "pending-reboot",
  380.             "Description": "Determines when keys are flushed for MyISAM tables",
  381.             "DataType": "string",
  382.             "AllowedValues": "OFF,ON,ALL",
  383.             "Source": "engine-default",
  384.             "IsModifiable": true,
  385.             "ParameterName": "delay_key_write",
  386.             "ApplyType": "dynamic"
  387.         },
  388.         {
  389.             "ApplyMethod": "pending-reboot",
  390.             "Description": "After inserting delayed_insert_limit delayed rows, the INSERT DELAYED handler thread checks whether there are any SELECT statements pending. If so, it allows them to execute before continuing to insert delayed rows.",
  391.             "DataType": "integer",
  392.             "AllowedValues": "1-9223372036854775807",
  393.             "Source": "engine-default",
  394.             "IsModifiable": true,
  395.             "ParameterName": "delayed_insert_limit",
  396.             "ApplyType": "dynamic"
  397.         },
  398.         {
  399.             "ApplyMethod": "pending-reboot",
  400.             "Description": "How many seconds an INSERT DELAYED handler thread should wait for INSERT statements before terminating.",
  401.             "DataType": "integer",
  402.             "AllowedValues": "1-31536000",
  403.             "Source": "engine-default",
  404.             "IsModifiable": true,
  405.             "ParameterName": "delayed_insert_timeout",
  406.             "ApplyType": "dynamic"
  407.         },
  408.         {
  409.             "ApplyMethod": "pending-reboot",
  410.             "Description": "If the queue becomes full, any client that issues an INSERT DELAYED statement waits until there is room in the queue again.",
  411.             "DataType": "integer",
  412.             "AllowedValues": "1-9223372036854775807",
  413.             "Source": "engine-default",
  414.             "IsModifiable": true,
  415.             "ParameterName": "delayed_queue_size",
  416.             "ApplyType": "dynamic"
  417.         },
  418.         {
  419.             "ApplyMethod": "pending-reboot",
  420.             "Description": "Number of digits by which to increase the scale of the result of division operations.",
  421.             "DataType": "integer",
  422.             "AllowedValues": "0-30",
  423.             "Source": "engine-default",
  424.             "IsModifiable": true,
  425.             "ParameterName": "div_precision_increment",
  426.             "ApplyType": "dynamic"
  427.         },
  428.         {
  429.             "ApplyMethod": "pending-reboot",
  430.             "Description": "Whether optimizer JSON output should add end markers.",
  431.             "DataType": "boolean",
  432.             "AllowedValues": "0,1",
  433.             "Source": "engine-default",
  434.             "IsModifiable": true,
  435.             "ParameterName": "end_markers_in_json",
  436.             "ApplyType": "dynamic"
  437.         },
  438.         {
  439.             "ApplyMethod": "pending-reboot",
  440.             "Description": "When this variable is true, execution is allowed of only those statements that can be logged in a transactionally safe manner.",
  441.             "DataType": "boolean",
  442.             "AllowedValues": "0,1",
  443.             "Source": "engine-default",
  444.             "IsModifiable": false,
  445.             "ParameterName": "enforce_gtid_consistency",
  446.             "ApplyType": "static"
  447.         },
  448.         {
  449.             "ApplyMethod": "pending-reboot",
  450.             "Description": "Number of equality ranges when the optimizer should switch from using index dives to index statistics.",
  451.             "DataType": "integer",
  452.             "AllowedValues": "0-4294967295",
  453.             "Source": "engine-default",
  454.             "IsModifiable": true,
  455.             "ParameterName": "eq_range_index_dive_limit",
  456.             "ApplyType": "dynamic"
  457.         },
  458.         {
  459.             "ApplyMethod": "pending-reboot",
  460.             "Description": "Indicates the status of the Event Scheduler",
  461.             "DataType": "string",
  462.             "AllowedValues": "ON,OFF",
  463.             "Source": "engine-default",
  464.             "IsModifiable": true,
  465.             "ParameterName": "event_scheduler",
  466.             "ApplyType": "dynamic"
  467.         },
  468.         {
  469.             "ApplyMethod": "pending-reboot",
  470.             "Description": "Needed for 5.6.7",
  471.             "DataType": "boolean",
  472.             "IsModifiable": true,
  473.             "AllowedValues": "0,1",
  474.             "Source": "system",
  475.             "ParameterValue": "1",
  476.             "ParameterName": "explicit_defaults_for_timestamp",
  477.             "ApplyType": "static"
  478.         },
  479.         {
  480.             "ApplyMethod": "pending-reboot",
  481.             "Description": "If ON, the server flushes all changes to disk after each SQL statement.",
  482.             "DataType": "boolean",
  483.             "AllowedValues": "0,1",
  484.             "Source": "engine-default",
  485.             "IsModifiable": false,
  486.             "ParameterName": "flush",
  487.             "ApplyType": "dynamic"
  488.         },
  489.         {
  490.             "ApplyMethod": "pending-reboot",
  491.             "Description": "Frees up resources and synchronize unflushed data to disk. Recommended only on systems with minimal resources.",
  492.             "DataType": "integer",
  493.             "AllowedValues": "0-31536000",
  494.             "Source": "engine-default",
  495.             "IsModifiable": true,
  496.             "ParameterName": "flush_time",
  497.             "ApplyType": "dynamic"
  498.         },
  499.         {
  500.             "ApplyMethod": "pending-reboot",
  501.             "Description": "The list of operators supported by boolean full-text searches",
  502.             "DataType": "string",
  503.             "Source": "engine-default",
  504.             "IsModifiable": false,
  505.             "ParameterName": "ft_boolean_syntax",
  506.             "ApplyType": "dynamic"
  507.         },
  508.         {
  509.             "ApplyMethod": "pending-reboot",
  510.             "Description": "Maximum length of the word to be included in a FULLTEXT index.",
  511.             "DataType": "integer",
  512.             "AllowedValues": "10-84",
  513.             "Source": "engine-default",
  514.             "IsModifiable": true,
  515.             "ParameterName": "ft_max_word_len",
  516.             "ApplyType": "static"
  517.         },
  518.         {
  519.             "ApplyMethod": "pending-reboot",
  520.             "Description": "Minimum length of the word to be included in a FULLTEXT index.",
  521.             "DataType": "integer",
  522.             "AllowedValues": "1-84",
  523.             "Source": "engine-default",
  524.             "IsModifiable": true,
  525.             "ParameterName": "ft_min_word_len",
  526.             "ApplyType": "static"
  527.         },
  528.         {
  529.             "ApplyMethod": "pending-reboot",
  530.             "Description": "Number of top matches to use for full-text searches performed using WITH QUERY EXPANSION.",
  531.             "DataType": "integer",
  532.             "AllowedValues": "0-1000",
  533.             "Source": "engine-default",
  534.             "IsModifiable": true,
  535.             "ParameterName": "ft_query_expansion_limit",
  536.             "ApplyType": "static"
  537.         },
  538.         {
  539.             "ApplyMethod": "pending-reboot",
  540.             "Description": "File for Full Search Stop Words. NULL uses Default, /dev/null to disable Stop Words",
  541.             "DataType": "string",
  542.             "AllowedValues": "/dev/null",
  543.             "Source": "engine-default",
  544.             "IsModifiable": true,
  545.             "ParameterName": "ft_stopword_file",
  546.             "ApplyType": "static"
  547.         },
  548.         {
  549.             "ApplyMethod": "immediate",
  550.             "Description": "Whether the general query log is enabled",
  551.             "DataType": "boolean",
  552.             "IsModifiable": true,
  553.             "AllowedValues": "0,1",
  554.             "Source": "user",
  555.             "ParameterValue": "0",
  556.             "ParameterName": "general_log",
  557.             "ApplyType": "dynamic"
  558.         },
  559.         {
  560.             "ApplyMethod": "pending-reboot",
  561.             "Description": "Location of mysql general log.",
  562.             "DataType": "string",
  563.             "IsModifiable": false,
  564.             "Source": "system",
  565.             "ParameterValue": "/rdsdbdata/log/general/mysql-general.log",
  566.             "ParameterName": "general_log_file",
  567.             "ApplyType": "dynamic"
  568.         },
  569.         {
  570.             "ApplyMethod": "pending-reboot",
  571.             "Description": "Maximum allowed result length in bytes for the GROUP_CONCAT().",
  572.             "DataType": "integer",
  573.             "AllowedValues": "4-18446744073709547520",
  574.             "Source": "engine-default",
  575.             "IsModifiable": true,
  576.             "ParameterName": "group_concat_max_len",
  577.             "ApplyType": "dynamic"
  578.         },
  579.         {
  580.             "ApplyMethod": "pending-reboot",
  581.             "Description": "This option specifies whether GTIDs are enabled",
  582.             "DataType": "string",
  583.             "IsModifiable": false,
  584.             "AllowedValues": "OFF,ON",
  585.             "Source": "system",
  586.             "ParameterValue": "OFF",
  587.             "ParameterName": "gtid-mode",
  588.             "ApplyType": "static"
  589.         },
  590.         {
  591.             "ApplyMethod": "pending-reboot",
  592.             "Description": "The size of the internal host cache.",
  593.             "DataType": "integer",
  594.             "AllowedValues": "0-65536",
  595.             "Source": "engine-default",
  596.             "IsModifiable": true,
  597.             "ParameterName": "host_cache_size",
  598.             "ApplyType": "dynamic"
  599.         },
  600.         {
  601.             "ApplyMethod": "pending-reboot",
  602.             "Description": "String to be executed by the server for each client that connects.",
  603.             "DataType": "string",
  604.             "Source": "engine-default",
  605.             "IsModifiable": true,
  606.             "ParameterName": "init_connect",
  607.             "ApplyType": "dynamic"
  608.         },
  609.         {
  610.             "ApplyMethod": "pending-reboot",
  611.             "Description": "Enables InnoDB Adaptive Flushing (default=on for RDS)",
  612.             "DataType": "boolean",
  613.             "AllowedValues": "0,1",
  614.             "Source": "engine-default",
  615.             "IsModifiable": true,
  616.             "ParameterName": "innodb_adaptive_flushing",
  617.             "ApplyType": "dynamic"
  618.         },
  619.         {
  620.             "ApplyMethod": "pending-reboot",
  621.             "Description": "Low water mark representing percentage of redo log capacity at which adaptive flushing is enabled.",
  622.             "DataType": "integer",
  623.             "AllowedValues": "0-70",
  624.             "Source": "engine-default",
  625.             "IsModifiable": true,
  626.             "ParameterName": "innodb_adaptive_flushing_lwm",
  627.             "ApplyType": "dynamic"
  628.         },
  629.         {
  630.             "ApplyMethod": "pending-reboot",
  631.             "Description": "Whether innodb adaptive hash indexes are enabled or disabled",
  632.             "DataType": "boolean",
  633.             "AllowedValues": "0,1",
  634.             "Source": "engine-default",
  635.             "IsModifiable": true,
  636.             "ParameterName": "innodb_adaptive_hash_index",
  637.             "ApplyType": "dynamic"
  638.         },
  639.         {
  640.             "ApplyMethod": "pending-reboot",
  641.             "Description": "Allows InnoDB to automatically adjust the value of innodb_thread_sleep_delay up or down according to the current workload.",
  642.             "DataType": "integer",
  643.             "AllowedValues": "0-1000000",
  644.             "Source": "engine-default",
  645.             "IsModifiable": true,
  646.             "ParameterName": "innodb_adaptive_max_sleep_delay",
  647.             "ApplyType": "dynamic"
  648.         },
  649.         {
  650.             "ApplyMethod": "pending-reboot",
  651.             "Description": "The increment size (in MB) for extending the size of an auto-extending tablespace file when it becomes full",
  652.             "DataType": "integer",
  653.             "AllowedValues": "1-1000",
  654.             "Source": "engine-default",
  655.             "IsModifiable": true,
  656.             "ParameterName": "innodb_autoextend_increment",
  657.             "ApplyType": "dynamic"
  658.         },
  659.         {
  660.             "ApplyMethod": "pending-reboot",
  661.             "Description": "The locking mode to use for generating auto-increment values",
  662.             "DataType": "integer",
  663.             "AllowedValues": "0-2",
  664.             "Source": "engine-default",
  665.             "IsModifiable": true,
  666.             "ParameterName": "innodb_autoinc_lock_mode",
  667.             "ApplyType": "static"
  668.         },
  669.         {
  670.             "ApplyMethod": "pending-reboot",
  671.             "Description": "Specifies whether to record the pages cached in the InnoDB buffer pool when the MySQL server is shut down.",
  672.             "DataType": "boolean",
  673.             "AllowedValues": "0,1",
  674.             "Source": "engine-default",
  675.             "IsModifiable": true,
  676.             "ParameterName": "innodb_buffer_pool_dump_at_shutdown",
  677.             "ApplyType": "dynamic"
  678.         },
  679.         {
  680.             "ApplyMethod": "pending-reboot",
  681.             "Description": "Immediately records the pages cached in the InnoDB buffer pool.",
  682.             "DataType": "boolean",
  683.             "AllowedValues": "0,1",
  684.             "Source": "engine-default",
  685.             "IsModifiable": false,
  686.             "ParameterName": "innodb_buffer_pool_dump_now",
  687.             "ApplyType": "dynamic"
  688.         },
  689.         {
  690.             "ApplyMethod": "pending-reboot",
  691.             "Description": "Specifies the file that holds the list of page numbers produced by innodb_buffer_pool_dump_at_shutdown or innodb_buffer_pool_dump_now.",
  692.             "DataType": "string",
  693.             "Source": "engine-default",
  694.             "IsModifiable": false,
  695.             "ParameterName": "innodb_buffer_pool_filename",
  696.             "ApplyType": "dynamic"
  697.         },
  698.         {
  699.             "ApplyMethod": "pending-reboot",
  700.             "Description": "The number of regions that the InnoDB buffer pool is divided into",
  701.             "DataType": "integer",
  702.             "AllowedValues": "1-64",
  703.             "Source": "engine-default",
  704.             "IsModifiable": true,
  705.             "ParameterName": "innodb_buffer_pool_instances",
  706.             "ApplyType": "static"
  707.         },
  708.         {
  709.             "ApplyMethod": "pending-reboot",
  710.             "Description": "Interrupts the process of restoring InnoDB buffer pool contents triggered by innodb_buffer_pool_load_at_startup or innodb_buffer_pool_load_now.",
  711.             "DataType": "boolean",
  712.             "AllowedValues": "0,1",
  713.             "Source": "engine-default",
  714.             "IsModifiable": false,
  715.             "ParameterName": "innodb_buffer_pool_load_abort",
  716.             "ApplyType": "dynamic"
  717.         },
  718.         {
  719.             "ApplyMethod": "pending-reboot",
  720.             "Description": "Specifies that, on MySQL server startup, the InnoDB buffer pool is automatically warmed up by loading the same pages it held at an earlier time.",
  721.             "DataType": "boolean",
  722.             "AllowedValues": "0,1",
  723.             "Source": "engine-default",
  724.             "IsModifiable": true,
  725.             "ParameterName": "innodb_buffer_pool_load_at_startup",
  726.             "ApplyType": "static"
  727.         },
  728.         {
  729.             "ApplyMethod": "pending-reboot",
  730.             "Description": "Immediately warms up the InnoDB buffer pool by loading a set of data pages, without waiting for a server restart. ",
  731.             "DataType": "boolean",
  732.             "AllowedValues": "0,1",
  733.             "Source": "engine-default",
  734.             "IsModifiable": false,
  735.             "ParameterName": "innodb_buffer_pool_load_now",
  736.             "ApplyType": "dynamic"
  737.         },
  738.         {
  739.             "ApplyMethod": "pending-reboot",
  740.             "Description": "The size in bytes of the memory buffer innodb uses to cache data and indexes of its tables",
  741.             "DataType": "integer",
  742.             "IsModifiable": true,
  743.             "AllowedValues": "5242880-18446744073709551615",
  744.             "Source": "system",
  745.             "ParameterValue": "{DBInstanceClassMemory*3/4}",
  746.             "ParameterName": "innodb_buffer_pool_size",
  747.             "ApplyType": "static"
  748.         },
  749.         {
  750.             "ApplyMethod": "pending-reboot",
  751.             "Description": "Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool.",
  752.             "DataType": "integer",
  753.             "AllowedValues": "0-50",
  754.             "Source": "engine-default",
  755.             "IsModifiable": true,
  756.             "ParameterName": "innodb_change_buffer_max_size",
  757.             "ApplyType": "dynamic"
  758.         },
  759.         {
  760.             "ApplyMethod": "pending-reboot",
  761.             "Description": "Controls InnoDB change buffering",
  762.             "DataType": "string",
  763.             "AllowedValues": "inserts,deletes,purges,changes,all,none",
  764.             "Source": "engine-default",
  765.             "IsModifiable": true,
  766.             "ParameterName": "innodb_change_buffering",
  767.             "ApplyType": "dynamic"
  768.         },
  769.         {
  770.             "ApplyMethod": "pending-reboot",
  771.             "Description": "Specifies how to generate and verify the checksum stored in each disk block of each InnoDB tablespace.",
  772.             "DataType": "string",
  773.             "AllowedValues": "crc32,innodb,none,strict_crc32,strict_innodb,strict_none",
  774.             "Source": "engine-default",
  775.             "IsModifiable": true,
  776.             "ParameterName": "innodb_checksum_algorithm",
  777.             "ApplyType": "dynamic"
  778.         },
  779.         {
  780.             "ApplyMethod": "pending-reboot",
  781.             "Description": "Enables per-index compression-related statistics in the INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX table.",
  782.             "DataType": "boolean",
  783.             "AllowedValues": "0,1",
  784.             "Source": "engine-default",
  785.             "IsModifiable": true,
  786.             "ParameterName": "innodb_cmp_per_index_enabled",
  787.             "ApplyType": "dynamic"
  788.         },
  789.         {
  790.             "ApplyMethod": "pending-reboot",
  791.             "Description": "The number of threads that can commit at the same time.",
  792.             "DataType": "integer",
  793.             "AllowedValues": "0-1000",
  794.             "Source": "engine-default",
  795.             "IsModifiable": true,
  796.             "ParameterName": "innodb_commit_concurrency",
  797.             "ApplyType": "static"
  798.         },
  799.         {
  800.             "ApplyMethod": "pending-reboot",
  801.             "Description": "Sets the cutoff point at which MySQL begins adding padding within compressed pages to avoid expensive compression failures.",
  802.             "DataType": "integer",
  803.             "AllowedValues": "0-100",
  804.             "Source": "engine-default",
  805.             "IsModifiable": true,
  806.             "ParameterName": "innodb_compression_failure_threshold_pct",
  807.             "ApplyType": "dynamic"
  808.         },
  809.         {
  810.             "ApplyMethod": "pending-reboot",
  811.             "Description": "Sets the cutoff point at which MySQL begins adding padding within compressed pages to avoid expensive compression failures.",
  812.             "DataType": "integer",
  813.             "AllowedValues": "0-9",
  814.             "Source": "engine-default",
  815.             "IsModifiable": true,
  816.             "ParameterName": "innodb_compression_level",
  817.             "ApplyType": "dynamic"
  818.         },
  819.         {
  820.             "ApplyMethod": "pending-reboot",
  821.             "Description": "Specifies the maximum percentage that can be reserved as free space within each compressed page, allowing room to reorganize the data and modification log within the page when a compressed table or index is updated and the data might be recompressed.",
  822.             "DataType": "integer",
  823.             "AllowedValues": "0-75",
  824.             "Source": "engine-default",
  825.             "IsModifiable": true,
  826.             "ParameterName": "innodb_compression_pad_pct_max",
  827.             "ApplyType": "dynamic"
  828.         },
  829.         {
  830.             "ApplyMethod": "pending-reboot",
  831.             "Description": "Number of times a thread can enter and leave Innodb before it is subject to innodb-thread-concurrency",
  832.             "DataType": "integer",
  833.             "AllowedValues": "1-4294967295",
  834.             "Source": "engine-default",
  835.             "IsModifiable": true,
  836.             "ParameterName": "innodb_concurrency_tickets",
  837.             "ApplyType": "dynamic"
  838.         },
  839.         {
  840.             "ApplyMethod": "pending-reboot",
  841.             "Description": "Directory where innodb files are stored",
  842.             "DataType": "string",
  843.             "IsModifiable": false,
  844.             "Source": "system",
  845.             "ParameterValue": "/rdsdbdata/db/innodb",
  846.             "ParameterName": "innodb_data_home_dir",
  847.             "ApplyType": "static"
  848.         },
  849.         {
  850.             "ApplyMethod": "pending-reboot",
  851.             "Description": "The InnoDB shutdown mode",
  852.             "DataType": "integer",
  853.             "AllowedValues": "0,1,2",
  854.             "Source": "engine-default",
  855.             "IsModifiable": true,
  856.             "ParameterName": "innodb_fast_shutdown",
  857.             "ApplyType": "dynamic"
  858.         },
  859.         {
  860.             "ApplyMethod": "pending-reboot",
  861.             "Description": "Sets InnoDB Plug-in default file format.",
  862.             "DataType": "string",
  863.             "AllowedValues": "Antelope,Barracuda",
  864.             "Source": "engine-default",
  865.             "IsModifiable": true,
  866.             "ParameterName": "innodb_file_format",
  867.             "ApplyType": "dynamic"
  868.         },
  869.         {
  870.             "ApplyMethod": "pending-reboot",
  871.             "Description": "Use tablespaces or files for Innodb.",
  872.             "DataType": "boolean",
  873.             "IsModifiable": true,
  874.             "AllowedValues": "0,1",
  875.             "Source": "system",
  876.             "ParameterValue": "1",
  877.             "ParameterName": "innodb_file_per_table",
  878.             "ApplyType": "dynamic"
  879.         },
  880.         {
  881.             "ApplyMethod": "pending-reboot",
  882.             "Description": "Write and flush the logs every N seconds. This setting has an effect only when innodb_flush_log_at_trx_commit has a value of 2.",
  883.             "DataType": "integer",
  884.             "AllowedValues": "0-2700",
  885.             "Source": "engine-default",
  886.             "IsModifiable": false,
  887.             "ParameterName": "innodb_flush_log_at_timeout",
  888.             "ApplyType": "dynamic"
  889.         },
  890.         {
  891.             "ApplyMethod": "pending-reboot",
  892.             "Description": "Determines Innodb transaction durability",
  893.             "DataType": "integer",
  894.             "AllowedValues": "0-2",
  895.             "Source": "engine-default",
  896.             "IsModifiable": true,
  897.             "ParameterName": "innodb_flush_log_at_trx_commit",
  898.             "ApplyType": "dynamic"
  899.         },
  900.         {
  901.             "ApplyMethod": "pending-reboot",
  902.             "Description": "Determines Innodb flush method",
  903.             "DataType": "string",
  904.             "IsModifiable": true,
  905.             "AllowedValues": "O_DIRECT",
  906.             "Source": "system",
  907.             "ParameterValue": "O_DIRECT",
  908.             "ParameterName": "innodb_flush_method",
  909.             "ApplyType": "static"
  910.         },
  911.         {
  912.             "ApplyMethod": "pending-reboot",
  913.             "Description": "Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent.",
  914.             "DataType": "integer",
  915.             "AllowedValues": "0-2",
  916.             "Source": "engine-default",
  917.             "IsModifiable": true,
  918.             "ParameterName": "innodb_flush_neighbors",
  919.             "ApplyType": "dynamic"
  920.         },
  921.         {
  922.             "ApplyMethod": "pending-reboot",
  923.             "Description": "Number of iterations for which InnoDB keeps the previously calculated snapshot of the flushing state, controlling how quickly adaptive flushing responds to changing workloads.",
  924.             "DataType": "integer",
  925.             "AllowedValues": "1-1000",
  926.             "Source": "engine-default",
  927.             "IsModifiable": false,
  928.             "ParameterName": "innodb_flushing_avg_loops",
  929.             "ApplyType": "dynamic"
  930.         },
  931.         {
  932.             "ApplyMethod": "pending-reboot",
  933.             "Description": "Lets InnoDB load tables at startup that are marked as corrupted",
  934.             "DataType": "boolean",
  935.             "AllowedValues": "0,1",
  936.             "Source": "engine-default",
  937.             "IsModifiable": false,
  938.             "ParameterName": "innodb_force_load_corrupted",
  939.             "ApplyType": "static"
  940.         },
  941.         {
  942.             "ApplyMethod": "pending-reboot",
  943.             "Description": "Specifies the qualified name of an InnoDB table containing a FULLTEXT index.",
  944.             "DataType": "string",
  945.             "Source": "engine-default",
  946.             "IsModifiable": true,
  947.             "ParameterName": "innodb_ft_aux_table",
  948.             "ApplyType": "dynamic"
  949.         },
  950.         {
  951.             "ApplyMethod": "pending-reboot",
  952.             "Description": "Size of the cache that holds a parsed document in memory while creating an InnoDB FULLTEXT index.",
  953.             "DataType": "integer",
  954.             "AllowedValues": "0-4294967295",
  955.             "Source": "engine-default",
  956.             "IsModifiable": true,
  957.             "ParameterName": "innodb_ft_cache_size",
  958.             "ApplyType": "static"
  959.         },
  960.         {
  961.             "ApplyMethod": "pending-reboot",
  962.             "Description": "Specifies that a set of stopwords is associated with an InnoDB FULLTEXT index at the time the index is created.",
  963.             "DataType": "boolean",
  964.             "AllowedValues": "0,1",
  965.             "Source": "engine-default",
  966.             "IsModifiable": true,
  967.             "ParameterName": "innodb_ft_enable_stopword",
  968.             "ApplyType": "dynamic"
  969.         },
  970.         {
  971.             "ApplyMethod": "pending-reboot",
  972.             "Description": "Maximum length of words that are stored in an InnoDB FULLTEXT index.",
  973.             "DataType": "integer",
  974.             "AllowedValues": "10-252",
  975.             "Source": "engine-default",
  976.             "IsModifiable": true,
  977.             "ParameterName": "innodb_ft_max_token_size",
  978.             "ApplyType": "static"
  979.         },
  980.         {
  981.             "ApplyMethod": "pending-reboot",
  982.             "Description": "Minimum length of words that are stored in an InnoDB FULLTEXT index.",
  983.             "DataType": "integer",
  984.             "AllowedValues": "0-16",
  985.             "Source": "engine-default",
  986.             "IsModifiable": true,
  987.             "ParameterName": "innodb_ft_min_token_size",
  988.             "ApplyType": "static"
  989.         },
  990.         {
  991.             "ApplyMethod": "pending-reboot",
  992.             "Description": "Number of words to process during each OPTIMIZE TABLE operation on an InnoDB FULLTEXT index.",
  993.             "DataType": "integer",
  994.             "AllowedValues": "1-4294967295",
  995.             "Source": "engine-default",
  996.             "IsModifiable": true,
  997.             "ParameterName": "innodb_ft_num_word_optimize",
  998.             "ApplyType": "dynamic"
  999.         },
  1000.         {
  1001.             "ApplyMethod": "pending-reboot",
  1002.             "Description": "The InnoDB FULLTEXT search (FTS) query result cache limit (defined in bytes) per FTS query or per thread.",
  1003.             "DataType": "integer",
  1004.             "AllowedValues": "1000000-4294967295",
  1005.             "Source": "engine-default",
  1006.             "IsModifiable": true,
  1007.             "ParameterName": "innodb_ft_result_cache_limit",
  1008.             "MinimumEngineVersion": "5.6.13",
  1009.             "ApplyType": "dynamic"
  1010.         }
  1011.     ]
  1012. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!