Mysql 5.6.10 parameters (verification) my. there are two INI files that must be changed: Cancel table_cache and log-slow-queries = slow. log must be changed to slow-query-log-file = slow. log [mysqld] port = 3306 available basedir = D:/wamp/mysql available datadir = D:/wamp/mysql/data/available tmpdir = D: /wamp/tmp/replace character-set-server = utf8 with character-set-server. It seems that table_cache = 2048 has been canceled, if it is added, wait_timeout = 30 available interactive_timeout = 30 available skip-name-resolve available bind-address = 0.0.0.0 available innodb_file_per_table = 1 available innodb_open_files = 2048 available back_log = 500 available max_connections = 1000 available bytes = 100 available table_open_cache = 2048 available bytes = 32 m available bytes = 1 m available bytes = 256M available read_buffer_size = 16 m available bytes = 16 m available sort_buffer_size = 16 m available bytes = 32 m available thread_cache_size = 64 available thread_concurrency = 4 available query_cache_size = 256M available bytes = 8 m available bytes = 4 available # memlock default-storage-engine = Innodb available thread_stack = 192K available transaction_isolation = REPEATABLE-READ available tmp_table_size = 256M available max_tmp_tables = 512 is available # Enable binary logging. this is required for acting as a MASTER in a # replication configuration. you also need the binary log if you need # the ability to do point in time recovery from your latest backup. # log-bin = mysql-bin # binary logging format-mixed recommended # binlog_format = mixed # If you're using replication with chained slaves (A-> B-> C ), you need to # enable this option on server B. it enables logging of updates done by # the slave thread into the slave's binary log. # log_slave_updates # Enable the full query log. every query (even ones with incorrect # syntax) that the server will be logged. this is useful for # debugging, it is usually disabled in production use. # log # Print warnings to the error log file. if you have any problem with # MySQL you shocould enable logging of warnings and examine the error log # for possible explanations. # log_warnings # Log slow queries. slow queries are queries which take more than the # amount of time defined in "long_query_time" or which do not use # indexes well, if log_short_format is not enabled. it is normally good idea # to have this turned on if you frequently add new queries to the # system. slow-query-log = 1 available # All queries taking more than this amount of time (in seconds) will be # trated as slow. do not use "1" as a value here, as this will result in # even very fast queries being logged from time to time (as MySQL # currently measures time with second accuracy only ). long_query_time = 5 available slow-query-log-file = slow. log change # log-queries-not-using-indexes # *** Replication related settings # Unique server identification number between 1 and 2 ^ 32-1. this value # is required for both master and slave hosts. it ults to 1 if # "master-host" is not set, but will MySQL will not function as a master # if it is omitted. server-id = 1 available # Replication Slave (comment out master section to use this) # To configure this host as a replication slave, you can choose between # two methods: #1) Use the change master to command (fully described in our manual)-# the syntax is: # change master to MASTER_HOST =