BiTel

# grep -vE '^(#|$)' /usr/local/etc/my.cnf
[mysqld]
skip-external-locking   # Do not use external locking (system locking). This affects only MyISAM table access.
skip-name-resolve       # Do not resolve hostnames when checking client connections. Use only IP numbers.
default-storage-engine = InnoDB
log-bin          = mysql-bin
max_binlog_size  = 100M
expire_logs_days = 1
server-id = 1
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
max_connections = 3000
key_buffer_size         = 256M
max_allowed_packet      = 50M
myisam_sort_buffer_size = 64M
query_cache_size        = 16M
read_buffer_size        = 1M
read_rnd_buffer_size    = 4M
sort_buffer_size        = 1M
table_open_cache        = 256
thread_cache_size       = 8
innodb_data_file_path = ibdata1:100M:autoextend
innodb_buffer_pool_size         = 4G
innodb_additional_mem_pool_size = 20M
innodb_log_file_size            = 1G
innodb_log_buffer_size          = 8M
innodb_flush_log_at_trx_commit  = 2
innodb_lock_wait_timeout        = 50
innodb_file_per_table
innodb_flush_method = O_DIRECT
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size  = 128M
sort_buffer_size = 128M
read_buffer      = 2M
write_buffer     = 2M
[mysqlhotcopy]
interactive-timeout

# top -b | grep -E 'PID|mysql' | awk '{print $3"\t"$4"\t"$5"\t"$6}'
THR     PRI     NICE    SIZE
51      44      0       5111M

BGBillingServer v 5.1 build 690 from 11.07.2011 18:42:40
Started: 01.10.2011 13:05:33    Uptime: 0 d 00:44:33
Memory total: 145 948 672; max: 3 817 799 680; free: 22 010 352
Memory pools:
Non-heap memory[Code Cache]: max: 50 331 648; used: 12 126 080; peek: 12 136 512
Heap memory[PS Eden Space]: max: 1 421 869 056; used: 7 232 176; peek: 65 929 216
Heap memory[PS Survivor Space]: max: 4 653 056; used: 4 021 520; peek: 15 641 064
Heap memory[PS Old Gen]: max: 2 863 333 376; used: 112 687 560; peek: 173 648 720
Non-heap memory[PS Perm Gen]: max: 85 983 232; used: 53 190 216; peek: 53 233 392
Thread count: 40
Connections pool to Master status Idle: 15; Active: 0; maxActive: 10000; maxIdle: 1000