forum.lissyara.su

Код: Выделить всё

# mfiutil show volumes
mfi0 Volumes:
  Id     Size    Level   Stripe  State   Cache   Name
 mfid0 (  278G) RAID-1      64k OPTIMAL Enabled  <os>
 mfid1 (  557G) RAID-1      64k OPTIMAL Reads    <data>

/boot/loader.conf:
zfs_load="YES"
vfs.zfs.arc_max=8G
vfs.zfs.vdev.max_pending=32
vfs.zfs.txg.timeout="5"
kern.ipc.nsfbufs=131072
net.inet.tcp.tcbhashsize=4096
net.inet.tcp.syncache.hashsize=1024
net.inet.tcp.syncache.bucketlimit=100
net.inet.tcp.hostcache.hashsize=16384
net.inet.tcp.hostcache.bucketlimit=100
net.inet.tcp.hostcache.cachelimit=30720

/etc/sysctl.conf:
security.bsd.see_other_uids=0
kern.ipc.shm_use_phys=1
net.inet.tcp.delayed_ack=0
net.inet.tcp.drop_synfin=1
net.inet.tcp.blackhole=2
net.inet.udp.blackhole=1
kern.maxvnodes=3000000
kern.maxfiles=524288
kern.maxfilesperproc=131072
kern.ipc.nmbjumbop=102400
kern.ipc.maxsockets=819200
kern.ipc.somaxconn=8192
kern.ipc.nmbclusters=524288
net.inet.icmp.icmplim=3000
net.inet.tcp.recvspace=1048576
net.inet.tcp.sendspace=1048576
net.inet.tcp.nolocaltimewait=0
net.inet.ip.portrange.randomized=0
net.inet.ip.portrange.first=1024
net.inet.ip.intr_queue_maxlen=4096
vfs.ufs.dirhash_maxmem=534689280
net.inet.tcp.maxtcptw=163840
net.inet.tcp.hostcache.expire=900
net.inet.sctp.pcbhashsize=1024
net.inet.flowtable.enable=0
vm.pmap.shpgperproc=400
vm.pmap.pv_entry_max=23655032
kern.ipc.maxsockbuf=67108864
net.inet.tcp.sendbuf_max=67108864
net.inet.tcp.slowstart_flightsize=32
net.inet.tcp.mssdflt=1460

Код: Выделить всё

worker_processes 16;
worker_priority -10;
worker_rlimit_nofile 16384;
timer_resolution 100ms;

events {
  worker_connections 8196;
  use kqueue;
}

http {
  server_names_hash_bucket_size 128;
  sendfile on;
  tcp_nodelay on;
  tcp_nopush on;
  aio sendfile;
  read_ahead 128k;
  gzip off;
  proxy_buffering off;
  server_tokens off;
  ignore_invalid_headers on;
  reset_timedout_connection on;

Код: Выделить всё

my.cnf:
[mysqld]
skip-external-locking
skip-name-resolve
max_connect_errors=2048
max_connections=2048
key_buffer_size=512M
join_buffer_size=1024M
tmp_table_size=2048M
max_heap_table_size=4096M
sort_buffer_size=256M
myisam_sort_buffer_size=128M
table_cache=32768
max_allowed_packet=4M
query_cache_size=128M
query_prealloc_size=256M
query_cache_limit=32M
read_rnd_buffer_size=128M
read_buffer_size=512K
long_query_time=10
thread_cache_size=128
thread_cache=128
thread_concurrency=8
bind-address=127.0.0.1
wait_timeout=14400
log-queries-not-using-indexes=true
log-slow-queries=/usr/home/mysql/log-slow-queries.log