[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
#old_passwords = 1
skip-external-locking
skip-locking

#### tuning ####

## Verbindung
max_connections = 350

## Queries
query_cache_limit = 2M
query_cache_size = 256M

## Buffer
key_buffer = 192M
sort_buffer = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M

## Sonstiges
#thread_cache_size = 256
#max_allowed_packet = 2M
table_cache = 2048
tmp_table_size = 256M

#### std. ####

#thread_concurrency =4
concurrent_insert = 2
myisam_sort_buffer_size = 64M

innodb_buffer_pool_size = 2048M
#innodb_log_file_size = 256M//tabellen kaputt
innodb_log_buffer_size=4M
#innodb_flush_logs_at_trx_commit=2//erzeugt fehler
innodb_thread_concurrency=8
innodb_flush_method=O_DIRECT
#transaction-isolation=READ-COMITTED//erzeugt fehler


#low_priority_updates = 1 
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2

#log = /var/log/mysql/mysql.log
#log_bin = /var/log/mysql/mysql_bin.log

skip-bdb

#[isamchk]
#key_buffer = 256M

#[mysql.server]
#user=mysql
#basedir=/var/lib

#[mysqld_safe]
#err-log=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid