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