meine sieht so aus:
- Code: Select all
[client]
#password = your_password
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
[mysqld]
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-locking
set-variable = key_buffer=128M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=15M
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
set-variable = max_connections=3500
set-variable = thread_cache_size=100
set-variable = thread_concurrency=2
set-variable = query_cache_size=128M
set-variable = query_cache_limit=1M
set-variable = query_cache_type=1
set-variable = read_buffer_size=2M
set-variable = read_rnd_buffer_size=2M
set-variable = join_buffer_size=1M
set-variable = connect_timeout=15
set-variable = interactive_timeout=100
set-variable = wait_timeout=300
server-id = 1
tmpdir = /tmp/ramtmp/
skip-innodb
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout