A slow crashing server
Intel Celeron 1.7 GHz, 400 MHz FSB
512 MB ECC RAM
60 GB hard drive
500 GB Monthly Transfer
This is my my.cnf file:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
safe-show-database
set-variable = max_connections=300
set-variable = key_buffer=384M
set-variable = myisam_sort_buffer_size=64MB
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=1M
set-variable = table_cache=1024
set-variable = thread_cache=8
set-variable = wait_timeout=30
set-variable = thread_concurrency=4
set-variable = connect_timeout=10
set-variable = tmp_table_size=16M
set-variable = max_allowed_packet=32M
set-variable = interactive_timeout=60
set-variable = query_cache_limit=2M
set-variable = query_cache_size=64M
set-variable = query_cache_type=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
My website (blogring.net) has 16224 registered members, but at most, only 400 are in at a time. My question is this... Even when only 100 users are online, my website sometimes goes offline and I can't even log into SSH. The whole website is only a forum, and there is also a link indexing script install that is very popular.
What could be causing these slowdowns and crashes? I thought one dedicated server would be enough, but this happens even when not many people are online.
Michael Zhang
