[mysqld] ############################# # # connections # ############################# #bind-address=127.0.0.1 #used for machines with multiple network adapters? #port=3306 #socket=/tmp/mysql.sock #max_allowed_packet=8M #back_log= #OS dependent size of the stack for stalled connection requests. #connect_timeout= #seconds to wait for a connect packet #shared-memory #Enable shared-memory connections by local clients. This option is available only on Windows. #shared-memory-base-name=MYSQL #The (case sensitive) name of shared memory to use for shared-memory connections (default MYSQL). #skip-host-cache #No internal hostname cache for faster name-to-IP resolution. Query the DNS server when a client connects #skip-name-resolve #Do not resolve hostnames when checking client connections. Use only IP numbers. #skip-networking #Don't listen for TCP/IP connections at all. Use named pipes or shared memory (on Windows) or Unix socket files (on Unix). init-connect="set autocommit=0" #Make it work more like oracle ############################# # # authorization/security # ############################# #old-passwords #Force the server to generate short (pre-4.1) password hashes for new passwords. safe-user-create #If this option is enabled, a user cannot create new MySQL users by using the GRANT statement secure-auth #Disallow authentication by clients that attempt to use accounts that have old (pre-4.1) passwords. #skip-grant-tables #Don't use the privilege system at all. Anyone with access to the server has unrestricted access to all databases. ############################# # # Some paths # ############################# #basedir= #the MySQL installation base directory #character_sets_dir= #The directory where character sets are installed. #datadir= #chroot= #run mysql inside on tree in the filesystem #init-file=/opt/mysql/bleeding/init-file.sql #Read SQL statements from this file at startup. #pid-file=mysql.pid #The pathname of the process ID file. #tmpdir=path #he path of the directory to use for creating temporary files. ############################# # # Logging (see replication for binlog) # ############################# log=mysql_general.log #The general log log-warnings=1 #sets logging to certain level log-error=mysql_error.log #default: hostname.err log-output=TABLE,FILE #The option value can be given as one or more of the words TABLE, FILE, or NONE. log-queries-not-using-indexes #f you are using this option with --log-slow-queries, queries that do not use indexes are logged to the slow query log. #log-short-format #Log less information to the update log, binary update log, and slow query log, if they have been activated. log-slow-admin-statements #Log slow administrative statements such as OPTIMIZE TABLE, ANALYZE TABLE, and ALTER TABLE to the slow query log. log-slow-queries=mysql_slow_queries.log #This option enables logging to the slow query log. #console #Windows only.) Write error log messages to stderr and stdout even if --log-error is specified. ############################# # # binary log # ############################# log-bin=mysql-bin #path (defaults to data dir/host_name-bin) and name of the binary log. enable in master log-bin-index=mysql-bin #path (defaults to data dir/host_name-bin.index) and name of the binary log. enable in master #sync_binlog=1 #maximum durability for replication of InnoDB #binlog_cache_size= #The size of the cache to hold the SQL statements for the binary log during a transaction. #binlog_format= #STATEMENT|ROW|MIXED. Default STATEMENT #binlog-row-event-max-size=1024 #a multiple of 256 bytes to group binlog events #log-bin-trust-function-creators=1 #affects how MySQL enforces restrictions on stored function creation #expire_logs_days=0 #Number of days before removal of the binlog. Default 0 meaning no removal. ############################# # # syntax # ############################# #ansi #enable for ansi syntax sql_mode=TRADITIONAL,ANSI_QUOTES,PIPES_AS_CONCAT,IGNORE_SPACE,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION #set the sql mode ONLY_FULL_GROUP_BY lower_case_table_names=1 ############################# # # misc # ############################# group_concat_max_len=65535 #allow-suspicious-udfs #load udfs unaccompanied by init and deinit functions #big-tables #Allow large result sets by saving all temporary sets in files. #des-key-file= #Read the default DES keys from this file. These keys are used by the DES_ENCRYPT() and DES_DECRYPT() functions. #large-pages #Some hardware/operating system architectures support memory pages greater than the default #low-priority-updates #Give table-modifying operations (INSERT, REPLACE, DELETE, UPDATE) lower priority than selects. #memlock #Lock the mysqld process in memory. This works on systems such as Solaris that support the mlockall() system call. #open-files-limit=count #Change the number of file descriptors available to mysqld. #port-open-timeout=num #This option indicates how many seconds the server should wait for the TCP/IP port to become free if it cannot be opened. #safe-mode #Skip some optimization stages. #external-locking #Enable external locking (system locking) #skip-external-locking #Not external locking (system locking). Must shut down the server to use myisamchk #standalone #Available on Windows NT-based systems only; instructs the MySQL server not to run as a service. symbolic-links #Enable symbolic link support. #skip-symbolic-links #disable symbolic link support. #skip-show-database #With this option, the SHOW DATABASES statement is allowed only to users who have the SHOW DATABASES privilege, #skip-thread-priority #Disable using thread priorities for faster response time. temp_pool user=mysql local-infile=1 #If you start the server with --local-infile=0, clients cannot use LOCAL in LOAD DATA statements. ############################# # # debug # ############################# #debug='d:t:i:o,mysqld.trace' #if MySQL is configured with --with-debug, you can use this option to get a trace file of what mysqld is doing. #exit-info[=flags], -T [flags] #This is a bit mask of different flags that you can use for debugging the mysqld server. #log-isam= #Log all MyISAM changes to this file (used only when debugging MyISAM) #one-thread #Only use one thread (for debugging under Linux). This option is available only if the server is built with debugging enabled. #skip-safemalloc #If MySQL is configured with --with-debug=full, MySQL programs check for memory overruns. #skip-stack-trace #Don't write stack traces. This option is useful when you are running mysqld under a debugger. ############################# # # character sets and collations # ############################# #character-set-client-handshake #Don't ignore character set information sent by the client. #skip-character-set-client-handshake #Ignore client information and use the default server character set #character_set_client= #The character set for statements that arrive from the client. #character_set_results= #The character set used for returning query results to the client. #character_set_system #The character set used by the server for storing identifiers. The value is always utf8. character_set_server=utf8 #The server's default character set. collation_server=utf8_general_ci #The server's default collation. character_set_database=utf8 #The character set used by the default database. collation_database=utf8_general_ci #The collation used by the default database. character_set_connection=utf8 #The character set used for literals that do not have a character set introducer and for number-to-string conversion. collation_connection=utf8_general_ci #The collation of the connection character set. #character_set_filesystem= #The filesystem character set. This variable is used to interpret string literals that refer to filenames. The default value is binary. ############################# # # Date/Time settings # ############################# #date_format #not implemented #datetime_format #not implemented #default_week_format #format for the WEEK() function #default-time-zone=timezone #sysdate-is-now #This option causes SYSDATE() to be an alias for NOW(). ############################# # # Arithmetic # ############################# #div_precision_increment=4 #added pecision for / operations. 0-30, default 4 ############################# # # event scheduler # ############################# event_scheduler=on #On|Off|Disabled, default Off. ############################# # # Fulltext # ############################# #ft_boolean_syntax='+ -><()~*:""&|' #list of BOOLEAN MODE full-text operators. #ft_max_word_len= #The maximum length of the word to be included in a FULLTEXT index. #ft_min_word_len= #The minimum length of the word to be included in a FULLTEXT index. #ft_query_expansion_limit #No of top matches for full-text searches WITH QUERY EXPANSION. #ft_stopword_file #The file from which to read the list of stopwords for full-text searches. Empty string ('') disables stopword filtering. ############################# # # Disk flushing # ############################# #flush #enable to force disk flusing #flush_time=0 #no of seconds to close table and flush data to disk (use only on Windows 95/ME) ############################# # # Transactions # ############################# completion_type=1 #0|1|2. COMMIT/ROLLBACK behaviour, Unaffected?|Chain|Release. Default 0 transaction-isolation=REPEATABLE-READ ############################# # # XA Transactions # ############################# #log-tc=tc.log #The name of the memory-mapped transaction coordinator log file #log-tc-size=size #The size in bytes of the memory-mapped transaction coordinator log. The default size is 24KB. ############################# # # Engines # ############################# engine_condition_pushdown=1 #push down conditions to the storage engine for non-indexed columns default-storage-engine=InnoDB #Set the default storage engine (table type) for tables. ############################# # # MyISAM # ############################# #myisam-recover[=option[,option]...]] #Set the MyISAM storage engine recovery mode. The option value is any combination of the values of DEFAULT, BACKUP, FORCE, or QUICK. #bulk_insert_buffer_size= #buffer for bulk inserts. Default 8Mb, 0 to disable #concurrent_insert=2 #0|1|2 concurrent SELECT|INSERT behaviour Off|No Holes|Holes. Default 1 #skip-concurrent-insert Turn off concurrent insert. This is to be used only if you think you have found a bug in this feature #delay_key_write=ON #OFF|ON|ALL keeps key writes in memory. Speeds up inserts. use myisam-recover #delayed_insert_limit= #number of rows to insert with INSERT DELAYED before executing pending SELECT statements #delayed_insert_timeout= #timeout to wait for an INSERT DELAYED #delayed_queue_size= #number of rows queued to handle INSERT DELAYED statements #myisam_max_sort_file_size #The maximum size of the temporary file that MySQL is allowed to use while re-creating a MyISAM index. #myisam_max_sort_buffer_size #Set the size of the buffer used when recovering tables. ############################# # # MyISAM_MRG # ############################# #skip-merge #Disable the MERGE storage engine. ############################# # # InnoDB # ############################# #skip-innodb #Disable the InnoDB #innodb_locks_unsafe_for_binlog ############################# # # NDB # ############################# #skip-ndbcluster #Disable the NDB Cluster storage engine. This is the default for binaries that were built with NDB Cluster storage engine support; #ndb-cluster #if the binary includes support for the NDB Cluster storage engine, this option enables the engine, which is disabled by default. #ndb-connectstring=nodeid=2,myhost1:1100 #point out the management server that distributes the cluster configuration ############################# # # Replication (master) # ############################# #server-id=1 #unique id among a replication farm. enable in both master and slave #innodb_flush_log_at_trx_commit=1 #maximum durability for replication of InnoDB #auto_increment_increment=1 #default 1 #auto_increment_offset=1 #default 1 ############################# # # Replication (slave) # ############################# #server-id=2 #unique id among a replication farm. enable in both master and slave #report-host=slave_name #slave to be reported when registering #report-port=port #port to report when registering, don't use if using default port #slave_compressed_protocol=1 #use compression (default 0 means off) #skip-slave-start #use START SLAVE to manually start the slave #slave-skip-errors= #list of errors to ignore (replication stops on errors otherwise) [err_code1,err_code2,...|all] #master-host=192.168.1.101 #specifies the host that is master for this slave #master-user=rs #the account used by the slave to contact the master. This account must have the GRANT REPLICATION SLAVE privilege #master-password= #master-port= #slave-net-timeout= #timeout before retrying to connect #master-connect-retry= #number of seconds to wait before retrying a lost connection to the master (default 60) #master-retry-count= #maximum number of retries #master-info-file=master.info #used by the slave to store info about the master (default: master.info in the data directory) #master-ssl= #master-ssl-ca= #master-ssl-capath= #master-ssl-cert= #master-ssl-cipher= #master-ssl-key= #read-only #this slave does not accept updates outside replication #log-slave-updates=1 #enable to use this slave as a master (chained replication) #replicate-same-server-id #don't skip replication to self? #max-relay-log-size= #maximum filsesize before log rotation occurs. (default: 1 Gb) #relay-log= #name of the relay log file (default: host_name-relay-bin.nnnnnn) #relay-log-index= #name of the relay log index file file (default: host_name-relay-bin.index) #relay-log-info-file= #name of the relay log info file file (default: relay-log.info in data dir) #relay-log-purge=1 #automatic purging (default: 1 meaning on) #relay-log-space-limit=0 #limits size of relay logs. use for smalldisk slaves (default: 0 meaning no limit). #replicate-do-db=dabname #replicate this database. Add a separate line for each db, or write none to replicate all. #replicate-do-table=dbname.table #replicate this table. Add a separate line for each table, or write none to replicate all. #replicate-ignore-db=dabname #ignore this database. Add a separate line for each db. #replicate-ignore-table=dbname.table #ignore this table. Add a separate line for each table. #replicate-rewrite-db=from_name->to_name #replicate to another db #replicate-wild-do-table=db_name.tbl_name #use LIKE pattern syntax to include a set of tables to replicate #replicate-ignore-do-table=db_name.tbl_name #use LIKE pattern syntax to exclude a set of tables to replicate #slave-load-tmpdir= #use to specify a particular path for temporay file due to replicated LOAD_FILE calls [mysql] show-warnings