3006
3121
OPT_ENABLE_LARGE_PAGES,
3007
3122
OPT_TIMED_MUTEXES,
3008
3123
OPT_OLD_STYLE_USER_LIMITS,
3124
OPT_LOG_SLOW_ADMIN_STATEMENTS,
3009
3125
OPT_TABLE_LOCK_WAIT_TIMEOUT,
3010
3126
OPT_PLUGIN_LOAD,
3011
3127
OPT_PLUGIN_DIR,
3012
3129
OPT_PORT_OPEN_TIMEOUT,
3014
3131
OPT_KEEP_FILES_ON_CREATE,
3015
3132
OPT_GENERAL_LOG,
3016
3134
OPT_THREAD_HANDLING,
3017
3135
OPT_INNODB_ROLLBACK_ON_TIMEOUT,
3018
3136
OPT_SECURE_FILE_PRIV,
3019
3137
OPT_MIN_EXAMINED_ROW_LIMIT,
3138
OPT_LOG_SLOW_SLAVE_STATEMENTS,
3021
3140
OPT_POOL_OF_THREADS,
3022
3141
OPT_SLAVE_EXEC_MODE
3026
#define LONG_TIMEOUT ((uint32_t) 3600L*24L*365L)
3145
#define LONG_TIMEOUT ((ulong) 3600L*24L*365L)
3028
3147
struct my_option my_long_options[] =
3030
{"help", '?', N_("Display this help and exit."),
3149
{"help", '?', "Display this help and exit.",
3031
3150
(char**) &opt_help, (char**) &opt_help, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0,
3033
3152
{"abort-slave-event-count", OPT_ABORT_SLAVE_EVENT_COUNT,
3034
N_("Option used by mysql-test for debugging and testing of replication."),
3153
"Option used by mysql-test for debugging and testing of replication.",
3035
3154
(char**) &abort_slave_event_count, (char**) &abort_slave_event_count,
3036
3155
0, GET_INT, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3156
{"ansi", 'a', "Use ANSI SQL syntax instead of MySQL syntax. This mode will also set transaction isolation level 'serializable'.", 0, 0, 0,
3157
GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3037
3158
{"auto-increment-increment", OPT_AUTO_INCREMENT,
3038
N_("Auto-increment columns are incremented by this"),
3159
"Auto-increment columns are incremented by this",
3039
3160
(char**) &global_system_variables.auto_increment_increment,
3040
3161
(char**) &max_system_variables.auto_increment_increment, 0, GET_ULONG,
3041
3162
OPT_ARG, 1, 1, 65535, 0, 1, 0 },
3042
3163
{"auto-increment-offset", OPT_AUTO_INCREMENT_OFFSET,
3043
N_("Offset added to Auto-increment columns. Used when "
3044
"auto-increment-increment != 1"),
3164
"Offset added to Auto-increment columns. Used when auto-increment-increment != 1",
3045
3165
(char**) &global_system_variables.auto_increment_offset,
3046
3166
(char**) &max_system_variables.auto_increment_offset, 0, GET_ULONG, OPT_ARG,
3047
3167
1, 1, 65535, 0, 1, 0 },
3048
3168
{"basedir", 'b',
3049
N_("Path to installation directory. All paths are usually resolved "
3050
"relative to this."),
3169
"Path to installation directory. All paths are usually resolved relative to this.",
3051
3170
(char**) &mysql_home_ptr, (char**) &mysql_home_ptr, 0, GET_STR, REQUIRED_ARG,
3052
3171
0, 0, 0, 0, 0, 0},
3053
{"bind-address", OPT_BIND_ADDRESS, N_("IP address to bind to."),
3172
{"big-tables", OPT_BIG_TABLES,
3173
"Allow big result sets by saving all temporary sets on file (Solves most 'table full' errors).",
3174
0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3175
{"bind-address", OPT_BIND_ADDRESS, "IP address to bind to.",
3054
3176
(char**) &my_bind_addr_str, (char**) &my_bind_addr_str, 0, GET_STR,
3055
3177
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3056
3178
{"binlog_format", OPT_BINLOG_FORMAT,
3057
N_("Does not have any effect without '--log-bin'. "
3058
"Tell the master the form of binary logging to use: either 'row' for "
3059
"row-based binary logging, or 'statement' for statement-based binary "
3060
"logging, or 'mixed'. 'mixed' is statement-based binary logging except "
3061
"for those statements where only row-based is correct: those which "
3062
"involve user-defined functions (i.e. UDFs) or the UUID() function; for "
3063
"those, row-based binary logging is automatically used. ")
3179
"Does not have any effect without '--log-bin'. "
3180
"Tell the master the form of binary logging to use: either 'row' for "
3181
"row-based binary logging, or 'statement' for statement-based binary "
3182
"logging, or 'mixed'. 'mixed' is statement-based binary logging except "
3183
"for those statements where only row-based is correct: those which "
3184
"involve user-defined functions (i.e. UDFs) or the UUID() function; for "
3185
"those, row-based binary logging is automatically used. "
3064
3186
,(char**) &opt_binlog_format, (char**) &opt_binlog_format,
3065
3187
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3066
3188
{"binlog-do-db", OPT_BINLOG_DO_DB,
3067
N_("Tells the master it should log updates for the specified database, and "
3068
"exclude all others not explicitly mentioned."),
3189
"Tells the master it should log updates for the specified database, and exclude all others not explicitly mentioned.",
3069
3190
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3070
3191
{"binlog-ignore-db", OPT_BINLOG_IGNORE_DB,
3071
N_("Tells the master that updates to the given database should not "
3072
"be logged tothe binary log."),
3192
"Tells the master that updates to the given database should not be logged tothe binary log.",
3073
3193
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3074
3194
{"binlog-row-event-max-size", OPT_BINLOG_ROWS_EVENT_MAX_SIZE,
3075
N_("The maximum size of a row-based binary log event in bytes. Rows will "
3076
"be grouped into events smaller than this size if possible. "
3077
"The value has to be a multiple of 256."),
3078
(char**) &opt_binlog_rows_event_max_size,
3079
(char**) &opt_binlog_rows_event_max_size, 0,
3080
GET_ULONG, REQUIRED_ARG,
3081
/* def_value */ 1024, /* min_value */ 256, /* max_value */ ULONG_MAX,
3082
/* sub_size */ 0, /* block_size */ 256,
3195
"The maximum size of a row-based binary log event in bytes. Rows will be "
3196
"grouped into events smaller than this size if possible. "
3197
"The value has to be a multiple of 256.",
3198
(char**) &opt_binlog_rows_event_max_size,
3199
(char**) &opt_binlog_rows_event_max_size, 0,
3200
GET_ULONG, REQUIRED_ARG,
3201
/* def_value */ 1024, /* min_value */ 256, /* max_value */ ULONG_MAX,
3202
/* sub_size */ 0, /* block_size */ 256,
3083
3203
/* app_type */ 0
3205
#ifndef DISABLE_GRANT_OPTIONS
3206
{"bootstrap", OPT_BOOTSTRAP, "Used by mysql installation scripts.", 0, 0, 0,
3207
GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3085
3209
{"character-set-client-handshake", OPT_CHARACTER_SET_CLIENT_HANDSHAKE,
3086
N_("Don't ignore client side character set value sent during handshake."),
3210
"Don't ignore client side character set value sent during handshake.",
3087
3211
(char**) &opt_character_set_client_handshake,
3088
3212
(char**) &opt_character_set_client_handshake,
3089
3213
0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
3090
3214
{"character-set-filesystem", OPT_CHARACTER_SET_FILESYSTEM,
3091
N_("Set the filesystem character set."),
3215
"Set the filesystem character set.",
3092
3216
(char**) &character_set_filesystem_name,
3093
3217
(char**) &character_set_filesystem_name,
3094
3218
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0 },
3095
{"character-set-server", 'C',
3096
N_("Set the default character set."),
3219
{"character-set-server", 'C', "Set the default character set.",
3097
3220
(char**) &default_character_set_name, (char**) &default_character_set_name,
3098
3221
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0 },
3099
3222
{"character-sets-dir", OPT_CHARSETS_DIR,
3100
N_("Directory where character sets are."), (char**) &charsets_dir,
3223
"Directory where character sets are.", (char**) &charsets_dir,
3101
3224
(char**) &charsets_dir, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3103
N_("Chroot mysqld daemon during startup."),
3225
{"chroot", 'r', "Chroot mysqld daemon during startup.",
3104
3226
(char**) &mysqld_chroot, (char**) &mysqld_chroot, 0, GET_STR, REQUIRED_ARG,
3105
3227
0, 0, 0, 0, 0, 0},
3106
{"collation-server", OPT_DEFAULT_COLLATION,
3107
N_("Set the default collation."),
3228
{"collation-server", OPT_DEFAULT_COLLATION, "Set the default collation.",
3108
3229
(char**) &default_collation_name, (char**) &default_collation_name,
3109
3230
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0 },
3110
{"completion-type", OPT_COMPLETION_TYPE,
3111
N_("Default completion type."),
3231
{"completion-type", OPT_COMPLETION_TYPE, "Default completion type.",
3112
3232
(char**) &global_system_variables.completion_type,
3113
3233
(char**) &max_system_variables.completion_type, 0, GET_ULONG,
3114
3234
REQUIRED_ARG, 0, 0, 2, 0, 1, 0},
3115
{"console", OPT_CONSOLE,
3116
N_("Write error output on screen."),
3235
{"console", OPT_CONSOLE, "Write error output on screen; Don't remove the console window on windows.",
3117
3236
(char**) &opt_console, (char**) &opt_console, 0, GET_BOOL, NO_ARG, 0, 0, 0,
3119
{"core-file", OPT_WANT_CORE,
3120
N_("Write core on errors."),
3121
0, 0, 0, GET_NO_ARG,
3238
{"core-file", OPT_WANT_CORE, "Write core on errors.", 0, 0, 0, GET_NO_ARG,
3122
3239
NO_ARG, 0, 0, 0, 0, 0, 0},
3124
N_("Path to the database root."),
3125
(char**) &mysql_data_home,
3240
{"datadir", 'h', "Path to the database root.", (char**) &mysql_data_home,
3126
3241
(char**) &mysql_data_home, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3242
{"default-character-set", 'C', "Set the default character set (deprecated option, use --character-set-server instead).",
3243
(char**) &default_character_set_name, (char**) &default_character_set_name,
3244
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0 },
3245
{"default-collation", OPT_DEFAULT_COLLATION, "Set the default collation (deprecated option, use --collation-server instead).",
3246
(char**) &default_collation_name, (char**) &default_collation_name,
3247
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0 },
3127
3248
{"default-storage-engine", OPT_STORAGE_ENGINE,
3128
N_("Set the default storage engine (table type) for tables."),
3129
(char**)&default_storage_engine_str, (char**)&default_storage_engine_str,
3130
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3131
{"default-time-zone", OPT_DEFAULT_TIME_ZONE,
3132
N_("Set the default time zone."),
3249
"Set the default storage engine (table type) for tables.",
3250
(char**)&default_storage_engine_str, (char**)&default_storage_engine_str,
3251
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3252
{"default-table-type", OPT_STORAGE_ENGINE,
3253
"(deprecated) Use --default-storage-engine.",
3254
(char**)&default_storage_engine_str, (char**)&default_storage_engine_str,
3255
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3256
{"default-time-zone", OPT_DEFAULT_TIME_ZONE, "Set the default time zone.",
3133
3257
(char**) &default_tz_name, (char**) &default_tz_name,
3134
3258
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0 },
3135
{"delay-key-write", OPT_DELAY_KEY_WRITE,
3136
N_("Type of DELAY_KEY_WRITE."),
3259
{"delay-key-write", OPT_DELAY_KEY_WRITE, "Type of DELAY_KEY_WRITE.",
3137
3260
0,0,0, GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
3261
{"delay-key-write-for-all-tables", OPT_DELAY_KEY_WRITE_ALL,
3262
"Don't flush key buffers between writes for any MyISAM table (Deprecated option, use --delay-key-write=all instead).",
3263
0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3138
3264
{"disconnect-slave-event-count", OPT_DISCONNECT_SLAVE_EVENT_COUNT,
3139
N_("Option used by mysql-test for debugging and testing of replication."),
3265
"Option used by mysql-test for debugging and testing of replication.",
3140
3266
(char**) &disconnect_slave_event_count,
3141
3267
(char**) &disconnect_slave_event_count, 0, GET_INT, REQUIRED_ARG, 0, 0, 0,
3143
3269
#ifdef HAVE_STACK_TRACE_ON_SEGV
3144
{"enable-pstack", OPT_DO_PSTACK,
3145
N_("Print a symbolic stack trace on failure."),
3270
{"enable-pstack", OPT_DO_PSTACK, "Print a symbolic stack trace on failure.",
3146
3271
(char**) &opt_do_pstack, (char**) &opt_do_pstack, 0, GET_BOOL, NO_ARG, 0, 0,
3148
3273
#endif /* HAVE_STACK_TRACE_ON_SEGV */
3149
3274
{"engine-condition-pushdown",
3150
3275
OPT_ENGINE_CONDITION_PUSHDOWN,
3151
N_("Push supported query conditions to the storage engine."),
3276
"Push supported query conditions to the storage engine.",
3152
3277
(char**) &global_system_variables.engine_condition_pushdown,
3153
3278
(char**) &global_system_variables.engine_condition_pushdown,
3154
3279
0, GET_BOOL, NO_ARG, 1, 0, 0, 0, 0, 0},
3155
3280
/* See how it's handled in get_one_option() */
3157
N_("Used for debugging; Use at your own risk!"),
3158
0, 0, 0, GET_LONG, OPT_ARG, 0, 0, 0, 0, 0, 0},
3159
{"flush", OPT_FLUSH,
3160
N_("Flush tables to disk between SQL commands."),
3161
0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3281
{"exit-info", 'T', "Used for debugging; Use at your own risk!", 0, 0, 0,
3282
GET_LONG, OPT_ARG, 0, 0, 0, 0, 0, 0},
3283
{"flush", OPT_FLUSH, "Flush tables to disk between SQL commands.", 0, 0, 0,
3284
GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3162
3285
/* We must always support the next option to make scripts like mysqltest
3163
3286
easier to do */
3164
3287
{"gdb", OPT_DEBUGGING,
3165
N_("Set up signals usable for debugging"),
3288
"Set up signals usable for debugging",
3166
3289
(char**) &opt_debugging, (char**) &opt_debugging,
3167
3290
0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3168
{"init-connect", OPT_INIT_CONNECT,
3169
N_("Command(s) that are executed for each new connection"),
3291
{"general-log", OPT_GENERAL_LOG,
3292
"Enable|disable general log", (char**) &opt_log,
3293
(char**) &opt_log, 0, GET_BOOL, OPT_ARG, 0, 0, 0, 0, 0, 0},
3294
{"init-connect", OPT_INIT_CONNECT, "Command(s) that are executed for each new connection",
3170
3295
(char**) &opt_init_connect, (char**) &opt_init_connect, 0, GET_STR_ALLOC,
3171
3296
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3172
{"init-file", OPT_INIT_FILE,
3173
N_("Read SQL commands from this file at startup."),
3297
{"init-file", OPT_INIT_FILE, "Read SQL commands from this file at startup.",
3174
3298
(char**) &opt_init_file, (char**) &opt_init_file, 0, GET_STR, REQUIRED_ARG,
3175
3299
0, 0, 0, 0, 0, 0},
3176
{"init-slave", OPT_INIT_SLAVE,
3177
N_("Command(s) that are executed when a slave connects to this master"),
3300
{"init-slave", OPT_INIT_SLAVE, "Command(s) that are executed when a slave connects to this master",
3178
3301
(char**) &opt_init_slave, (char**) &opt_init_slave, 0, GET_STR_ALLOC,
3179
3302
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3180
3303
{"language", 'L',
3304
"Client error messages in given language. May be given as a full path.",
3182
3305
(char**) &language_ptr, (char**) &language_ptr, 0, GET_STR, REQUIRED_ARG,
3183
3306
0, 0, 0, 0, 0, 0},
3184
3307
{"lc-time-names", OPT_LC_TIME_NAMES,
3185
N_("Set the language used for the month names and the days of the week."),
3308
"Set the language used for the month names and the days of the week.",
3186
3309
(char**) &lc_time_names_name,
3187
3310
(char**) &lc_time_names_name,
3188
3311
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0 },
3189
3312
{"local-infile", OPT_LOCAL_INFILE,
3190
N_("Enable/disable LOAD DATA LOCAL INFILE (takes values 1|0)."),
3313
"Enable/disable LOAD DATA LOCAL INFILE (takes values 1|0).",
3191
3314
(char**) &opt_local_infile,
3192
3315
(char**) &opt_local_infile, 0, GET_BOOL, OPT_ARG,
3193
3316
1, 0, 0, 0, 0, 0},
3195
N_("Log connections and queries to file."),
3196
(char**) &opt_logname,
3317
{"log", 'l', "Log connections and queries to file.", (char**) &opt_logname,
3197
3318
(char**) &opt_logname, 0, GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
3198
3319
{"log-bin", OPT_BIN_LOG,
3199
N_("Log update queries in binary format. Optional argument is the "
3200
"location for the binary log files.(Strongly "
3201
"recommended to avoid replication problems if server's hostname "
3320
"Log update queries in binary format. Optional (but strongly recommended "
3321
"to avoid replication problems if server's hostname changes) argument "
3322
"should be the chosen location for the binary log files.",
3203
3323
(char**) &opt_bin_logname, (char**) &opt_bin_logname, 0, GET_STR_ALLOC,
3204
3324
OPT_ARG, 0, 0, 0, 0, 0, 0},
3205
3325
{"log-bin-index", OPT_BIN_LOG_INDEX,
3206
N_("File that holds the names for last binary log files."),
3326
"File that holds the names for last binary log files.",
3207
3327
(char**) &opt_binlog_index_name, (char**) &opt_binlog_index_name, 0, GET_STR,
3208
3328
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3209
{"log-error", OPT_ERROR_LOG_FILE,
3210
N_("Error log file."),
3330
This option starts with "log-bin" to emphasize that it is specific of
3333
{"log-bin-trust-function-creators", OPT_LOG_BIN_TRUST_FUNCTION_CREATORS,
3334
"If equal to 0 (the default), then when --log-bin is used, creation of "
3335
"a stored function (or trigger) is allowed only to users having the SUPER privilege "
3336
"and only if this stored function (trigger) may not break binary logging."
3337
"Note that if ALL connections to this server ALWAYS use row-based binary "
3338
"logging, the security issues do not exist and the binary logging cannot "
3339
"break, so you can safely set this to 1."
3340
,(char**) &trust_function_creators, (char**) &trust_function_creators, 0,
3341
GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3342
{"log-error", OPT_ERROR_LOG_FILE, "Error log file.",
3211
3343
(char**) &log_error_file_ptr, (char**) &log_error_file_ptr, 0, GET_STR,
3212
3344
OPT_ARG, 0, 0, 0, 0, 0, 0},
3213
{"log-isam", OPT_ISAM_LOG,
3214
N_("Log all MyISAM changes to file."),
3345
{"log-isam", OPT_ISAM_LOG, "Log all MyISAM changes to file.",
3215
3346
(char**) &myisam_log_filename, (char**) &myisam_log_filename, 0, GET_STR,
3216
3347
OPT_ARG, 0, 0, 0, 0, 0, 0},
3348
{"log-long-format", '0',
3349
"Log some extra information to update log. Please note that this option is deprecated; see --log-short-format option.",
3350
0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3351
#ifdef WITH_CSV_STORAGE_ENGINE
3352
{"log-output", OPT_LOG_OUTPUT,
3353
"Syntax: log-output[=value[,value...]], where \"value\" could be TABLE, "
3355
(char**) &log_output_str, (char**) &log_output_str, 0,
3356
GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
3358
{"log-queries-not-using-indexes", OPT_LOG_QUERIES_NOT_USING_INDEXES,
3359
"Log queries that are executed without benefit of any index to the slow log if it is open.",
3360
(char**) &opt_log_queries_not_using_indexes, (char**) &opt_log_queries_not_using_indexes,
3361
0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3362
{"log-short-format", OPT_SHORT_LOG_FORMAT,
3363
"Don't log extra information to update and slow-query logs.",
3364
(char**) &opt_short_log_format, (char**) &opt_short_log_format,
3365
0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3217
3366
{"log-slave-updates", OPT_LOG_SLAVE_UPDATES,
3218
N_("Tells the slave to log the updates from the slave thread to the binary "
3219
"log. You will need to turn it on if you plan to "
3220
"daisy-chain the slaves."),
3221
(char**) &opt_log_slave_updates, (char**) &opt_log_slave_updates,
3367
"Tells the slave to log the updates from the slave thread to the binary log. You will need to turn it on if you plan to daisy-chain the slaves.",
3368
(char**) &opt_log_slave_updates, (char**) &opt_log_slave_updates, 0, GET_BOOL,
3223
3369
NO_ARG, 0, 0, 0, 0, 0, 0},
3370
{"log-slow-admin-statements", OPT_LOG_SLOW_ADMIN_STATEMENTS,
3371
"Log slow OPTIMIZE, ANALYZE, ALTER and other administrative statements to the slow log if it is open.",
3372
(char**) &opt_log_slow_admin_statements,
3373
(char**) &opt_log_slow_admin_statements,
3374
0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3375
{"log-slow-slave-statements", OPT_LOG_SLOW_SLAVE_STATEMENTS,
3376
"Log slow statements executed by slave thread to the slow log if it is open.",
3377
(char**) &opt_log_slow_slave_statements,
3378
(char**) &opt_log_slow_slave_statements,
3379
0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3380
{"log-slow-queries", OPT_SLOW_QUERY_LOG,
3381
"Log slow queries to a table or log file. Defaults logging to table mysql.slow_log or hostname-slow.log if --log-output=file is used. Must be enabled to activate other slow log options.",
3382
(char**) &opt_slow_logname, (char**) &opt_slow_logname, 0, GET_STR, OPT_ARG,
3224
3384
{"log-tc", OPT_LOG_TC,
3225
N_("Path to transaction coordinator log (used for transactions that affect "
3226
"more than one storage engine, when binary log is disabled)"),
3385
"Path to transaction coordinator log (used for transactions that affect "
3386
"more than one storage engine, when binary log is disabled)",
3227
3387
(char**) &opt_tc_log_file, (char**) &opt_tc_log_file, 0, GET_STR,
3228
3388
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3229
3389
#ifdef HAVE_MMAP
3230
{"log-tc-size", OPT_LOG_TC_SIZE,
3231
N_("Size of transaction coordinator log."),
3390
{"log-tc-size", OPT_LOG_TC_SIZE, "Size of transaction coordinator log.",
3232
3391
(char**) &opt_tc_log_size, (char**) &opt_tc_log_size, 0, GET_ULONG,
3233
3392
REQUIRED_ARG, TC_LOG_MIN_SIZE, TC_LOG_MIN_SIZE, ULONG_MAX, 0,
3234
3393
TC_LOG_PAGE_SIZE, 0},
3236
{"log-warnings", 'W',
3237
N_("Log some not critical warnings to the log file."),
3395
{"log-warnings", 'W', "Log some not critical warnings to the log file.",
3238
3396
(char**) &global_system_variables.log_warnings,
3239
3397
(char**) &max_system_variables.log_warnings, 0, GET_ULONG, OPT_ARG, 1, 0, 0,
3241
3399
{"low-priority-updates", OPT_LOW_PRIORITY_UPDATES,
3242
N_("INSERT/DELETE/UPDATE has lower priority than selects."),
3400
"INSERT/DELETE/UPDATE has lower priority than selects.",
3243
3401
(char**) &global_system_variables.low_priority_updates,
3244
3402
(char**) &max_system_variables.low_priority_updates,
3245
3403
0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3246
3404
{"master-info-file", OPT_MASTER_INFO_FILE,
3247
N_("The location and name of the file that remembers the master and "
3248
"where the I/O replication thread is in the master's binlogs."),
3405
"The location and name of the file that remembers the master and where the I/O replication \
3406
thread is in the master's binlogs.",
3249
3407
(char**) &master_info_file, (char**) &master_info_file, 0, GET_STR,
3250
3408
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3251
3409
{"master-retry-count", OPT_MASTER_RETRY_COUNT,
3252
N_("The number of tries the slave will make to connect to the master "
3253
"before giving up."),
3410
"The number of tries the slave will make to connect to the master before giving up.",
3254
3411
(char**) &master_retry_count, (char**) &master_retry_count, 0, GET_ULONG,
3255
3412
REQUIRED_ARG, 3600*24, 0, 0, 0, 0, 0},
3256
3413
{"max-binlog-dump-events", OPT_MAX_BINLOG_DUMP_EVENTS,
3257
N_("Option used by mysql-test for debugging and testing of replication."),
3414
"Option used by mysql-test for debugging and testing of replication.",
3258
3415
(char**) &max_binlog_dump_events, (char**) &max_binlog_dump_events, 0,
3259
3416
GET_INT, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3260
{"memlock", OPT_MEMLOCK,
3261
N_("Lock mysqld in memory."),
3262
(char**) &locked_in_memory,
3417
{"memlock", OPT_MEMLOCK, "Lock mysqld in memory.", (char**) &locked_in_memory,
3263
3418
(char**) &locked_in_memory, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3264
3419
{"myisam-recover", OPT_MYISAM_RECOVER,
3265
N_("Syntax: myisam-recover[=option[,option...]], where option can be "
3266
"DEFAULT, BACKUP, FORCE or QUICK."),
3420
"Syntax: myisam-recover[=option[,option...]], where option can be DEFAULT, BACKUP, FORCE or QUICK.",
3267
3421
(char**) &myisam_recover_options_str, (char**) &myisam_recover_options_str, 0,
3268
3422
GET_STR, OPT_ARG, 0, 0, 0, 0, 0, 0},
3270
N_("Use very new possible 'unsafe' functions."),
3423
{"new", 'n', "Use very new possible 'unsafe' functions.",
3271
3424
(char**) &global_system_variables.new_mode,
3272
3425
(char**) &max_system_variables.new_mode,
3273
3426
0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3274
3427
{"old-alter-table", OPT_OLD_ALTER_TABLE,
3275
N_("Use old, non-optimized alter table."),
3428
"Use old, non-optimized alter table.",
3276
3429
(char**) &global_system_variables.old_alter_table,
3277
3430
(char**) &max_system_variables.old_alter_table, 0, GET_BOOL, NO_ARG,
3278
3431
0, 0, 0, 0, 0, 0},
3279
{"pid-file", OPT_PID_FILE,
3280
N_("Pid file used by safe_mysqld."),
3432
{"old-style-user-limits", OPT_OLD_STYLE_USER_LIMITS,
3433
"Enable old-style user limits (before 5.0.3 user resources were counted per each user+host vs. per account)",
3434
(char**) &opt_old_style_user_limits, (char**) &opt_old_style_user_limits,
3435
0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3436
{"pid-file", OPT_PID_FILE, "Pid file used by safe_mysqld.",
3281
3437
(char**) &pidfile_name_ptr, (char**) &pidfile_name_ptr, 0, GET_STR,
3282
3438
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3284
N_("Port number to use for connection or 0 for default to, in "
3285
"order of preference, my.cnf, $DRIZZLE_TCP_PORT, "
3286
"built-in default (" STRINGIFY_ARG(DRIZZLE_PORT) ")."),
3439
{"port", 'P', "Port number to use for connection or 0 for default to, in "
3440
"order of preference, my.cnf, $MYSQL_TCP_PORT, "
3441
#if MYSQL_PORT_DEFAULT == 0
3444
"built-in default (" STRINGIFY_ARG(MYSQL_PORT) ").",
3287
3445
(char**) &mysqld_port,
3288
3446
(char**) &mysqld_port, 0, GET_UINT, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3289
3447
{"port-open-timeout", OPT_PORT_OPEN_TIMEOUT,
3290
N_("Maximum time in seconds to wait for the port to become free. "
3291
"(Default: no wait)"),
3292
(char**) &mysqld_port_timeout,
3448
"Maximum time in seconds to wait for the port to become free. "
3449
"(Default: no wait)", (char**) &mysqld_port_timeout,
3293
3450
(char**) &mysqld_port_timeout, 0, GET_UINT, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3294
3451
{"relay-log", OPT_RELAY_LOG,
3295
N_("The location and name to use for relay logs."),
3452
"The location and name to use for relay logs.",
3296
3453
(char**) &opt_relay_logname, (char**) &opt_relay_logname, 0,
3297
3454
GET_STR_ALLOC, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3298
3455
{"relay-log-index", OPT_RELAY_LOG_INDEX,
3299
N_("The location and name to use for the file that keeps a list of the "
3300
"last relay logs."),
3456
"The location and name to use for the file that keeps a list of the last \
3301
3458
(char**) &opt_relaylog_index_name, (char**) &opt_relaylog_index_name, 0,
3302
3459
GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3303
3460
{"relay-log-info-file", OPT_RELAY_LOG_INFO_FILE,
3304
N_("The location and name of the file that remembers where the SQL "
3305
"replication thread is in the relay logs."),
3461
"The location and name of the file that remembers where the SQL replication \
3462
thread is in the relay logs.",
3306
3463
(char**) &relay_log_info_file, (char**) &relay_log_info_file, 0, GET_STR,
3307
3464
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3308
3465
{"replicate-do-db", OPT_REPLICATE_DO_DB,
3309
N_("Tells the slave thread to restrict replication to the specified "
3310
"database. To specify more than one database, use the directive "
3311
"multiple times, once for each database. Note that this will only work "
3312
"if you do not use cross-database queries such as UPDATE "
3313
"some_db.some_table SET foo='bar' while having selected a different or "
3314
"no database. If you need cross database updates to work, use "
3315
"replicate-wild-do-table=db_name.%."),
3466
"Tells the slave thread to restrict replication to the specified database. To specify more than one database, use the directive multiple times, once for each database. Note that this will only work if you do not use cross-database queries such as UPDATE some_db.some_table SET foo='bar' while having selected a different or no database. If you need cross database updates to work, make sure you have 3.23.28 or later, and use replicate-wild-do-table=db_name.%.",
3316
3467
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3317
3468
{"replicate-do-table", OPT_REPLICATE_DO_TABLE,
3318
N_("Tells the slave thread to restrict replication to the specified table. "
3319
"To specify more than one table, use the directive multiple times, once "
3320
"for each table. This will work for cross-database updates, in contrast "
3321
"to replicate-do-db."),
3469
"Tells the slave thread to restrict replication to the specified table. To specify more than one table, use the directive multiple times, once for each table. This will work for cross-database updates, in contrast to replicate-do-db.",
3322
3470
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3323
3471
{"replicate-ignore-db", OPT_REPLICATE_IGNORE_DB,
3324
N_("Tells the slave thread to not replicate to the specified database. To "
3325
"specify more than one database to ignore, use the directive multiple "
3326
"times, once for each database. This option will not work if you use "
3327
"cross database updates. If you need cross database updates to work, "
3328
"use replicate-wild-ignore-table=db_name.%. "),
3472
"Tells the slave thread to not replicate to the specified database. To specify more than one database to ignore, use the directive multiple times, once for each database. This option will not work if you use cross database updates. If you need cross database updates to work, make sure you have 3.23.28 or later, and use replicate-wild-ignore-table=db_name.%. ",
3329
3473
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3330
3474
{"replicate-ignore-table", OPT_REPLICATE_IGNORE_TABLE,
3331
N_("Tells the slave thread to not replicate to the specified table. To "
3332
"specify more than one table to ignore, use the directive multiple "
3333
"times, once for each table. This will work for cross-datbase updates, "
3334
"in contrast to replicate-ignore-db."),
3475
"Tells the slave thread to not replicate to the specified table. To specify more than one table to ignore, use the directive multiple times, once for each table. This will work for cross-datbase updates, in contrast to replicate-ignore-db.",
3335
3476
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3336
3477
{"replicate-rewrite-db", OPT_REPLICATE_REWRITE_DB,
3337
N_("Updates to a database with a different name than the original. "
3338
"Example: replicate-rewrite-db=master_db_name->slave_db_name."),
3478
"Updates to a database with a different name than the original. Example: replicate-rewrite-db=master_db_name->slave_db_name.",
3339
3479
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3340
3480
{"replicate-same-server-id", OPT_REPLICATE_SAME_SERVER_ID,
3341
N_("In replication, if set to 1, do not skip events having our server id. "
3342
"Default value is 0 (to break infinite loops in circular replication). "
3343
"Can't be set to 1 if --log-slave-updates is used."),
3481
"In replication, if set to 1, do not skip events having our server id. \
3482
Default value is 0 (to break infinite loops in circular replication). \
3483
Can't be set to 1 if --log-slave-updates is used.",
3344
3484
(char**) &replicate_same_server_id,
3345
3485
(char**) &replicate_same_server_id,
3346
3486
0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3347
3487
{"replicate-wild-do-table", OPT_REPLICATE_WILD_DO_TABLE,
3348
N_("Tells the slave thread to restrict replication to the tables that "
3349
"match the specified wildcard pattern. To specify more than one table, "
3350
"use the directive multiple times, once for each table. This will work "
3351
"for cross-database updates. Example: replicate-wild-do-table=foo%.bar% "
3352
"will replicate only updates to tables in all databases that start with "
3353
"foo and whose table names start with bar."),
3488
"Tells the slave thread to restrict replication to the tables that match the specified wildcard pattern. To specify more than one table, use the directive multiple times, once for each table. This will work for cross-database updates. Example: replicate-wild-do-table=foo%.bar% will replicate only updates to tables in all databases that start with foo and whose table names start with bar.",
3354
3489
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3355
3490
{"replicate-wild-ignore-table", OPT_REPLICATE_WILD_IGNORE_TABLE,
3356
N_("Tells the slave thread to not replicate to the tables that match the "
3357
"given wildcard pattern. To specify more than one table to ignore, use "
3358
"the directive multiple times, once for each table. This will work for "
3359
"cross-database updates. Example: replicate-wild-ignore-table=foo%.bar% "
3360
"will not do updates to tables in databases that start with foo and "
3361
"whose table names start with bar."),
3491
"Tells the slave thread to not replicate to the tables that match the given wildcard pattern. To specify more than one table to ignore, use the directive multiple times, once for each table. This will work for cross-database updates. Example: replicate-wild-ignore-table=foo%.bar% will not do updates to tables in databases that start with foo and whose table names start with bar.",
3362
3492
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3363
3493
// In replication, we may need to tell the other servers how to connect
3364
3494
{"report-host", OPT_REPORT_HOST,
3365
N_("Hostname or IP of the slave to be reported to to the master during "
3366
"slave registration. Will appear in the output of SHOW SLAVE HOSTS. "
3367
"Leave unset if you do not want the slave to register itself with the "
3368
"master. Note that it is not sufficient for the master to simply read "
3369
"the IP of the slave off the socket once the slave connects. Due to NAT "
3370
"and other routing issues, that IP may not be valid for connecting to "
3371
"the slave from the master or other hosts."),
3495
"Hostname or IP of the slave to be reported to to the master during slave registration. Will appear in the output of SHOW SLAVE HOSTS. Leave unset if you do not want the slave to register itself with the master. Note that it is not sufficient for the master to simply read the IP of the slave off the socket once the slave connects. Due to NAT and other routing issues, that IP may not be valid for connecting to the slave from the master or other hosts.",
3372
3496
(char**) &report_host, (char**) &report_host, 0, GET_STR, REQUIRED_ARG, 0, 0,
3374
3498
{"report-password", OPT_REPORT_PASSWORD, "Undocumented.",
3375
3499
(char**) &report_password, (char**) &report_password, 0, GET_STR,
3376
3500
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3377
3501
{"report-port", OPT_REPORT_PORT,
3378
N_("Port for connecting to slave reported to the master during slave "
3379
"registration. Set it only if the slave is listening on a non-default "
3380
"port or if you have a special tunnel from the master or other clients "
3381
"to the slave. If not sure, leave this option unset."),
3502
"Port for connecting to slave reported to the master during slave registration. Set it only if the slave is listening on a non-default port or if you have a special tunnel from the master or other clients to the slave. If not sure, leave this option unset.",
3382
3503
(char**) &report_port, (char**) &report_port, 0, GET_UINT, REQUIRED_ARG,
3383
DRIZZLE_PORT, 0, 0, 0, 0, 0},
3384
{"safe-mode", OPT_SAFE,
3385
N_("Skip some optimize stages (for testing)."),
3504
MYSQL_PORT, 0, 0, 0, 0, 0},
3505
{"safe-mode", OPT_SAFE, "Skip some optimize stages (for testing).",
3386
3506
0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3387
3507
{"secure-file-priv", OPT_SECURE_FILE_PRIV,
3388
N_("Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files "
3389
"within specified directory"),
3508
"Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within specified directory",
3390
3509
(char**) &opt_secure_file_priv, (char**) &opt_secure_file_priv, 0,
3391
3510
GET_STR_ALLOC, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3392
3511
{"server-id", OPT_SERVER_ID,
3393
N_("Uniquely identifies the server instance in the community of "
3394
"replication partners."),
3512
"Uniquely identifies the server instance in the community of replication partners.",
3395
3513
(char**) &server_id, (char**) &server_id, 0, GET_ULONG, REQUIRED_ARG, 0, 0, 0,
3397
{"skip-new", OPT_SKIP_NEW,
3398
N_("Don't use new, possible wrong routines."),
3515
{"set-variable", 'O',
3516
"Change the value of a variable. Please note that this option is deprecated;you can set variables directly with --variable-name=value.",
3517
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3518
{"skip-new", OPT_SKIP_NEW, "Don't use new, possible wrong routines.",
3399
3519
0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3400
3520
{"skip-slave-start", OPT_SKIP_SLAVE_START,
3401
N_("If set, slave is not autostarted."),
3402
(char**) &opt_skip_slave_start,
3521
"If set, slave is not autostarted.", (char**) &opt_skip_slave_start,
3403
3522
(char**) &opt_skip_slave_start, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0},
3404
3523
{"skip-stack-trace", OPT_SKIP_STACK_TRACE,
3405
N_("Don't print a stack trace on failure."),
3406
0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0,
3524
"Don't print a stack trace on failure.", 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0,
3526
{"skip-symlink", OPT_SKIP_SYMLINKS, "Don't allow symlinking of tables. Deprecated option. Use --skip-symbolic-links instead.",
3527
0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0},
3408
3528
{"skip-thread-priority", OPT_SKIP_PRIOR,
3409
N_("Don't give threads different priorities."),
3410
0, 0, 0, GET_NO_ARG, NO_ARG,
3529
"Don't give threads different priorities.", 0, 0, 0, GET_NO_ARG, NO_ARG,
3411
3530
DEFAULT_SKIP_THREAD_PRIORITY, 0, 0, 0, 0, 0},
3412
3531
{"slave-load-tmpdir", OPT_SLAVE_LOAD_TMPDIR,
3413
N_("The location where the slave should put its temporary files when "
3414
"replicating a LOAD DATA INFILE command."),
3532
"The location where the slave should put its temporary files when \
3533
replicating a LOAD DATA INFILE command.",
3415
3534
(char**) &slave_load_tmpdir, (char**) &slave_load_tmpdir, 0, GET_STR_ALLOC,
3416
3535
REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3417
3536
{"slave-skip-errors", OPT_SLAVE_SKIP_ERRORS,
3418
N_("Tells the slave thread to continue replication when a query event "
3419
"returns an error from the provided list."),
3537
"Tells the slave thread to continue replication when a query event returns an error from the provided list.",
3420
3538
0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3421
3539
{"slave-exec-mode", OPT_SLAVE_EXEC_MODE,
3422
N_("Modes for how replication events should be executed. Legal values are "
3423
"STRICT (default) and IDEMPOTENT. In IDEMPOTENT mode, replication will "
3424
"not stop for operations that are idempotent. In STRICT mode, "
3425
"replication will stop on any unexpected difference between the master "
3427
(char**) &slave_exec_mode_str, (char**) &slave_exec_mode_str,
3428
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3540
"Modes for how replication events should be executed. Legal values are STRICT (default) and IDEMPOTENT. In IDEMPOTENT mode, replication will not stop for operations that are idempotent. In STRICT mode, replication will stop on any unexpected difference between the master and the slave.",
3541
(char**) &slave_exec_mode_str, (char**) &slave_exec_mode_str, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3542
{"slow-query-log", OPT_SLOW_LOG,
3543
"Enable|disable slow query log", (char**) &opt_slow_log,
3544
(char**) &opt_slow_log, 0, GET_BOOL, OPT_ARG, 0, 0, 0, 0, 0, 0},
3429
3545
{"sql-bin-update-same", OPT_SQL_BIN_UPDATE_SAME,
3546
"The update log is deprecated since version 5.0, is replaced by the binary \
3547
log and this option does nothing anymore.",
3431
3548
0, 0, 0, GET_DISABLED, NO_ARG, 0, 0, 0, 0, 0, 0},
3432
{"symbolic-links", 's',
3433
N_("Enable symbolic link support."),
3549
{"symbolic-links", 's', "Enable symbolic link support.",
3434
3550
(char**) &my_use_symdir, (char**) &my_use_symdir, 0, GET_BOOL, NO_ARG,
3436
3552
The system call realpath() produces warnings under valgrind and
3440
3556
IF_PURIFY(0,1), 0, 0, 0, 0, 0},
3441
3557
{"sysdate-is-now", OPT_SYSDATE_IS_NOW,
3442
N_("Non-default option to alias SYSDATE() to NOW() to make it "
3443
"safe-replicable."),
3558
"Non-default option to alias SYSDATE() to NOW() to make it safe-replicable. Since 5.0, SYSDATE() returns a `dynamic' value different for different invocations, even within the same statement.",
3444
3559
(char**) &global_system_variables.sysdate_is_now,
3445
3560
0, 0, GET_BOOL, NO_ARG, 0, 0, 1, 0, 1, 0},
3446
3561
{"tc-heuristic-recover", OPT_TC_HEURISTIC_RECOVER,
3447
N_("Decision to use in heuristic recover process. Possible values are "
3448
"COMMIT or ROLLBACK."),
3562
"Decision to use in heuristic recover process. Possible values are COMMIT or ROLLBACK.",
3449
3563
(char**) &opt_tc_heuristic_recover, (char**) &opt_tc_heuristic_recover,
3450
3564
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3451
3565
{"temp-pool", OPT_TEMP_POOL,
3452
N_("Using this option will cause most temporary files created to use a "
3453
"small set of names, rather than a unique name for each new file."),
3566
"Using this option will cause most temporary files created to use a small set of names, rather than a unique name for each new file.",
3454
3567
(char**) &use_temp_pool, (char**) &use_temp_pool, 0, GET_BOOL, NO_ARG, 1,
3455
3568
0, 0, 0, 0, 0},
3456
3569
{"timed_mutexes", OPT_TIMED_MUTEXES,
3457
N_("Specify whether to time mutexes (only InnoDB mutexes are currently "
3459
(char**) &timed_mutexes, (char**) &timed_mutexes, 0, GET_BOOL, NO_ARG, 0,
3570
"Specify whether to time mutexes (only InnoDB mutexes are currently supported)",
3571
(char**) &timed_mutexes, (char**) &timed_mutexes, 0, GET_BOOL, NO_ARG, 0,
3460
3572
0, 0, 0, 0, 0},
3461
3573
{"tmpdir", 't',
3462
N_("Path for temporary files. Several paths may be specified, separated "
3464
", in this case they are used in a round-robin fashion."),
3574
"Path for temporary files. Several paths may be specified, separated by a "
3576
", in this case they are used in a round-robin fashion.",
3465
3577
(char**) &opt_mysql_tmpdir,
3466
3578
(char**) &opt_mysql_tmpdir, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3467
3579
{"transaction-isolation", OPT_TX_ISOLATION,
3468
N_("Default transaction isolation level."),
3469
0, 0, 0, GET_STR, REQUIRED_ARG, 0,
3580
"Default transaction isolation level.", 0, 0, 0, GET_STR, REQUIRED_ARG, 0,
3470
3581
0, 0, 0, 0, 0},
3472
N_("Run mysqld daemon as user."),
3473
0, 0, 0, GET_STR, REQUIRED_ARG,
3582
{"use-symbolic-links", 's', "Enable symbolic link support. Deprecated option; use --symbolic-links instead.",
3583
(char**) &my_use_symdir, (char**) &my_use_symdir, 0, GET_BOOL, NO_ARG,
3584
IF_PURIFY(0,1), 0, 0, 0, 0, 0},
3585
{"user", 'u', "Run mysqld daemon as user.", 0, 0, 0, GET_STR, REQUIRED_ARG,
3474
3586
0, 0, 0, 0, 0, 0},
3476
N_("Output version information and exit."),
3477
0, 0, 0, GET_NO_ARG,
3587
{"verbose", 'v', "Used with --help option for detailed help",
3588
(char**) &opt_verbose, (char**) &opt_verbose, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0,
3590
{"version", 'V', "Output version information and exit.", 0, 0, 0, GET_NO_ARG,
3478
3591
NO_ARG, 0, 0, 0, 0, 0, 0},
3479
{"back_log", OPT_BACK_LOG,
3480
N_("The number of outstanding connection requests MySQL can have. This "
3481
"comes into play when the main MySQL thread gets very many connection "
3482
"requests in a very short time."),
3592
{"warnings", 'W', "Deprecated; use --log-warnings instead.",
3593
(char**) &global_system_variables.log_warnings,
3594
(char**) &max_system_variables.log_warnings, 0, GET_ULONG, OPT_ARG,
3595
1, 0, ULONG_MAX, 0, 0, 0},
3596
{ "back_log", OPT_BACK_LOG,
3597
"The number of outstanding connection requests MySQL can have. This comes into play when the main MySQL thread gets very many connection requests in a very short time.",
3483
3598
(char**) &back_log, (char**) &back_log, 0, GET_ULONG,
3484
3599
REQUIRED_ARG, 50, 1, 65535, 0, 1, 0 },
3485
{ "binlog_cache_size", OPT_BINLOG_CACHE_SIZE,
3486
N_("The size of the cache to hold the SQL statements for the binary log "
3487
"during a transaction. If you often use big, multi-statement "
3488
"transactions you can increase this to get more performance."),
3489
(char**) &binlog_cache_size, (char**) &binlog_cache_size, 0, GET_ULONG,
3490
REQUIRED_ARG, 32*1024L, IO_SIZE, ULONG_MAX, 0, IO_SIZE, 0},
3491
{ "bulk_insert_buffer_size", OPT_BULK_INSERT_BUFFER_SIZE,
3492
N_("Size of tree cache used in bulk insert optimisation. Note that this is "
3493
"a limit per thread!"),
3494
(char**) &global_system_variables.bulk_insert_buff_size,
3495
(char**) &max_system_variables.bulk_insert_buff_size,
3496
0, GET_ULONG, REQUIRED_ARG, 8192*1024, 0, ULONG_MAX, 0, 1, 0},
3497
{ "connect_timeout", OPT_CONNECT_TIMEOUT,
3498
N_("The number of seconds the mysqld server is waiting for a connect "
3499
"packet before responding with 'Bad handshake'."),
3600
{"binlog_cache_size", OPT_BINLOG_CACHE_SIZE,
3601
"The size of the cache to hold the SQL statements for the binary log during a transaction. If you often use big, multi-statement transactions you can increase this to get more performance.",
3602
(char**) &binlog_cache_size, (char**) &binlog_cache_size, 0, GET_ULONG,
3603
REQUIRED_ARG, 32*1024L, IO_SIZE, ULONG_MAX, 0, IO_SIZE, 0},
3604
{"bulk_insert_buffer_size", OPT_BULK_INSERT_BUFFER_SIZE,
3605
"Size of tree cache used in bulk insert optimisation. Note that this is a limit per thread!",
3606
(char**) &global_system_variables.bulk_insert_buff_size,
3607
(char**) &max_system_variables.bulk_insert_buff_size,
3608
0, GET_ULONG, REQUIRED_ARG, 8192*1024, 0, ULONG_MAX, 0, 1, 0},
3609
{"connect_timeout", OPT_CONNECT_TIMEOUT,
3610
"The number of seconds the mysqld server is waiting for a connect packet before responding with 'Bad handshake'.",
3500
3611
(char**) &connect_timeout, (char**) &connect_timeout,
3501
0, GET_ULONG, REQUIRED_ARG, CONNECT_TIMEOUT, 2, LONG_TIMEOUT, 0, 1, 0 },
3612
0, GET_ULONG, REQUIRED_ARG, CONNECT_TIMEOUT, 2, LONG_TIMEOUT, 0, 1, 0 },
3502
3613
{ "date_format", OPT_DATE_FORMAT,
3503
N_("The DATE format (For future)."),
3504
(char**) &opt_date_time_formats[DRIZZLE_TIMESTAMP_DATE],
3505
(char**) &opt_date_time_formats[DRIZZLE_TIMESTAMP_DATE],
3614
"The DATE format (For future).",
3615
(char**) &opt_date_time_formats[MYSQL_TIMESTAMP_DATE],
3616
(char**) &opt_date_time_formats[MYSQL_TIMESTAMP_DATE],
3506
3617
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3507
3618
{ "datetime_format", OPT_DATETIME_FORMAT,
3508
N_("The DATETIME/TIMESTAMP format (for future)."),
3509
(char**) &opt_date_time_formats[DRIZZLE_TIMESTAMP_DATETIME],
3510
(char**) &opt_date_time_formats[DRIZZLE_TIMESTAMP_DATETIME],
3619
"The DATETIME/TIMESTAMP format (for future).",
3620
(char**) &opt_date_time_formats[MYSQL_TIMESTAMP_DATETIME],
3621
(char**) &opt_date_time_formats[MYSQL_TIMESTAMP_DATETIME],
3511
3622
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3512
3623
{ "default_week_format", OPT_DEFAULT_WEEK_FORMAT,
3513
N_("The default week format used by WEEK() functions."),
3624
"The default week format used by WEEK() functions.",
3514
3625
(char**) &global_system_variables.default_week_format,
3515
3626
(char**) &max_system_variables.default_week_format,
3516
3627
0, GET_ULONG, REQUIRED_ARG, 0, 0, 7L, 0, 1, 0},
3517
{ "div_precision_increment", OPT_DIV_PRECINCREMENT,
3518
N_("Precision of the result of '/' operator will be increased on that "
3628
{"div_precision_increment", OPT_DIV_PRECINCREMENT,
3629
"Precision of the result of '/' operator will be increased on that value.",
3520
3630
(char**) &global_system_variables.div_precincrement,
3521
3631
(char**) &max_system_variables.div_precincrement, 0, GET_ULONG,
3522
3632
REQUIRED_ARG, 4, 0, DECIMAL_MAX_SCALE, 0, 0, 0},
3523
{ "expire_logs_days", OPT_EXPIRE_LOGS_DAYS,
3524
N_("If non-zero, binary logs will be purged after expire_logs_days "
3525
"days; possible purges happen at startup and at binary log rotation."),
3526
(char**) &expire_logs_days,
3527
(char**) &expire_logs_days, 0, GET_ULONG,
3528
REQUIRED_ARG, 0, 0, 99, 0, 1, 0},
3633
{"expire_logs_days", OPT_EXPIRE_LOGS_DAYS,
3634
"If non-zero, binary logs will be purged after expire_logs_days "
3635
"days; possible purges happen at startup and at binary log rotation.",
3636
(char**) &expire_logs_days,
3637
(char**) &expire_logs_days, 0, GET_ULONG,
3638
REQUIRED_ARG, 0, 0, 99, 0, 1, 0},
3639
{ "flush_time", OPT_FLUSH_TIME,
3640
"A dedicated thread is created to flush all tables at the given interval.",
3641
(char**) &flush_time, (char**) &flush_time, 0, GET_ULONG, REQUIRED_ARG,
3642
FLUSH_TIME, 0, LONG_TIMEOUT, 0, 1, 0},
3529
3643
{ "group_concat_max_len", OPT_GROUP_CONCAT_MAX_LEN,
3530
N_("The maximum length of the result of function group_concat."),
3644
"The maximum length of the result of function group_concat.",
3531
3645
(char**) &global_system_variables.group_concat_max_len,
3532
3646
(char**) &max_system_variables.group_concat_max_len, 0, GET_ULONG,
3533
3647
REQUIRED_ARG, 1024, 4, ULONG_MAX, 0, 1, 0},
3534
{ "interactive_timeout", OPT_INTERACTIVE_TIMEOUT,
3535
N_("The number of seconds the server waits for activity on an interactive "
3536
"connection before closing it."),
3648
{"interactive_timeout", OPT_INTERACTIVE_TIMEOUT,
3649
"The number of seconds the server waits for activity on an interactive connection before closing it.",
3537
3650
(char**) &global_system_variables.net_interactive_timeout,
3538
3651
(char**) &max_system_variables.net_interactive_timeout, 0,
3539
3652
GET_ULONG, REQUIRED_ARG, NET_WAIT_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
3540
{ "join_buffer_size", OPT_JOIN_BUFF_SIZE,
3541
N_("The size of the buffer that is used for full joins."),
3653
{"join_buffer_size", OPT_JOIN_BUFF_SIZE,
3654
"The size of the buffer that is used for full joins.",
3542
3655
(char**) &global_system_variables.join_buff_size,
3543
3656
(char**) &max_system_variables.join_buff_size, 0, GET_ULONG,
3544
3657
REQUIRED_ARG, 128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, ULONG_MAX,
3545
3658
MALLOC_OVERHEAD, IO_SIZE, 0},
3546
3659
{"keep_files_on_create", OPT_KEEP_FILES_ON_CREATE,
3547
N_("Don't overwrite stale .MYD and .MYI even if no directory is specified."),
3660
"Don't overwrite stale .MYD and .MYI even if no directory is specified.",
3548
3661
(char**) &global_system_variables.keep_files_on_create,
3549
3662
(char**) &max_system_variables.keep_files_on_create,
3550
3663
0, GET_BOOL, OPT_ARG, 0, 0, 0, 0, 0, 0},
3551
3664
{"key_buffer_size", OPT_KEY_BUFFER_SIZE,
3552
N_("The size of the buffer used for index blocks for MyISAM tables. "
3553
"Increase this to get better index handling (for all reads and multiple "
3554
"writes) to as much as you can afford;"),
3665
"The size of the buffer used for index blocks for MyISAM tables. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford; 64M on a 256M machine that mainly runs MySQL is quite common.",
3555
3666
(char**) &dflt_key_cache_var.param_buff_size,
3557
3668
0, (GET_ULL | GET_ASK_ADDR),
3558
3669
REQUIRED_ARG, KEY_CACHE_SIZE, MALLOC_OVERHEAD, SIZE_T_MAX, MALLOC_OVERHEAD,
3560
3671
{"key_cache_age_threshold", OPT_KEY_CACHE_AGE_THRESHOLD,
3561
N_("This characterizes the number of hits a hot block has to be untouched "
3562
"until it is considered aged enough to be downgraded to a warm block. "
3563
"This specifies the percentage ratio of that number of hits to the "
3564
"total number of blocks in key cache"),
3672
"This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in key cache",
3565
3673
(char**) &dflt_key_cache_var.param_age_threshold,
3567
0, (GET_ULONG | GET_ASK_ADDR), REQUIRED_ARG,
3675
0, (GET_ULONG | GET_ASK_ADDR), REQUIRED_ARG,
3568
3676
300, 100, ULONG_MAX, 0, 100, 0},
3569
3677
{"key_cache_block_size", OPT_KEY_CACHE_BLOCK_SIZE,
3570
N_("The default size of key cache blocks"),
3678
"The default size of key cache blocks",
3571
3679
(char**) &dflt_key_cache_var.param_block_size,
3573
3681
0, (GET_ULONG | GET_ASK_ADDR), REQUIRED_ARG,
3574
3682
KEY_CACHE_BLOCK_SIZE, 512, 1024 * 16, 0, 512, 0},
3575
3683
{"key_cache_division_limit", OPT_KEY_CACHE_DIVISION_LIMIT,
3576
N_("The minimum percentage of warm blocks in key cache"),
3684
"The minimum percentage of warm blocks in key cache",
3577
3685
(char**) &dflt_key_cache_var.param_division_limit,
3579
3687
0, (GET_ULONG | GET_ASK_ADDR) , REQUIRED_ARG, 100,
3580
3688
1, 100, 0, 1, 0},
3581
3689
{"long_query_time", OPT_LONG_QUERY_TIME,
3582
N_("Log all queries that have taken more than long_query_time seconds to "
3583
"execute to file. The argument will be treated as a decimal value with "
3584
"microsecond precission."),
3690
"Log all queries that have taken more than long_query_time seconds to execute to file. "
3691
"The argument will be treated as a decimal value with microsecond precission.",
3585
3692
(char**) &long_query_time, (char**) &long_query_time, 0, GET_DOUBLE,
3586
3693
REQUIRED_ARG, 10, 0, LONG_TIMEOUT, 0, 0, 0},
3694
{"lower_case_table_names", OPT_LOWER_CASE_TABLE_NAMES,
3695
"If set to 1 table names are stored in lowercase on disk and table names will be case-insensitive. Should be set to 2 if you are using a case insensitive file system",
3696
(char**) &lower_case_table_names,
3697
(char**) &lower_case_table_names, 0, GET_UINT, OPT_ARG,
3698
#ifdef FN_NO_CASE_SENCE
3587
3704
{"max_allowed_packet", OPT_MAX_ALLOWED_PACKET,
3588
N_("Max packetlength to send/receive from to server."),
3705
"Max packetlength to send/receive from to server.",
3589
3706
(char**) &global_system_variables.max_allowed_packet,
3590
3707
(char**) &max_system_variables.max_allowed_packet, 0, GET_ULONG,
3591
3708
REQUIRED_ARG, 1024*1024L, 1024, 1024L*1024L*1024L, MALLOC_OVERHEAD, 1024, 0},
3592
3709
{"max_binlog_cache_size", OPT_MAX_BINLOG_CACHE_SIZE,
3593
N_("Can be used to restrict the total size used to cache a "
3594
"multi-transaction query."),
3710
"Can be used to restrict the total size used to cache a multi-transaction query.",
3595
3711
(char**) &max_binlog_cache_size, (char**) &max_binlog_cache_size, 0,
3596
3712
GET_ULONG, REQUIRED_ARG, ULONG_MAX, IO_SIZE, ULONG_MAX, 0, IO_SIZE, 0},
3597
3713
{"max_binlog_size", OPT_MAX_BINLOG_SIZE,
3598
N_("Binary log will be rotated automatically when the size exceeds this "
3599
"value. Will also apply to relay logs if max_relay_log_size is 0. "
3600
"The minimum value for this variable is 4096."),
3714
"Binary log will be rotated automatically when the size exceeds this \
3715
value. Will also apply to relay logs if max_relay_log_size is 0. \
3716
The minimum value for this variable is 4096.",
3601
3717
(char**) &max_binlog_size, (char**) &max_binlog_size, 0, GET_ULONG,
3602
3718
REQUIRED_ARG, 1024*1024L*1024L, IO_SIZE, 1024*1024L*1024L, 0, IO_SIZE, 0},
3603
3719
{"max_connect_errors", OPT_MAX_CONNECT_ERRORS,
3604
N_("If there is more than this number of interrupted connections from a "
3605
"host this host will be blocked from further connections."),
3720
"If there is more than this number of interrupted connections from a host this host will be blocked from further connections.",
3606
3721
(char**) &max_connect_errors, (char**) &max_connect_errors, 0, GET_ULONG,
3607
REQUIRED_ARG, MAX_CONNECT_ERRORS, 1, ULONG_MAX, 0, 1, 0},
3722
REQUIRED_ARG, MAX_CONNECT_ERRORS, 1, ULONG_MAX, 0, 1, 0},
3608
3723
// Default max_connections of 151 is larger than Apache's default max
3609
3724
// children, to avoid "too many connections" error in a common setup
3610
3725
{"max_connections", OPT_MAX_CONNECTIONS,
3611
N_("The number of simultaneous clients allowed."),
3612
(char**) &max_connections,
3726
"The number of simultaneous clients allowed.", (char**) &max_connections,
3613
3727
(char**) &max_connections, 0, GET_ULONG, REQUIRED_ARG, 151, 1, 100000, 0, 1,
3615
3729
{"max_error_count", OPT_MAX_ERROR_COUNT,
3616
N_("Max number of errors/warnings to store for a statement."),
3730
"Max number of errors/warnings to store for a statement.",
3617
3731
(char**) &global_system_variables.max_error_count,
3618
3732
(char**) &max_system_variables.max_error_count,
3619
3733
0, GET_ULONG, REQUIRED_ARG, DEFAULT_ERROR_COUNT, 0, 65535, 0, 1, 0},
3620
3734
{"max_heap_table_size", OPT_MAX_HEP_TABLE_SIZE,
3621
N_("Don't allow creation of heap tables bigger than this."),
3735
"Don't allow creation of heap tables bigger than this.",
3622
3736
(char**) &global_system_variables.max_heap_table_size,
3623
3737
(char**) &max_system_variables.max_heap_table_size, 0, GET_ULL,
3624
3738
REQUIRED_ARG, 16*1024*1024L, 16384, MAX_MEM_TABLE_SIZE,
3625
3739
MALLOC_OVERHEAD, 1024, 0},
3626
3740
{"max_join_size", OPT_MAX_JOIN_SIZE,
3627
N_("Joins that are probably going to read more than max_join_size records "
3628
"return an error."),
3741
"Joins that are probably going to read more than max_join_size records return an error.",
3629
3742
(char**) &global_system_variables.max_join_size,
3630
3743
(char**) &max_system_variables.max_join_size, 0, GET_HA_ROWS, REQUIRED_ARG,
3631
INT32_MAX, 1, INT32_MAX, 0, 1, 0},
3632
{"max_length_for_sort_data", OPT_MAX_LENGTH_FOR_SORT_DATA,
3633
N_("Max number of bytes in sorted records."),
3634
(char**) &global_system_variables.max_length_for_sort_data,
3635
(char**) &max_system_variables.max_length_for_sort_data, 0, GET_ULONG,
3636
REQUIRED_ARG, 1024, 4, 8192*1024L, 0, 1, 0},
3744
~0L, 1, ~0L, 0, 1, 0},
3745
{"max_length_for_sort_data", OPT_MAX_LENGTH_FOR_SORT_DATA,
3746
"Max number of bytes in sorted records.",
3747
(char**) &global_system_variables.max_length_for_sort_data,
3748
(char**) &max_system_variables.max_length_for_sort_data, 0, GET_ULONG,
3749
REQUIRED_ARG, 1024, 4, 8192*1024L, 0, 1, 0},
3637
3750
{"max_relay_log_size", OPT_MAX_RELAY_LOG_SIZE,
3638
N_("If non-zero: relay log will be rotated automatically when the size "
3639
"exceeds this value; if zero (the default): when the size exceeds "
3640
"max_binlog_size. 0 excepted, the minimum value for this variable "
3751
"If non-zero: relay log will be rotated automatically when the size exceeds this value; if zero (the default): when the size exceeds max_binlog_size. 0 excepted, the minimum value for this variable is 4096.",
3642
3752
(char**) &max_relay_log_size, (char**) &max_relay_log_size, 0, GET_ULONG,
3643
3753
REQUIRED_ARG, 0L, 0L, 1024*1024L*1024L, 0, IO_SIZE, 0},
3644
3754
{ "max_seeks_for_key", OPT_MAX_SEEKS_FOR_KEY,
3645
N_("Limit assumed max number of seeks when looking up rows based on a key"),
3755
"Limit assumed max number of seeks when looking up rows based on a key",
3646
3756
(char**) &global_system_variables.max_seeks_for_key,
3647
3757
(char**) &max_system_variables.max_seeks_for_key, 0, GET_ULONG,
3648
3758
REQUIRED_ARG, ULONG_MAX, 1, ULONG_MAX, 0, 1, 0 },
3649
3759
{"max_sort_length", OPT_MAX_SORT_LENGTH,
3650
N_("The number of bytes to use when sorting BLOB or TEXT values "
3651
"(only the first max_sort_length bytes of each value are used; the "
3652
"rest are ignored)."),
3760
"The number of bytes to use when sorting BLOB or TEXT values (only the first max_sort_length bytes of each value are used; the rest are ignored).",
3653
3761
(char**) &global_system_variables.max_sort_length,
3654
3762
(char**) &max_system_variables.max_sort_length, 0, GET_ULONG,
3655
3763
REQUIRED_ARG, 1024, 4, 8192*1024L, 0, 1, 0},
3656
3764
{"max_tmp_tables", OPT_MAX_TMP_TABLES,
3657
N_("Maximum number of temporary tables a client can keep open at a time."),
3765
"Maximum number of temporary tables a client can keep open at a time.",
3658
3766
(char**) &global_system_variables.max_tmp_tables,
3659
3767
(char**) &max_system_variables.max_tmp_tables, 0, GET_ULONG,
3660
3768
REQUIRED_ARG, 32, 1, ULONG_MAX, 0, 1, 0},
3661
3769
{"max_write_lock_count", OPT_MAX_WRITE_LOCK_COUNT,
3662
N_("After this many write locks, allow some read locks to run in between."),
3770
"After this many write locks, allow some read locks to run in between.",
3663
3771
(char**) &max_write_lock_count, (char**) &max_write_lock_count, 0, GET_ULONG,
3664
3772
REQUIRED_ARG, ULONG_MAX, 1, ULONG_MAX, 0, 1, 0},
3665
3773
{"min_examined_row_limit", OPT_MIN_EXAMINED_ROW_LIMIT,
3666
N_("Don't log queries which examine less than min_examined_row_limit "
3774
"Don't log queries which examine less than min_examined_row_limit rows to file.",
3668
3775
(char**) &global_system_variables.min_examined_row_limit,
3669
3776
(char**) &max_system_variables.min_examined_row_limit, 0, GET_ULONG,
3670
REQUIRED_ARG, 0, 0, ULONG_MAX, 0, 1L, 0},
3777
REQUIRED_ARG, 0, 0, ULONG_MAX, 0, 1L, 0},
3671
3778
{"myisam_block_size", OPT_MYISAM_BLOCK_SIZE,
3672
N_("Block size to be used for MyISAM index pages."),
3779
"Block size to be used for MyISAM index pages.",
3673
3780
(char**) &opt_myisam_block_size,
3674
3781
(char**) &opt_myisam_block_size, 0, GET_ULONG, REQUIRED_ARG,
3675
3782
MI_KEY_BLOCK_LENGTH, MI_MIN_KEY_BLOCK_LENGTH, MI_MAX_KEY_BLOCK_LENGTH,
3676
3783
0, MI_MIN_KEY_BLOCK_LENGTH, 0},
3677
3784
{"myisam_data_pointer_size", OPT_MYISAM_DATA_POINTER_SIZE,
3678
N_("Default pointer size to be used for MyISAM tables."),
3785
"Default pointer size to be used for MyISAM tables.",
3679
3786
(char**) &myisam_data_pointer_size,
3680
3787
(char**) &myisam_data_pointer_size, 0, GET_ULONG, REQUIRED_ARG,
3681
3788
6, 2, 7, 0, 1, 0},
3789
{"myisam_max_extra_sort_file_size", OPT_MYISAM_MAX_EXTRA_SORT_FILE_SIZE,
3790
"Deprecated option",
3791
(char**) &global_system_variables.myisam_max_extra_sort_file_size,
3792
(char**) &max_system_variables.myisam_max_extra_sort_file_size,
3793
0, GET_ULL, REQUIRED_ARG, (uint64_t) MI_MAX_TEMP_LENGTH,
3794
0, (uint64_t) MAX_FILE_SIZE, 0, 1, 0},
3682
3795
{"myisam_max_sort_file_size", OPT_MYISAM_MAX_SORT_FILE_SIZE,
3683
N_("Don't use the fast sort index method to created index if the "
3684
"temporary file would get bigger than this."),
3796
"Don't use the fast sort index method to created index if the temporary file would get bigger than this.",
3685
3797
(char**) &global_system_variables.myisam_max_sort_file_size,
3686
3798
(char**) &max_system_variables.myisam_max_sort_file_size, 0,
3687
3799
GET_ULL, REQUIRED_ARG, (int64_t) LONG_MAX, 0, (uint64_t) MAX_FILE_SIZE,
3688
3800
0, 1024*1024, 0},
3689
3801
{"myisam_repair_threads", OPT_MYISAM_REPAIR_THREADS,
3690
N_("Number of threads to use when repairing MyISAM tables. The value of "
3691
"1 disables parallel repair."),
3802
"Number of threads to use when repairing MyISAM tables. The value of 1 disables parallel repair.",
3692
3803
(char**) &global_system_variables.myisam_repair_threads,
3693
3804
(char**) &max_system_variables.myisam_repair_threads, 0,
3694
3805
GET_ULONG, REQUIRED_ARG, 1, 1, ULONG_MAX, 0, 1, 0},
3695
3806
{"myisam_sort_buffer_size", OPT_MYISAM_SORT_BUFFER_SIZE,
3696
N_("The buffer that is allocated when sorting the index when doing a "
3697
"REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE."),
3807
"The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.",
3698
3808
(char**) &global_system_variables.myisam_sort_buff_size,
3699
3809
(char**) &max_system_variables.myisam_sort_buff_size, 0,
3700
GET_ULONG, REQUIRED_ARG, 8192*1024, 4, INT32_MAX, 0, 1, 0},
3810
GET_ULONG, REQUIRED_ARG, 8192*1024, 4, ~0L, 0, 1, 0},
3701
3811
{"myisam_stats_method", OPT_MYISAM_STATS_METHOD,
3702
N_("Specifies how MyISAM index statistics collection code should threat "
3703
"NULLs. Possible values of name are 'nulls_unequal' "
3704
"(default behavior), "
3705
"'nulls_equal' (emulate MySQL 4.0 behavior), and 'nulls_ignored'."),
3812
"Specifies how MyISAM index statistics collection code should threat NULLs. "
3813
"Possible values of name are \"nulls_unequal\" (default behavior for 4.1/5.0), "
3814
"\"nulls_equal\" (emulate 4.0 behavior), and \"nulls_ignored\".",
3706
3815
(char**) &myisam_stats_method_str, (char**) &myisam_stats_method_str, 0,
3707
3816
GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3708
3817
{"net_buffer_length", OPT_NET_BUFFER_LENGTH,
3709
N_("Buffer length for TCP/IP and socket communication."),
3818
"Buffer length for TCP/IP and socket communication.",
3710
3819
(char**) &global_system_variables.net_buffer_length,
3711
3820
(char**) &max_system_variables.net_buffer_length, 0, GET_ULONG,
3712
3821
REQUIRED_ARG, 16384, 1024, 1024*1024L, 0, 1024, 0},
3713
3822
{"net_read_timeout", OPT_NET_READ_TIMEOUT,
3714
N_("Number of seconds to wait for more data from a connection before "
3715
"aborting the read."),
3823
"Number of seconds to wait for more data from a connection before aborting the read.",
3716
3824
(char**) &global_system_variables.net_read_timeout,
3717
3825
(char**) &max_system_variables.net_read_timeout, 0, GET_ULONG,
3718
3826
REQUIRED_ARG, NET_READ_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
3719
3827
{"net_retry_count", OPT_NET_RETRY_COUNT,
3720
N_("If a read on a communication port is interrupted, retry this many "
3721
"times before giving up."),
3828
"If a read on a communication port is interrupted, retry this many times before giving up.",
3722
3829
(char**) &global_system_variables.net_retry_count,
3723
3830
(char**) &max_system_variables.net_retry_count,0,
3724
3831
GET_ULONG, REQUIRED_ARG, MYSQLD_NET_RETRY_COUNT, 1, ULONG_MAX, 0, 1, 0},
3725
3832
{"net_write_timeout", OPT_NET_WRITE_TIMEOUT,
3726
N_("Number of seconds to wait for a block to be written to a connection "
3727
"before aborting the write."),
3833
"Number of seconds to wait for a block to be written to a connection before aborting the write.",
3728
3834
(char**) &global_system_variables.net_write_timeout,
3729
3835
(char**) &max_system_variables.net_write_timeout, 0, GET_ULONG,
3730
3836
REQUIRED_ARG, NET_WRITE_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
3731
{ "old", OPT_OLD_MODE,
3732
N_("Use compatible behavior."),
3837
{ "old", OPT_OLD_MODE, "Use compatible behavior.",
3733
3838
(char**) &global_system_variables.old_mode,
3734
(char**) &max_system_variables.old_mode, 0, GET_BOOL, NO_ARG,
3839
(char**) &max_system_variables.old_mode, 0, GET_BOOL, NO_ARG,
3735
3840
0, 0, 0, 0, 0, 0},
3736
3841
{"open_files_limit", OPT_OPEN_FILES_LIMIT,
3737
N_("If this is not 0, then mysqld will use this value to reserve file "
3738
"descriptors to use with setrlimit(). If this value is 0 then mysqld "
3739
"will reserve max_connections*5 or max_connections + table_cache*2 "
3740
"(whichever is larger) number of files."),
3842
"If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 then mysqld will reserve max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of files.",
3741
3843
(char**) &open_files_limit, (char**) &open_files_limit, 0, GET_ULONG,
3742
3844
REQUIRED_ARG, 0, 0, OS_FILE_LIMIT, 0, 1, 0},
3743
3845
{"optimizer_prune_level", OPT_OPTIMIZER_PRUNE_LEVEL,
3744
N_("Controls the heuristic(s) applied during query optimization to prune "
3745
"less-promising partial plans from the optimizer search space. Meaning: "
3746
"0 - do not apply any heuristic, thus perform exhaustive search; "
3747
"1 - prune plans based on number of retrieved rows."),
3846
"Controls the heuristic(s) applied during query optimization to prune less-promising partial plans from the optimizer search space. Meaning: 0 - do not apply any heuristic, thus perform exhaustive search; 1 - prune plans based on number of retrieved rows.",
3748
3847
(char**) &global_system_variables.optimizer_prune_level,
3749
3848
(char**) &max_system_variables.optimizer_prune_level,
3750
3849
0, GET_ULONG, OPT_ARG, 1, 0, 1, 0, 1, 0},
3751
3850
{"optimizer_search_depth", OPT_OPTIMIZER_SEARCH_DEPTH,
3752
N_("Maximum depth of search performed by the query optimizer. Values "
3753
"larger than the number of relations in a query result in better query "
3754
"plans, but take longer to compile a query. Smaller values than the "
3755
"number of tables in a relation result in faster optimization, but may "
3756
"produce very bad query plans. If set to 0, the system will "
3757
"automatically pick a reasonable value; if set to MAX_TABLES+2, the "
3758
"optimizer will switch to the original find_best (used for "
3759
"testing/comparison)."),
3851
"Maximum depth of search performed by the query optimizer. Values larger than the number of relations in a query result in better query plans, but take longer to compile a query. Smaller values than the number of tables in a relation result in faster optimization, but may produce very bad query plans. If set to 0, the system will automatically pick a reasonable value; if set to MAX_TABLES+2, the optimizer will switch to the original find_best (used for testing/comparison).",
3760
3852
(char**) &global_system_variables.optimizer_search_depth,
3761
3853
(char**) &max_system_variables.optimizer_search_depth,
3762
3854
0, GET_ULONG, OPT_ARG, MAX_TABLES+1, 0, MAX_TABLES+2, 0, 1, 0},
3763
3855
{"plugin_dir", OPT_PLUGIN_DIR,
3764
N_("Directory for plugins."),
3856
"Directory for plugins.",
3765
3857
(char**) &opt_plugin_dir_ptr, (char**) &opt_plugin_dir_ptr, 0,
3766
3858
GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3767
3859
{"plugin_load", OPT_PLUGIN_LOAD,
3768
N_("Optional comma separated list of plugins to load, where each plugin is "
3769
"identified by the name of the shared library. "
3770
"[for example: --plugin_load=libmd5udf.so]"),
3860
"Optional colon separated list of plugins to load, where each plugin is "
3861
"identified by name and path to library seperated by an equals.",
3771
3862
(char**) &opt_plugin_load, (char**) &opt_plugin_load, 0,
3772
3863
GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3773
3864
{"preload_buffer_size", OPT_PRELOAD_BUFFER_SIZE,
3774
N_("The size of the buffer that is allocated when preloading indexes"),
3865
"The size of the buffer that is allocated when preloading indexes",
3775
3866
(char**) &global_system_variables.preload_buff_size,
3776
3867
(char**) &max_system_variables.preload_buff_size, 0, GET_ULONG,
3777
3868
REQUIRED_ARG, 32*1024L, 1024, 1024*1024*1024L, 0, 1, 0},
3778
3869
{"query_alloc_block_size", OPT_QUERY_ALLOC_BLOCK_SIZE,
3779
N_("Allocation block size for query parsing and execution"),
3870
"Allocation block size for query parsing and execution",
3780
3871
(char**) &global_system_variables.query_alloc_block_size,
3781
3872
(char**) &max_system_variables.query_alloc_block_size, 0, GET_ULONG,
3782
3873
REQUIRED_ARG, QUERY_ALLOC_BLOCK_SIZE, 1024, ULONG_MAX, 0, 1024, 0},
3783
3874
{"query_prealloc_size", OPT_QUERY_PREALLOC_SIZE,
3784
N_("Persistent buffer for query parsing and execution"),
3875
"Persistent buffer for query parsing and execution",
3785
3876
(char**) &global_system_variables.query_prealloc_size,
3786
3877
(char**) &max_system_variables.query_prealloc_size, 0, GET_ULONG,
3787
3878
REQUIRED_ARG, QUERY_ALLOC_PREALLOC_SIZE, QUERY_ALLOC_PREALLOC_SIZE,
3788
3879
ULONG_MAX, 0, 1024, 0},
3789
3880
{"range_alloc_block_size", OPT_RANGE_ALLOC_BLOCK_SIZE,
3790
N_("Allocation block size for storing ranges during optimization"),
3881
"Allocation block size for storing ranges during optimization",
3791
3882
(char**) &global_system_variables.range_alloc_block_size,
3792
3883
(char**) &max_system_variables.range_alloc_block_size, 0, GET_ULONG,
3793
3884
REQUIRED_ARG, RANGE_ALLOC_BLOCK_SIZE, RANGE_ALLOC_BLOCK_SIZE, ULONG_MAX,
3795
3886
{"read_buffer_size", OPT_RECORD_BUFFER,
3796
N_("Each thread that does a sequential scan allocates a buffer of this "
3797
"size for each table it scans. If you do many sequential scans, you may "
3798
"want to increase this value."),
3887
"Each thread that does a sequential scan allocates a buffer of this size for each table it scans. If you do many sequential scans, you may want to increase this value.",
3799
3888
(char**) &global_system_variables.read_buff_size,
3800
3889
(char**) &max_system_variables.read_buff_size,0, GET_ULONG, REQUIRED_ARG,
3801
128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, INT32_MAX, MALLOC_OVERHEAD, IO_SIZE,
3890
128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, INT_MAX32, MALLOC_OVERHEAD, IO_SIZE,
3803
3892
{"read_only", OPT_READONLY,
3804
N_("Make all non-temporary tables read-only, with the exception for "
3805
"replication (slave) threads and users with the SUPER privilege"),
3893
"Make all non-temporary tables read-only, with the exception for replication (slave) threads and users with the SUPER privilege",
3806
3894
(char**) &opt_readonly,
3807
3895
(char**) &opt_readonly,
3808
3896
0, GET_BOOL, NO_ARG, 0, 0, 1, 0, 1, 0},
3809
3897
{"read_rnd_buffer_size", OPT_RECORD_RND_BUFFER,
3810
N_("When reading rows in sorted order after a sort, the rows are read "
3811
"through this buffer to avoid a disk seeks. If not set, then it's set "
3812
"to the value of record_buffer."),
3898
"When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks. If not set, then it's set to the value of record_buffer.",
3813
3899
(char**) &global_system_variables.read_rnd_buff_size,
3814
3900
(char**) &max_system_variables.read_rnd_buff_size, 0,
3815
3901
GET_ULONG, REQUIRED_ARG, 256*1024L, 64 /*IO_SIZE*2+MALLOC_OVERHEAD*/ ,
3816
INT32_MAX, MALLOC_OVERHEAD, 1 /* Small lower limit to be able to test MRR */, 0},
3902
INT_MAX32, MALLOC_OVERHEAD, 1 /* Small lower limit to be able to test MRR */, 0},
3817
3903
{"record_buffer", OPT_RECORD_BUFFER,
3818
3904
"Alias for read_buffer_size",
3819
3905
(char**) &global_system_variables.read_buff_size,
3820
3906
(char**) &max_system_variables.read_buff_size,0, GET_ULONG, REQUIRED_ARG,
3821
128*1024L, IO_SIZE*2+MALLOC_OVERHEAD,
3822
INT32_MAX, MALLOC_OVERHEAD, IO_SIZE, 0},
3907
128*1024L, IO_SIZE*2+MALLOC_OVERHEAD, INT_MAX32, MALLOC_OVERHEAD, IO_SIZE, 0},
3823
3908
{"relay_log_purge", OPT_RELAY_LOG_PURGE,
3824
N_("0 = do not purge relay logs. "
3825
"1 = purge them as soon as they are no more needed."),
3909
"0 = do not purge relay logs. 1 = purge them as soon as they are no more needed.",
3826
3910
(char**) &relay_log_purge,
3827
3911
(char**) &relay_log_purge, 0, GET_BOOL, NO_ARG,
3828
3912
1, 0, 1, 0, 1, 0},
3829
3913
{"relay_log_space_limit", OPT_RELAY_LOG_SPACE_LIMIT,
3830
N_("Maximum space to use for all relay logs."),
3914
"Maximum space to use for all relay logs.",
3831
3915
(char**) &relay_log_space_limit,
3832
3916
(char**) &relay_log_space_limit, 0, GET_ULL, REQUIRED_ARG, 0L, 0L,
3833
3917
(int64_t) ULONG_MAX, 0, 1, 0},
3834
3918
{"slave_compressed_protocol", OPT_SLAVE_COMPRESSED_PROTOCOL,
3835
N_("Use compression on master/slave protocol."),
3919
"Use compression on master/slave protocol.",
3836
3920
(char**) &opt_slave_compressed_protocol,
3837
3921
(char**) &opt_slave_compressed_protocol,
3838
3922
0, GET_BOOL, NO_ARG, 0, 0, 1, 0, 1, 0},
3839
3923
{"slave_net_timeout", OPT_SLAVE_NET_TIMEOUT,
3840
N_("Number of seconds to wait for more data from a master/slave connection "
3841
"before aborting the read."),
3924
"Number of seconds to wait for more data from a master/slave connection before aborting the read.",
3842
3925
(char**) &slave_net_timeout, (char**) &slave_net_timeout, 0,
3843
3926
GET_ULONG, REQUIRED_ARG, SLAVE_NET_TIMEOUT, 1, LONG_TIMEOUT, 0, 1, 0},
3844
3927
{"slave_transaction_retries", OPT_SLAVE_TRANS_RETRIES,
3845
N_("Number of times the slave SQL thread will retry a transaction in case "
3846
"it failed with a deadlock or elapsed lock wait timeout, "
3847
"before giving up and stopping."),
3928
"Number of times the slave SQL thread will retry a transaction in case "
3929
"it failed with a deadlock or elapsed lock wait timeout, "
3930
"before giving up and stopping.",
3848
3931
(char**) &slave_trans_retries, (char**) &slave_trans_retries, 0,
3849
3932
GET_ULONG, REQUIRED_ARG, 10L, 0L, (int64_t) ULONG_MAX, 0, 1, 0},
3850
3933
{"slave-allow-batching", OPT_SLAVE_ALLOW_BATCHING,
3851
N_("Allow slave to batch requests."),
3934
"Allow slave to batch requests.",
3852
3935
(char**) &slave_allow_batching, (char**) &slave_allow_batching,
3853
3936
0, GET_BOOL, NO_ARG, 0, 0, 1, 0, 1, 0},
3854
3937
{"slow_launch_time", OPT_SLOW_LAUNCH_TIME,
3855
N_("If creating the thread takes longer than this value (in seconds), the "
3856
"Slow_launch_threads counter will be incremented."),
3938
"If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented.",
3857
3939
(char**) &slow_launch_time, (char**) &slow_launch_time, 0, GET_ULONG,
3858
3940
REQUIRED_ARG, 2L, 0L, LONG_TIMEOUT, 0, 1, 0},
3859
3941
{"sort_buffer_size", OPT_SORT_BUFFER,
3860
N_("Each thread that needs to do a sort allocates a buffer of this size."),
3942
"Each thread that needs to do a sort allocates a buffer of this size.",
3861
3943
(char**) &global_system_variables.sortbuff_size,
3862
3944
(char**) &max_system_variables.sortbuff_size, 0, GET_ULONG, REQUIRED_ARG,
3863
3945
MAX_SORT_MEMORY, MIN_SORT_MEMORY+MALLOC_OVERHEAD*2, ULONG_MAX,
3864
3946
MALLOC_OVERHEAD, 1, 0},
3865
3947
{"sync-binlog", OPT_SYNC_BINLOG,
3866
N_("Synchronously flush binary log to disk after every #th event. "
3867
"Use 0 (default) to disable synchronous flushing."),
3948
"Synchronously flush binary log to disk after every #th event. "
3949
"Use 0 (default) to disable synchronous flushing.",
3868
3950
(char**) &sync_binlog_period, (char**) &sync_binlog_period, 0, GET_ULONG,
3869
3951
REQUIRED_ARG, 0, 0, ULONG_MAX, 0, 1, 0},
3952
{"sync-frm", OPT_SYNC_FRM, "Sync .frm to disk on create. Enabled by default.",
3953
(char**) &opt_sync_frm, (char**) &opt_sync_frm, 0, GET_BOOL, NO_ARG, 1, 0,
3955
{"table_cache", OPT_TABLE_OPEN_CACHE,
3956
"Deprecated; use --table_open_cache instead.",
3957
(char**) &table_cache_size, (char**) &table_cache_size, 0, GET_ULONG,
3958
REQUIRED_ARG, TABLE_OPEN_CACHE_DEFAULT, 1, 512*1024L, 0, 1, 0},
3870
3959
{"table_definition_cache", OPT_TABLE_DEF_CACHE,
3871
N_("The number of cached table definitions."),
3960
"The number of cached table definitions.",
3872
3961
(char**) &table_def_size, (char**) &table_def_size,
3873
3962
0, GET_ULONG, REQUIRED_ARG, 128, 1, 512*1024L, 0, 1, 0},
3874
3963
{"table_open_cache", OPT_TABLE_OPEN_CACHE,
3875
N_("The number of cached open tables."),
3964
"The number of cached open tables.",
3876
3965
(char**) &table_cache_size, (char**) &table_cache_size, 0, GET_ULONG,
3877
3966
REQUIRED_ARG, TABLE_OPEN_CACHE_DEFAULT, 1, 512*1024L, 0, 1, 0},
3878
3967
{"table_lock_wait_timeout", OPT_TABLE_LOCK_WAIT_TIMEOUT,
3879
N_("Timeout in seconds to wait for a table level lock before returning an "
3880
"error. Used only if the connection has active cursors."),
3968
"Timeout in seconds to wait for a table level lock before returning an "
3969
"error. Used only if the connection has active cursors.",
3881
3970
(char**) &table_lock_wait_timeout, (char**) &table_lock_wait_timeout,
3882
3971
0, GET_ULONG, REQUIRED_ARG, 50, 1, 1024 * 1024 * 1024, 0, 1, 0},
3883
3972
{"thread_cache_size", OPT_THREAD_CACHE_SIZE,
3884
N_("How many threads we should keep in a cache for reuse."),
3973
"How many threads we should keep in a cache for reuse.",
3885
3974
(char**) &thread_cache_size, (char**) &thread_cache_size, 0, GET_ULONG,
3886
3975
REQUIRED_ARG, 0, 0, 16384, 0, 1, 0},
3887
3976
{"thread_pool_size", OPT_THREAD_CACHE_SIZE,
3888
N_("How many threads we should create to handle query requests in case of "
3889
"'thread_handling=pool-of-threads'"),
3977
"How many threads we should create to handle query requests in case of 'thread_handling=pool-of-threads'",
3890
3978
(char**) &thread_pool_size, (char**) &thread_pool_size, 0, GET_ULONG,
3891
3979
REQUIRED_ARG, 20, 1, 16384, 0, 1, 0},
3892
3980
{"thread_stack", OPT_THREAD_STACK,
3893
N_("The stack size for each thread."),
3894
(char**) &my_thread_stack_size,
3895
(char**) &my_thread_stack_size, 0, GET_ULONG,
3896
REQUIRED_ARG,DEFAULT_THREAD_STACK,
3981
"The stack size for each thread.", (char**) &my_thread_stack_size,
3982
(char**) &my_thread_stack_size, 0, GET_ULONG, REQUIRED_ARG,DEFAULT_THREAD_STACK,
3897
3983
1024L*128L, ULONG_MAX, 0, 1024, 0},
3898
3984
{ "time_format", OPT_TIME_FORMAT,
3899
N_("The TIME format (for future)."),
3900
(char**) &opt_date_time_formats[DRIZZLE_TIMESTAMP_TIME],
3901
(char**) &opt_date_time_formats[DRIZZLE_TIMESTAMP_TIME],
3985
"The TIME format (for future).",
3986
(char**) &opt_date_time_formats[MYSQL_TIMESTAMP_TIME],
3987
(char**) &opt_date_time_formats[MYSQL_TIMESTAMP_TIME],
3902
3988
0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0},
3903
3989
{"tmp_table_size", OPT_TMP_TABLE_SIZE,
3904
N_("If an internal in-memory temporary table exceeds this size, MySQL will"
3905
" automatically convert it to an on-disk MyISAM table."),
3990
"If an internal in-memory temporary table exceeds this size, MySQL will"
3991
" automatically convert it to an on-disk MyISAM table.",
3906
3992
(char**) &global_system_variables.tmp_table_size,
3907
3993
(char**) &max_system_variables.tmp_table_size, 0, GET_ULL,
3908
3994
REQUIRED_ARG, 16*1024*1024L, 1024, MAX_MEM_TABLE_SIZE, 0, 1, 0},
3909
3995
{"transaction_alloc_block_size", OPT_TRANS_ALLOC_BLOCK_SIZE,
3910
N_("Allocation block size for transactions to be stored in binary log"),
3996
"Allocation block size for transactions to be stored in binary log",
3911
3997
(char**) &global_system_variables.trans_alloc_block_size,
3912
3998
(char**) &max_system_variables.trans_alloc_block_size, 0, GET_ULONG,
3913
3999
REQUIRED_ARG, QUERY_ALLOC_BLOCK_SIZE, 1024, ULONG_MAX, 0, 1024, 0},
3914
4000
{"transaction_prealloc_size", OPT_TRANS_PREALLOC_SIZE,
3915
N_("Persistent buffer for transactions to be stored in binary log"),
4001
"Persistent buffer for transactions to be stored in binary log",
3916
4002
(char**) &global_system_variables.trans_prealloc_size,
3917
4003
(char**) &max_system_variables.trans_prealloc_size, 0, GET_ULONG,
3918
4004
REQUIRED_ARG, TRANS_ALLOC_PREALLOC_SIZE, 1024, ULONG_MAX, 0, 1024, 0},
3919
4005
{"wait_timeout", OPT_WAIT_TIMEOUT,
3920
N_("The number of seconds the server waits for activity on a connection "
3921
"before closing it."),
4006
"The number of seconds the server waits for activity on a connection before closing it.",
3922
4007
(char**) &global_system_variables.net_wait_timeout,
3923
4008
(char**) &max_system_variables.net_wait_timeout, 0, GET_ULONG,
3924
REQUIRED_ARG, NET_WAIT_TIMEOUT, 1, LONG_TIMEOUT,
4009
REQUIRED_ARG, NET_WAIT_TIMEOUT, 1, IF_WIN(INT_MAX32/1000, LONG_TIMEOUT),
3926
4011
{0, 0, 0, 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0}
3929
static int show_net_compression(THD *thd __attribute__((unused)),
4014
static int show_net_compression(THD *thd __attribute__((__unused__)),
3931
char *buff __attribute__((unused)))
4016
char *buff __attribute__((__unused__)))
3933
4018
var->type= SHOW_MY_BOOL;
3934
4019
var->value= (char *)&thd->net.compress;
added
removed
server/drizzled.cc
