my.ini File for Large Size in MySql

 

The my.ini file varies according to the size of the cube that you publish.

Use the following parameters for the my.ini file for large size cubes.

#

# This is for a system with large memory (4GB - 8GB)

# Use this file to configure MYSQL on the Application server.

## LARGE SIZE CUBE my.ini ####

# The default location for my.ini is /etc/my.ini to set global options.

# Put the my.ini file in the installation root directory for installation specific settings.

# Or in the installation folder~/.my.ini to set user-specific options.

# The following options will be passed to all MySQL clients

[client]

#password = your_password

port = 3306

socket = C:/opt/emptoris/tools/MySQL-5.5.41/tmp/mysql.sock

character-set-server=utf8

collation-server=utf8_general_ci

lower_case_table_names=1

# Here follows entries for some specific programs

# The MySQL server

[mysqld]

bind-address     = ::

port = 3306

socket = C:/opt/emptoris/tools/MySQL-5.5.41/tmp/mysql.sock

#skip-locking

key_buffer=2048M

key_buffer_size=2048M

key_cache_block_size=1024

max_allowed_packet =256M

table_cache = 512

table_open_cache=512

sort_buffer_size =4096M

net_buffer_length = 16M

read_buffer_size=512M

read_rnd_buffer_size=512M

query_cache_size=4096M

query_cache_limit=4M

max_heap_table_size=1536M

tmp_table_size=1536M

myisam_sort_buffer_size=512M

myisam_max_sort_file_size=512M

#myisam_max_extra_sort_file_size=768M

thread_cache_size=8

thread_concurrency=8

max_connections=350

character-set-server=utf8

collation-server=utf8_general_ci

lower_case_table_names=1

sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO"

default-storage-engine=MyISAM

# Replication Master Server (default)

# binary logging is required for replication

log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1

# defaults to 1 if master-host is not set

# but will not function as a master if omitted

server-id = 1

# Point the following paths to different dedicated disks

tmpdir =/cust/tmp/

# Uncomment the following if you are using InnoDB tables

innodb_data_home_dir = C:/opt/emptoris/tools/MySQL-5.5.41/data/

innodb_data_file_path = ibdata1:512M:autoextend

innodb_log_group_home_dir = C:/opt/emptoris/tools/MySQL-5.5.41/data/

#innodb_log_arch_dir = /cust/apps/mysql/data/

# You can set .._buffer_pool_size up to 50 - 80 %

# of RAM but beware of setting memory usage too high

innodb_buffer_pool_size = 32M

innodb_additional_mem_pool_size = 16M

# Set .._log_file_size to 25 % of buffer pool size

innodb_log_file_size = 5M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

# binlog_format added for mysql version 5.1.34. bugzilla pr no. 76015

binlog_format=mixed

[mysqldump]

quick

max_allowed_packet = 32M

[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates

[isamchk]

key_buffer = 1024M

sort_buffer_size = 256M

read_buffer = 8M

write_buffer = 16M

[myisamchk]

key_buffer = 1024M

sort_buffer_size = 256M

read_buffer = 8M

write_buffer = 8M

[mysqlhotcopy]

interactive-timeout

#default-storage-engine=MyISAM