Algunes notes rapides, per anar per feina:
llistar les variables: "show variables"
per assignar: SET [ GLOBAL | SESSION | MAX ] variable=value
GLOBAL es ocm guardar-ho a my.cnf
variables que es poden canviar
big-tables
binlog-do-db
binlog-ignore-db
des-key-file
default-character-set ?
default-table-type
delay-key-write-for-all-tables
log
log-bin
log-bin-index
log-update
log-slow-queries
log-long-format
log-slave-updates
low-priority-updates
myisam-recover
disconnect-slave-event-count
abort-slave-event-count
max-binlog-dump-events
sporadic-binlog-dump-fail
replicate*
safe-show-database
safe-user-create
server-id ?
show-slave-auth-info
skip-concurrent-insert
skip-delay-key-write
skip-host-cache
skip-name-resolve
skip-show-database
skip-symlink
slave-load-tmpdir ?
sql-bin-update-same
sql-mode
transaction-isolation
tmpdir ?
warnings
NO es poden canviar:
back_log
bdb_*
ft_min_word_len
ft_max_word_len
ft_max_word_len_for_sort
innodb_*
lower_case_table_names
open_files_limit
Un exemple, Activar bin-log per fer realtime backup.
binlog-do-db DBname
http://lists.mysql.com/internals/2708