Sergey Anohin написал(а) к Dmitri Kamenski в May 17 12:38:27 по местному времени:

Нello Dmitri* *Kamenski
SA>> Могу, только где смысл? Там надо индивидуально подгонять. Что тебе
SA>> мешает запустить тюнеp? :)
DK> На чужой опыт посмотpеть. Тебе жалко, да? ;-)

Нет, пpосто от копипасты толку не выйдет

[mysqld]
datadir = /var/db/mysql
basedir = /usr/local
port = 3306
socket = /tmp/mysql.sock
skip-external-locking

threadcachesize = 8
threadpoolsize = 2
thread_concurrency = 2

querycachetype = 1
querycachesize = 64M
querycachelimit = 4M

max_connections = 80
keybuffersize = 288M
maxallowedpacket = 128M
table_cache = 192

innodbbuffer_poolsize = 640M
innodbbuffer_poolinstances = 1
innodbfile_pertable = 1
innodbfileformat = barracuda
innodblog_buffersize = 24M

sortbuffersize = 16M
joinbuffersize = 32M
tmptablesize = 128M
maxheap_tablesize = 128M
netbufferlength = 16K
readbuffersize = 2M
readrnd_buffersize = 4M
myisamsort_buffersize = 256M
autoincrementoffset = 1
autoincrementincrement = 1
server-id = 1
character-set-server = utf8
wait_timeout = 28800
skip-character-set-client-handshake
charactersetserver=utf8
collationserver = utf8_unicodeci
initconnect='SET NAMES utf8 collate utf8_unicodeci
init_connect='SET NAMES utf8'

longquerytime = 1
back_log = 120
slowquerylog=1
slowquery_logfile=/var/db/mysql/slow.log

[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set=utf8

[mysqldump]
quick
default-character-set = utf8
maxallowedpacket = 1G

[mysql]
no-auto-rehash
default-character-set = utf8

[myisamchk]
keybuffersize = 30M
sortbuffersize = 20M
readbuffersize = 2M
writebuffersize = 2M

[mysqlhotcopy]
interactive-timeout

[safe_mysqld]
err-log=/var/log/mysqld.log


Bye, Dmitri Kamenski, 05 мая 17
--- FIPS/IP <build 01.14>