NEW - my.cnf — Legacy Forums — Strolen's Citadel

NEW - my.cnf

#1

etc/my.cnf

port = 3306
socket = /var/lib/mysql/mysql.sock
local-infile=0
skip-locking
skip-bdb
skip-innodb
skip-ndbcluster
safe-show-database
log-queries-not-using-indexes
log-slow-queries
long_query_time = 5

max_connections = 200
open_files_limit = 1500

key_buffer_size = 16M
myisam_sort_buffer_size = 20M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M

table_cache = 600
thread_cache_size = 8
interactive_timeout = 20
wait_timeout = 20
connect_timeout = 15
thread_concurrency = 4

max_allowed_packet = 16M
max_connect_errors = 10

query_cache_limit = 1M
query_cache_size = 20M
query_cache_type = 1

tmp_table_size = 20M

[mysqld_safe]
open_files_limit = 8192

quick
max_allowed_packet = 16M

no-auto-rehash

key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 2M
write_buffer = 2M

key_buffer = 32M
sort_buffer = 32M
read_buffer = 2M
write_buffer = 2M

old_passwords = 1

==================

/etc/httpd/conf/extra/httpd-mpm.conf

# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves

StartServers 2
MinSpareServers 2
MaxSpareServers 8
MaxClients 50
MaxRequestsPerChild 5000

/etc/httpd/conf/extra/httpd-default.conf

#
# Timeout: The number of seconds before receives and sends time out.
#
Timeout 10

#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On

#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 80

#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 2

[root@host ~]# cat /proc/user_beancounters
Version: 2.5
   uid resource    held maxheld barrier limit failcnt
   627: kmemsize 7249467 7348513   27439000   29939000 987
lockedpages    0 0    3686    4096 0
privvmpages    66319 67783    480000    537600 0
shmpages    8974    8974    249600    249600 0
dummy    0 0 0 0 0
numproc 87    87 400 400 0
physpages    15336 15519 0 2147483647 0
vmguarpages    0 0    192000 2147483647 0
oomguarpages 15336 15519    256000 2147483647 0
numtcpsock    19    21 700 700 0
numflock 3 3 250 270 0
numpty 1 1    16    16 0
numsiginfo 0 1 512 512 0
tcpsndbuf 169936    205712 9600000   19200000 0
tcprcvbuf 311296    327680 9600000   19200000 0
othersockbuf    315276    324560 4320000 7138560 0
dgramrcvbuf    0    8380 3456000 3840000 0
numothersock 167 171 700 700 0
dcachesize    536579    547181 3584000 3689000 0
numfile 2732    2759    8192    8192 0
dummy    0 0 0 0 0
dummy    0 0 0 0 0
dummy    0 0 0 0 0
numiptent 10    10    3000    3000 0

Re: NEW - my.cnf

#2

This is from new server in April 09 original

my.conf

port = 3306
socket = /var/lib/mysql/mysql.sock
local-infile=0
skip-locking
skip-bdb
skip-innodb
skip-ndbcluster
safe-show-database
log-queries-not-using-indexes
log-slow-queries
long_query_time = 5

max_connections = 200
open_files_limit = 1500

key_buffer_size = 16M
myisam_sort_buffer_size = 20M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M

table_cache = 600
thread_cache_size = 8
interactive_timeout = 20
wait_timeout = 20
connect_timeout = 15
thread_concurrency = 4

max_allowed_packet = 16M
max_connect_errors = 10

query_cache_limit = 1M
query_cache_size = 20M
query_cache_type = 1

tmp_table_size = 20M

[mysqld_safe]
open_files_limit = 8192

quick
max_allowed_packet = 16M

no-auto-rehash

key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 2M
write_buffer = 2M

key_buffer = 32M
sort_buffer = 32M
read_buffer = 2M
write_buffer = 2M

old_passwords = 1

Re: NEW - my.cnf

#3

uid resource held maxheld barrier limit failcnt
627: kmemsize 11905739 12033908 27439000 29939000 0
lockedpages 1 1 3686 4096 0
privvmpages 81386 83927 480000 537600 0
shmpages 4878 4878 249600 249600 0
dummy 0 0 9223372036854775807 9223372036854775807 0
numproc 93 94 400 400 0
physpages 42401 44713 0 2147483647 0
vmguarpages 0 0 192000 2147483647 0
oomguarpages 43106 45418 9223372036854775807 2147483647 0
numtcpsock 26 26 700 700 14145618522
numflock 3 4 250 270 0
numpty 1 1 16 16 0
numsiginfo 0 1 512 512 0
tcpsndbuf 635088 617616 9600000 19200000 0
tcprcvbuf 425984 393216 9600000 19200000 0
othersockbuf 346432 381040 4320000 7138560 0
dgramrcvbuf 0 8464 3456000 3840000 0
numothersock 175 179 700 700 0
dcachesize 2368718 2399705 3584000 3689000 0
numfile 4630 4703 8192 8192 555
dummy 0 0 0 0 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
numiptent 14 14 3000 3000 0