my.cnf

   

# Example mysql config file for large systems.
#
#  his is for large system with memory = 512M where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /database) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The following options will be passed to all MySQL clients
[client]
#password             = your_password
port                  = 3306
socket                = /tmp/mysql.sock
default-character-set = utf8

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-external-locking
default-storage_engine  = MYISAM
# das gibt anscheinend viel bessere performance. default ist 0
# ev. muss man ganze zahl reinschreiben 1024*1024*64
query_cache_size=64M
#
# utf-8 codierung by default / teslina
character-set-server    = utf8
collation-server        = utf8_general_ci
#
key_buffer=256M
#key_buffer=512K
# mal versuchen - bei beiden ist default 16M
tmp_table_size=64M
max_heap_table_size=32M
#
max_allowed_packet=16M
#
table_cache=256
#table_cache=32
#
sort_buffer=1M
#sort_buffer=100K
#
# read_rnd_buffer ist neu
read_rnd_buffer=1M
#
read_buffer_size        = 1M
myisam_sort_buffer_size = 64M
thread_cache            = 8
max_connections         = 1024
wait_timeout=600
# Try number of CPU's*2 for thread_concurrency
# wir haben ja "8" cpus... 2x4 quad
thread_concurrency=16
#log-bin
#log-bin = /var/log/mysql/mysql-bin.log
#expire_logs_days=2
#server-id       = 1
#log
log-error = /var/log/mysql/mysql-startup.log
#
# langsame queries loggen, die länger als 3 sekunden dauern
slow-query-log          = 1
slow-query-log-file     = /var/log/mysql/mysql-slow-queries.log
long_query_time         = 2
#
#
# Uncomment the following if you are using BDB tables
#bdb_cache_size=64M
#bdb_max_lock=100000

# Uncomment the following if you are using Innobase tables
# --------------------------------------
# Referenz unter http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html
# Wegen der Performance hab ich gefunden:
# I would rather tweak
#
# innodb_buffer_pool_size
# innodb_log_file_size
# innodb_flush_log_at_trx_commit
#
# to improve performance.
# --------------------------------------
# http://dev.mysql.com/doc/refman/5.5/en/innodb-configuration.html
#
# wenn man innodb_data_file_path aendert, kann es zu dem corrupt error kommen...
#innodb_data_file_path = ibdata1:1000M
# ich mache 2 files, somit könnten wir mal irgendwann ibdata2 auf eine andere
# partition auslagern? freebsd hat kein filesize limit. kann man mit ulimit -a herausfinden.
innodb_data_file_path=ibdata1:1G;ibdata2:50M:autoextend
# 70-80% of memory is a safe bet. I set it to 12G on 16GB box.
# setting buffer pool a bit larger than your (innodb) database size will be enough.
# You need buffer pool a bit (say 10%) larger than your data (total size of Innodb TableSpaces)
# wir haben ja eigentlich noch extrem wenige innodb tables.
# ich erhöhe jetzt mal von 400M auf 500M - aktuelle
# Innodb_buffer_pool_reads ist 1050 bei 400M - schauen, ob es besser wird jetzt.
innodb_buffer_pool_size=500M
innodb_log_file_size=256M
# 4M is good for most cases unless you're piping large blobs to Innodb in this case increase it a bit.
# mysql schlägt eigentlich 8M vor.
innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=2
innodb_thread_concurrency=8
# vielleicht besser nicht, da wir ja ein raid haben, welches einfach so datenverlust haben könnte...
#innodb_flush_method=O_DIRECT
innodb_file_per_table
## das gibt bei mir die jensten fehler...
## ERROR 1665 (HY000) at line 818: Cannot execute statement: impossible to write to binary log
## since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging
##transaction-isolation=READ-COMMITTED
#innodb_mirrored_log_groups=1
#innodb_log_files_in_group=3
# default ist 5MB - max 4GB
# optimal ca. 25% von innodb_buffer_pool_size
##innodb_log_file_size=100M
#innodb_log_file_size=256M
# default ist 1MB
#innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#sync_binlog=1
#innodb_log_archive=0
# default ist 8MB
# you may set this to up to 80% of the machine physical memory size
# das wären 3GB! machen wir doch 1gb davon...
##innodb_buffer_pool_size=400M
#innodb_buffer_pool_size=1G
# default ist 1MB
#innodb_additional_mem_pool_size=2M
#innodb_file_io_threads=4
#innodb_lock_wait_timeout=50

# Point the following paths to different dedicated disks
#tmpdir         = /tmp/
#log-update     = /path-to-dedicated-directory/hostname

[mysqldump]
quick
max_allowed_packet=16M


no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=2M
#read_buffer=100K
write_buffer=2M

[myisamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=2M
#read_buffer=100K
write_buffer=2M

[mysqlhotcopy]
interactive-timeout
  • *

    Du kannst diese HTML tags verwenden: <a> <abbr> <acronym> <b> <blockquote> <cite> <code> <del> <em> <i> <q> <s> <strike> <strong>

  • Kommentar-Feed für diesen Beitrag
nach oben