[mysqld] datadir=/data socket=/tmp/mysql.sock user=mysql server-id=2 #have_innodb=yes log-bin=/data/bin.log core-file #log-slave-updates #log-bin-index=/var/lib/mysql/log-bin.index #relay-log = /var/lib/mysql/relay.log #relay-log-info-file = /var/lib/mysql/relay-log.info #relay-log-index = /var/lib/mysql/relay-log.index #transaction-isolation = READ-COMMITTED # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links=0 ignore-builtin-innodb #plugin-load=innodb=ha_innodb_plugin.so plugin-load=innodb=ha_innodb.so innodb_data_home_dir = /data # InnoDB innodb_data_file_path = ibdata1:20G;ibdata2:20G;ibdata3:20G;ibdata4:20G;ibdata5:20G;ibdata6:20G;ibdata7:20G;ibdata8:20G;ibdata9:20G;ibdata10:20G;ibdata11:20G;ibdata12:20G;ibdata13:20G;ibdata14:20G;ibdata15:20G;ibdata16:20G;ibdata17:20G;ibdata18:20G;ibdata19:20G;ibdata20:20G;ibdata21:20G;ibdata22:20G;ibdata23:20G;ibdata24:20G;ibdata25:20G;ibdata26:20G;ibdata27:20G;ibdata28:20G;ibdata29:20G;ibdata30:20G;ibdata31:20G;ibdata32:20G;ibdata33:20G;ibdata34:20G;ibdata35:20G;ibdata36:20G;ibdata37:20G;ibdata38:20G;ibdata39:20G;ibdata40:20G;ibdata41:20G;ibdata42:20G;ibdata43:20G;ibdata44:20G;ibdata45:20G;ibdata46:20G;ibdata47:20G;ibdata48:20G;ibdata49:20G;ibdata50:20G;ibdata51:20G;ibdata52:20G;ibdata53:20G;ibdata54:20G;ibdata55:20G;ibdata56:20G;ibdata57:20G;ibdata58:20G;ibdata59:20G;ibdata60:20G;ibdata61:20G;ibdata62:20G;ibdata63:20G;ibdata64:20G;ibdata65:20G;ibdata66:20G;ibdata67:20G;ibdata68:20G;ibdata69:20G;ibdata70:20G;ibdata71:20G;ibdata72:20G;ibdata73:20G;ibdata74:20G;ibdata75:20G;ibdata76:20G;ibdata77:20G;ibdata78:20G;ibdata79:20G;ibdata80:20G;ibdata81:20G;ibdata82:20G;ibdata83:20G;ibdata84:20G;ibdata85:20G;ibdata86:20G;ibdata87:20G;ibdata88:20G;ibdata89:20G # innodb_log_group_home_dir = /data #innodb_log_arch_dir = /data innodb_mirrored_log_groups=1 innodb_log_files_in_group=3 # set-variable = innodb_log_file_size=5M innodb_log_file_size=200M innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #innodb_buffer_pool_size=3683M je maksimalna mozna vrednost innodb_buffer_pool_size=50G je maksimalna mozna vrednost # set-variable = innodb_buffer_pool_size=16M innodb_additional_mem_pool_size=4M innodb_file_io_threads=4 innodb_thread_concurrency=48 innodb_lock_wait_timeout=120 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid