Mysql and server load and crashing
I have a problem in Mysql server
I have more than 6 forums
one have big database 650 MB
so when any one make optimize for any databse in the server the load will be grow and grow and grow then the server crash and stop responding for anything ( httpd - ssh ) and I must reboot it to work
I asked DC for make tset for ram
They told me that no error in this ram
My server is
Intel 3200 HT
1 GB ram
--------------------
my.cnf
[mysqld]
port=3306
socket=/tmp/mysql.sock
set-variable = max_connections=500
safe-show-database
skip-locking
max_connections=300
connect_timeout=15
key_buffer=32M
join_buffer=1M
record_buffer=1M
sort_buffer=2M
table_cache=1028
thread_cache_size=286
max_allowed_packet=16M
wait_timeout=15
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
thread_concurrency=2
-----------------------------------------
hhtpd.conf
Timeout 15
KeepAlive Off
KeepAliveTimeout 5
MinSpareServers 15
MaxSpareServers 20
------------------------------------------
Mod_dosevasive is installed with apache
php version 3.4.11
Mysql version : 4.0.24-standard
kernel 2.4.21-27.0.2.EL #1
mysqladmin status
Uptime: 113 Threads: 1 Questions: 1029 Slow queries: 0 Opens: 93 Flush tables: 1 Open tables: 87 Queries per second avg: 9.106
# free -m
total used free shared buffers cached
Mem: 1001 875 126 0 58 686
-/+ buffers/cache: 130 871
Swap: 1027 47 980
---------------------
now the problem is not appear But it will appear after 3 or 4 hours after reboot serevr when visior go with mysql more
and the server will be slow and slow
and if any one make optimize for his mysql the server is stop responding
How I can solve this
