[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=/opt/mysql/data-5.1 #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=/opt/mysql/tmp #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.index #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. #binlog-do-db= #binlog-ignore-db= ############################# # # 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=65530 #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. core-file #Write a core file if mysqld dies. For some systems, you must also specify the --core-file-size option to mysqld_safe. ############################# # # 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 # ############################# #innodb #Enable InnoDb #skip-innodb #Disable the InnoDB # #innodb_additional_mem_pool_size=1Mb #The size in bytes of a memory pool InnoDB uses to store data dictionary information and other internal data structures. #innodb_autoextend_increment=8 #The increment size (in MB) for extending the size of an auto-extending tablespace when it becomes full. The default value is 8. #innodb_buffer_pool_awe_mem_mb #The size of the buffer pool (in MB), if it is placed in the AWE memory. This is relevant only in 32-bit Windows. #innodb_buffer_pool_size #The size in bytes of the memory buffer InnoDB uses to cache data and indexes of its tables. #innodb_checksums #InnoDB can use checksum validation on all pages read from the disk to ensure extra fault tolerance against broken hardware or data files. #skip-innodb-checksums #Disable checksums #innodb_commit_concurrency=0 #The number of threads that can commit at the same time. A value of 0 disables concurrency control. #innodb_concurrency_tickets= #When a thread is allowed to enter InnoDB, it is given a number of “free tickets” equal to the value of innodb_concurrency_tickets #innodb_thread_concurrency= #InnoDB tries to keep the number of operating system threads concurrently inside InnoDB less than or equal to the limit given by this variable. #processors+#disk #innodb_thread_sleep_delay=10000 #How long InnoDB threads sleep before joining the InnoDB queue, in microseconds. The default value is 10,000. A value of 0 disables sleep. #innodb_data_file_path #The paths to individual data files and their sizes. The full directory path to each data file is formed by concatenating with innodb_data_home_dir #innodb_data_home_dir #The common part of the directory path for all InnoDB data files. If you do not set this value, the default is the MySQL data directory. #innodb_doublewrite #By default, InnoDB stores all data twice, first to the doublewrite buffer, and then to the actual data files. This variable is enabled by default. #skip-innodb-doublewrite #innodb_fast_shutdown=1 #0: full purge and an insert buffer merge before a shutdown. 1: skip these operations at shutdown. 2: flush logs and then shut down cold #innodb_file_io_threads=4 #No of I/O threads in InnoDB. Default 4. Disk I/O on Windows may benefit from a larger number. Default value is always used in Unix. #innodb_file_per_table #If this variable is enabled, InnoDB creates each new table using its own .ibd file for storing data and indexes, rather than in the shared tablespace. #innodb_flush_log_at_trx_commit=1 #0: log buffer flushed each second. 1: the log buffer flused at commit. 2: log buffer written to file at commit, flush to diske once per second. #innodb_flush_method=fdatasync #fdatasync. O_DSYNC. O_DIRECT. Windows: async_unbuffered. #innodb_force_recovery=0 #0 - 6. set greater than 0 only in emergency to dump tables from corrupt database. see http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html #innodb_lock_wait_timeout=50 #The timeout in seconds an InnoDB transaction may wait for a lock before being rolled back. default 50 #innodb_locks_unsafe_for_binlog=0 #By default, this variable is 0 (disabled), which means that next-key locking is enabled. If enabled, highest isolation level is READ COMMITTED. #innodb_log_arch_dir= #The directory where fully written log files would be archived if we used log archiving. #innodb_log_archive=0 #Whether to log InnoDB archive files. This variable is present for historical reasons, but is unused. #innodb_log_buffer_size=1Mb #The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Sensible values range from 1MB to 8MB. The default is 1MB. #innodb_log_file_size=5Mb #Sensible values range from 1MB to 1/N-th of the size of the buffer pool, where N is the number of log files in the group. #innodb_log_files_in_group=2 #The number of log files in the log group. InnoDB writes to the files in a circular fashion. The default (and recommended) is 2. #innodb_log_group_home_dir= #The directory path to the InnoDB log files. It must have the same value as innodb_log_arch_dir. #innodb_max_dirty_pages_pct=90 #0-100. InnoDB tries to write pages from the buffer pool so that the percentage of dirty (not yet written) pages will not exceed this value. #innodb_max_purge_lag=0 #This variable controls how to delay INSERT, UPDATE and DELETE operations when the purge operations are lagging. #innodb_mirrored_log_groups=1 #The number of identical copies of log groups to keep for the database. Currently, this should be set to 1. #innodb_open_files=300 #Specifies the max # .ibd files kept open at one time. Minimum 10, default 300. relevant only if you use multiple tablespaces #innodb_status_file #innodb_support_xa=1 #if not using XA, setting it to OFF or 0 reduces the number of disk flushes for better performance. #innodb_sync_spin_loops #The number of times a thread waits for an InnoDB mutex to be freed before the thread is suspended. #innodb_table_locks=1 #default 1, meaning LOCK TABLES causes internal table lock. When AUTOCOMMIT=1, internal table locks can cause deadlocks. innodb_table_locks=0 solves that. ############################# # # NDB # ############################# skip-ndbcluster #Disable the NDB Cluster storage engine. This is the default for binaries that were built with NDB Cluster storage engine support; #ndbcluster #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