MySQL Tunning Paramenters

Mysql-Tunning

innodb_flush_log_at_trx_commit=1 ## disco ssd

Datadir

-innodb_log_group_home_dir # path innodb redo log files
-innodb_undo_directory     # path innodb undo tablespaces
-log_bin                   # path binary log
-log_error                 # path log error
-innodb_buffer_pool_size   # innodb workloads
  * host memory based
  * subtract required memory from mysql

-key_buffer_size               # to MyIsam worloads
-innodb_buffer_pool_instances  # <= 1G  : 1 instace
                               # <= 16G : 8 instace
			       #  > 16G : 2g per instace
							   
-innodb_log_file_size          # Innodb Redo Log
-innodb_log_file_in_group

#Total = innodb_log_file_size * innodb_log_file_size

-innodb_undo_tablespaces

max_connections               # too big needs more memory
table_definition_cache        # > 4000
table_open_cache              # tables can be opened more than once
table_open_cache_instances    # 16 is greate value

query_cache_type              # 0 is best to use