MySQL 5.1 config model (10/23/07)



Compile-Time Options

Option Name Settings
archive_storage_engine
--with-archive-storage-engine
NULL
assembler
-enable-assembler
NULL
big_tables
--with-big-tables
NULL
blackhole_storage_engine
--with-blackhole-storage-engine
NULL
client_ldflags
--with-client-ldflags="-static"
NULL
csv_storage_engine
--with-csv-storage-engine
NULL
example_storage_engine
--with-example-storage-engine
NULL
extra_charsets
--with-extra-charsets=all
--with-extra-charsets=complex
NULL
fast_mutexes
--with-fast-mutexes
NULL
federated_storage_engine
--with-federated-storage-engine
NULL
innodb
--with-innodb
--without-innodb
NULL
libedit
--with-libedit
NULL
local_infile
--enable-local-infile
NULL
mysqld_ldflags
--with-mysqld-ldflags="-static"
NULL
ndbcluster
--with-ndbcluster
NULL
pic
--with-pic
NULL
readline
--with-readline
NULL
ssl
--with-ssl
NULL
thread_safe_client
--enable-thread-safe-client
NULL
zlib_dir
--with-zlib-dir=bundled
NULL

Run-Time Options

Option Name Settings
innodb_flush_log_at_trx_commit
--mysqld="--innodb_flush_log_at_trx_commit=0"
--mysqld="--innodb_flush_log_at_trx_commit=1"
--mysqld="--innodb_flush_log_at_trx_commit=2"
NULL
sql_mode
--mysqld="--sql-mode=ANSI"
--mysqld="--sql-mode=STRICT_ALL_TABLES"
--mysqld="--sql-mode=TRADITIONAL"
transaction_isolation
--mysqld="--transaction-isolation=READ-COMMITTED"
--mysqld="--transaction-isolation=READ-UNCOMMITTED"
--mysqld="--transaction-isolation=REPEATABLE-READ"
--mysqld="--transaction-isolation=SERIALIZABLE"
NULL

Constraints

Rules
if (innodb = "--without-innodb") transaction-isolation = NULL
if (innodb = "--without-innodb") innodb_flush_log_at_trx_commit = NULL
if (libedit = "--with-libedit") readline = NULL
if (readline = "--with-readline") libedit = NULL