windows mysql my.ini ayarı

[MySQLD]
#Port number to use for connections.
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir=c:/Program Files/SWsoft/Plesk/Databases/MySQL/
#Path to the database root
datadir=c:/Program Files/SWsoft/Plesk/Databases/MySQL/Data/

#Set the default character set.
default-character-set=latin1
#If no specific storage engine/table type is defined in an SQL-Create statement the default type will be used.
default-storage-engine=INNODB
#Size of a memory pool InnoDB uses to store data dictionary information and other internal data structures. A sensible value for this might be 2M, but the more tables you have in your application the more you will need to allocate here. If InnoDB runs out of memory in this pool, it will start to allocate memory from the operating system, and write warning messages to the MySQL error log.
innodb_additional_mem_pool_size=32M
innodb_flush_log_at_trx_commit=1
#The size of the buffer which InnoDB uses to write log to the log files on disk. Sensible values range from 1M to 8M. A big log buffer allows large transactions to run without a need to write the log to disk until the transaction commit. Thus, if you have big transactions, making the log buffer big will save disk I/O.
innodb_log_buffer_size=4M

#The bigger you set this the less disk I/O is needed to access data in tables. On a dedicated database server you may set this parameter up to 80% of the machine physical memory size. Do not set it too large, though, because competition of the physical memory may cause paging in the operating system.
innodb_buffer_pool_size=1024M
#Size of each log file in a log group in megabytes. Sensible values range from 1M to 1/n-th of the size of the buffer pool specified below, where n is the number of log files in the group. The larger the value, the less checkpoint flush activity is needed in the buffer pool, saving disk I/O. But larger log files also mean that recovery will be slower in case of a crash. The combined size of log files must be less than 4 GB on 32-bit computers. The default is 5M.
innodb_log_file_size=10M
#Helps in performance tuning in heavily concurrent environments.
innodb_thread_concurrency=16
#The number of simultaneous clients allowed.
max_connections=2000
old_passwords=1
max_user_connections=100
#How many threads we should keep in a cache for reuse.
thread_cache_size=200


#Bu kısım pleskde ayarlı geldiği için sadece stack değerine dokundum
#Bu kısım pleskde ayarlı geldiği için sadece stack değerine dokundum
#thread_stack=196608
thread_stack=996608
binlog_cache_size=32768
net_read_timeout=30
net_retry_count=10
net_write_timeout=30
thread_concurrency=16
open_files_limit=0
#Bu kısım pleskde ayarlı geldiği için sadece stack değerine dokundum
#Bu kısım pleskde ayarlı geldiği için sadece stack değerine dokundum




#The size of the buffer used for index blocks. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford; 64M on a 256M machine that mainly runs MySQL is quite common.
key_buffer_size=1024M
#Each thread that needs to do a sort allocates a buffer of this size.
sort_buffer_size=8M
#Don't cache results that are bigger than this.
query_cache_limit=1M
#The memory allocated to store results from old queries.
query_cache_size=256M
#Query cache type to use.
query_cache_type=1
#Each thread that does a sequential scan allocates a buffer of this size for each table it scans. If you do many sequential scans, you may want to increase this value.
read_buffer_size=4M
#When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks. If not set, then it's set to the value of record_buffer.
read_rnd_buffer_size=2M
#The number of open tables for all threads.
table_cache=1520
#If an in-memory temporary table exceeds this size, MySQL will automatically convert it to an on-disk MyISAM table.
tmp_table_size=32M


#Enter a name for the error log file. Otherwise a default name will be used.
log-error=hatali_islemler.txt
#Enter a name for the slow query log. Otherwise a default name will be used.
log-slow-queries=yavasislemler.txt
#Log all queries that have taken more than long_query_time seconds to execute to file.
long_query_time=10
#Logs will be rotated after expire-log-days days
expire_logs_days=10
#Max packetlength to send/receive from to server.
max_allowed_packet=16M
[client]
port=3306