我网站数据库比较大，看了好多文章，还是不会配置 。请高手帮下忙 刚学Linux 不要BS我 :lol:
CPU：Intel(R) Pentium(R) Dual CPU E2180 @ 2.00GHz
内存 ：2G
my.cnf
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 300M
max_allowed_packet = 2M
table_cache = 1024
sort_buffer_size = 16M
net_buffer_length = 8K
read_buffer_size = 4M
read_rnd_buffer_size = 1024K
myisam_sort_buffer_size = 128M
set-variable = max_connections=1024
record_buffer = 16M
interactive_timeout=100
join_buffer_size=1M
max_connect_errors=10
table_cache=1024
thread_cache_size=100
thread_concurrency=4
wait_timeout=300
query_cache_size=32M
query_cache_limit=1M
query_cache_type=1
log-bin=mysql-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
httpd.cnf
ServerTokens OS
ServerRoot "/etc/httpd"
PidFile run/httpd.pid
Timeout 120
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
StartServers 5
MinSpareServers 5
MaxSpareServers 10
ServerLimit 2000
MaxClients 180
MaxRequestsPerChild 8000
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0