Performance tuning - Innodb

[vishwas samant]

As per my experience, If you tune following mysql parameters then you will surely enjoy better performance. Please adjust values as per server resources.

[mysqld]
skip-locking

#####For Innodb#########
set-variable = innodb
set-variable = innodb_autoextend_increment=100M
set-variable = innodb_buffer_pool_size=<50% of RAM>
innodb_checksums
innodb_thread_concurrency=8
innodb_data_home_dir=innodb_data/
innodb_data_file_path=tbs_innodb_data_01:2048M;tbs_innodb_data_02:2048M;tbs_innodb_data_03:2048M;tbs_innodb_data_04:2048M;tbs_innodb_data_05:2048M;tbs_innodb_data_06:2048M;tbs_innodb_data_07:2048M;tbs_innodb_data_08:2048M;tbs_innodb_data_09:2048M;tbs_innodb_data_10:2048M;tbs_innodb_data_11:2048M;tbs_innodb_data_12:2048M;tbs_innodb_data_13:2048M;tbs_innodb_data_14:2048M;tbs_innodb_data_15:100M:autoextend:max:2048M.........
innodb_flush_log_at_trx_commit=0
set-variable = innodb_log_buffer_size=4M
set-variable = innodb_log_file_size=128M
innodb_log_group_home_dir=innodb_redo
set-variable = innodb_mirrored_log_group=1
set-variable = innodb_log_files_in_group=2
set-variable = innodb_additional_mem_pool_size=4M
set-variable = innodb_flush_method=O_DIRECT
innodb_fast_shutdown = 2
log-bin = /binlogs/
max_binlog_size=10M
server-id = 1

Cheers,
Vishwas Samant