[client]

#ssl-key=C:/OpenSSL/bin/client-key.pem
#ssl-cert=C:/OpenSSL/bin/client-cert.pem
#ssl-ca=C:/OpenSSL/bin/ca-cert.pem

#password	= [your_password]
port		= 3306
socket		= /tmp/mysql.sock

[mysqld]
ssl-key=C:/OpenSSL/bin/server-key.pem
ssl-cert=C:/OpenSSL/bin/server-cert.pem
ssl-ca=C:/OpenSSL/bin/ca-cert.pem

datadir="D:/MySQLData/mysql"


# generic configuration options
port		= 3306
socket		= /tmp/mysql.sock

#Custome Parameters section
skip-show-database
default-character-set=utf8
character_set_server=utf8
max_connections=10000 #for start. 
max_allowed_packet = 64M # important for creating new sample project. by default 64M
max_heap_table_size = 1024M # we can use really big tables such type increased from 64M to 1024M
query_cache_size=320M # check that cash is really used and increase cash size.
default-storage-engine=INNODB
tmp_table_size=300M #It is not clear what temp table we will have. 
key_buffer_size=200M # For indexed of temmporary tables. This affect only on MyIsam.  default 32M
innodb_additional_mem_pool_size=30M # 20M is enough doesn't affect on Performace
innodb_buffer_pool_size=5000M #70-80 % of All memory but se increese memory to 12000 when Database size grows. 
innodb_thread_concurrency=8 # optimal for start default 16
innodb_flush_log_at_trx_commit=2 # write transaction log from OS cash. 
innodb_log_buffer_size=8M # Log size affect on transactions shouldn't be big. Default 8
innodb_log_file_size=256M # important for writing data it is not our case we ussually read. default 256M
#innodb_flush_method=O_DIRECT 
table_cache=1024 # for cashed tables. 
thread_cache = 16 # optimal value
max_connect_errors = 1000 # default 10 but in other case Cloud server is blocked. 
max_prepared_stmt_count=100


#Default Parameters
back_log = 50

table_open_cache = 2048 # doesn't affect on InnoDB
binlog_cache_size = 1M
sort_buffer_size = 8M
join_buffer_size = 8M
thread_cache_size = 8
thread_concurrency = 8
query_cache_limit = 2M
thread_stack = 192K
transaction_isolation = REPEATABLE-READ
log-bin=e:/MySQLBinLog/binlog
binlog_format=mixed
slow_query_log
long_query_time = 2
#tmpdir = /tmp
server-id = 1

#*** MyISAM Specific options
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover

# *** INNODB Specific options ***
innodb_data_home_dir=
innodb_data_file_path = D:/MySQLData/ibdata1:10M:autoextend
innodb_file_io_threads = 4
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120


[mysqldump]
# Do not buffer the whole result set in memory before writing it to
# file. Required for dumping very large tables
quick

max_allowed_packet = 64M

[mysql]
no-auto-rehash
default-character-set=utf8

# Only allow UPDATEs and DELETEs that use keys.
#safe-updates

[myisamchk]
key_buffer_size = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
# Increase the amount of open files allowed per process. Warning: Make
# sure you have set the global system limit high enough! The high value
# is required for a large number of opened tables
open-files-limit = 8192