DRAKOS Wiki

Benutzer-Werkzeuge

Webseiten-Werkzeuge

Zuletzt angesehen:
my.ini

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Nächste Überarbeitung		Vorhergehende Überarbeitung
my.ini [2009/06/23 14:28] – angelegt agmy.ini [2020/06/24 14:33] (aktuell) – Externe Bearbeitung 127.0.0.1
Zeile 1: Zeile 1:
-# Example mysql config file. +# Example mysql config file.\\  
-# Copy this file to c:\my.cnf to set global options +# Copy this file to c:\my.cnf to set global options\\  
-#  +# \\  
-# One can use all long options that the program supports. +# One can use all long options that the program supports.\\  
-# Run the program with --help to get a list of available options +# Run the program with --help to get a list of available options\\  
- +\\  
-# This will be passed to all mysql clients +# This will be passed to all mysql clients\\  
-[client] +[client]\\  
-#password=my_password +#password=my_password\\  
-port=3306 +port=3306\\  
-#socket=MySQL +#socket=MySQL\\  
- +\\  
-# Here is entries for some specific programs +# Here is entries for some specific programs\\  
-# The following values assume you have at least 32M ram +# The following values assume you have at least 32M ram\\  
- +\\  
-# The MySQL server +# The MySQL server\\  
-[mysqld] +[mysqld]\\  
-port=3306 +port=3306\\  
-#socket=MySQL +#socket=MySQL\\  
-#(Unknown option:)skip-locking +#(Unknown option:)skip-locking\\  
-#(Unknown option:)set-variable = key_buffer=16M +#(Unknown option:)set-variable = key_buffer=16M\\  
-set-variable = max_allowed_packet=1M +set-variable = max_allowed_packet=1M\\  
-set-variable = table_cache=64 +set-variable = table_cache=64\\  
-#(Unknown option:)set-variable = sort_buffer=512K +#(Unknown option:)set-variable = sort_buffer=512K\\  
-set-variable = net_buffer_length=8K +set-variable = net_buffer_length=8K\\  
-set-variable = myisam_sort_buffer_size=8M +set-variable = myisam_sort_buffer_size=8M\\  
-server-id = 1 +server-id = 1\\  
- +\\  
-# Uncomment the following if you want to log updates +# Uncomment the following if you want to log updates\\  
-#log-bin +# 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 +
-# 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 +
  
 +\\ 
 +# 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\\ 
 +\\ 
 +\\ 
my.ini.1245767282.txt.gz · Zuletzt geändert: 2020/06/24 14:33 (Externe Bearbeitung)