# Example mysql config file.\\ 
# Copy this file to c:\my.cnf to set global options\\ 
# \\ 
# One can use all long options that the program supports.\\ 
# Run the program with --help to get a list of available options\\ 
\\ 
# This will be passed to all mysql clients\\ 
[client]\\ 
#password=my_password\\ 
port=3306\\ 
#socket=MySQL\\ 
\\ 
# Here is entries for some specific programs\\ 
# The following values assume you have at least 32M ram\\ 
\\ 
# The MySQL server\\ 
[mysqld]\\ 
port=3306\\ 
#socket=MySQL\\ 
#(Unknown option:)skip-locking\\ 
#(Unknown option:)set-variable	= key_buffer=16M\\ 
set-variable	= max_allowed_packet=1M\\ 
set-variable	= table_cache=64\\ 
#(Unknown option:)set-variable	= sort_buffer=512K\\ 
set-variable	= net_buffer_length=8K\\ 
set-variable	= myisam_sort_buffer_size=8M\\ 
server-id	= 1\\ 
\\ 
# Uncomment the following if you want to log updates\\ 
# Das wird nur bei Master-Slave Replikation auf dem Master benötigt
#log-bin\\ 

\\ 
# Uncomment the following rows if you move the MySQL distribution to another\\ 
# location\\ 
#basedir = D:/com2sap/mysql/\\ 
#datadir = D:/com2sap/mysql/data/\\ 
\\ 
**basedir = C:/com2sap/mysql/\\ 
datadir = C:/com2sap/mysql/data/**\\ 
\\ 
# Uncomment the following if you are NOT using BDB tables\\ 
**skip-bdb\\ 
skip-innodb**\\ 
# Uncomment the following if you are using BDB tables\\ 
#set-variable	= bdb_cache_size=4M\\ 
#set-variable	= bdb_max_lock=10000\\ 
\\ 
# Uncomment the following if you are using Innobase tables\\ 
#innodb_data_file_path = ibdata1:400M\\ 
#innodb_data_home_dir = c:\ibdata\\ 
#innodb_log_group_home_dir = c:\iblogs\\ 
#innodb_log_arch_dir = c:\iblogs\\ 
#set-variable = innodb_mirrored_log_groups=1\\ 
#set-variable = innodb_log_files_in_group=3\\ 
#set-variable = innodb_log_file_size=5M\\ 
#set-variable = innodb_log_buffer_size=8M\\ 
#innodb_flush_log_at_trx_commit=1\\ 
#innodb_log_archive=0\\ 
#set-variable = innodb_buffer_pool_size=16M\\ 
#set-variable = innodb_additional_mem_pool_size=2M\\ 
#set-variable = innodb_file_io_threads=4\\ 
#set-variable = innodb_lock_wait_timeout=50\\ 
\\ 
# Enter a name for the binary log. Otherwise a default name will be used.\\ 
# log-bin=BigApache_MySql_Bin_Log\\ 
\\
Abschalten der Logs mit: \\
**[mysqld]\\ 
skip-log-bin ** \\
# Oder, damit die Logs nicht zu viel werden: \\
# Begrenzen auf 7 Tage: \\
**expire_logs_days = 7** \\ 
\\ 
# Enter a name for the error log file. Otherwise a default name will be used.\\ 
# log-error = BigApache_MySql_Error_log\\ 
\\ 
\\ 
# Enter a name for the slow query log. Otherwise a default name will be used.\\ 
# log-slow-queries = BigApache_MySql_Slow_log\\ 
\\ 
\\ 
[mysqldump]\\ 
quick\\ 
set-variable = max_allowed_packet=16M\\ 
\\ 
[mysql]\\ 
no-auto-rehash\\ 
# Remove the next comment character if you are not familiar with SQL\\ 
#safe-updates\\ 
\\ 
[isamchk]\\ 
set-variable	= key_buffer=20M\\ 
set-variable	= sort_buffer=20M\\ 
set-variable	= read_buffer=2M\\ 
set-variable	= write_buffer=2M\\ 
\\ 
[myisamchk]\\ 
set-variable	= key_buffer=20M\\ 
set-variable	= sort_buffer=20M\\ 
set-variable	= read_buffer=2M\\ 
set-variable	= write_buffer=2M\\ 
\\ 
[mysqlhotcopy]\\ 
interactive-timeout\\ 
\\ 
[WinMySQLAdmin]\\ 
Server=C:/com2sap/mysql/bin/mysqld-nt.exe\\ 
\\ 
\\