my.ini check

[Gabriel Badan]

Hello Everyone!

I am using the 5.5 version of mysql on windows platform 2012.
My server is the Intel® Xeon® E3-1230V3 3.3GHz HT and has 16GB of RAM.

In times of many hits, mysql is very slow. One could analyze my my.ini to see if everything is ok ? I only use INNODB .

Thank you,

Gabriel




[client]

port=3306

[mysql]

default-character-set=utf8

[mysqld]

port=3307

basedir="C:/Program Files/MySQL/MySQL Server 5.5/"
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"
character-set-server=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
skip-name-resolve
event_scheduler=ON

#*** LOG QUERY PROBLEM ***
log-queries-not-using-indexes
log_output = "TABLE"
slow_query_log = "OFF"
min_examined_row_limit=502
long_query_time=3

max_connections=200
query_cache_size=256M
table_cache=8000
tmp_table_size=256M
thread_cache_size=50

#*** MyISAM Specific options
key_buffer_size=128M
read_buffer_size=1M
read_rnd_buffer_size=1M
sort_buffer_size=1M

#*** INNODB Specific options ***
innodb_additional_mem_pool_size=4M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=2048M
innodb_log_file_size=343M
innodb_thread_concurrency=18