Tweet
Before we upgraded we were running 1.1.5 and had not problems but since our upgrade the server crashed about ever 12 -14 hours. All memory is used and all swap is used. A couple of time I have caught the server before it crashed which is where I get the resource information. This is getting a little upsetting - having to go to a noc and hard reboot a machine every day where the machines uptime is usually pretty high! Please assist in any way that you possibly can.
System Config.
Linux
Dual P3 733
1 Gig Ram
Raid 10
176 Swap
Forum Stats:
18589 Registered Members
24125 threads in total
295662 posts in total
400 Adverage On-Line Users
600 Adverage Peak On-Line Users (3pm - 1 am)
Mysql Stats/Config
Mysql v3.22.32 with Raid Support
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = join_buffer=150M
set-variable = table_cache=256
set-variable = sort_buffer=10M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=128
#set-variable = temp_table_size=4M
set-variable = thread_concurrency=8 # Try number of CPU's*2
set-variable = thread_stack=128K
log-bin
server-id = 1
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=64M
#set-variable = bdb_max_lock=100000
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates # Remove the comment character if you are not familiar with SQL
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
Threads: 18 Questions: 188841 Slow queries: 4 Opens: 229 Flush tables: 1 Open tables: 223 Queries per second avg: 78.163
(note: just after a hard reboot)
System Config.
Linux
Dual P3 733
1 Gig Ram
Raid 10
176 Swap
Forum Stats:
18589 Registered Members
24125 threads in total
295662 posts in total
400 Adverage On-Line Users
600 Adverage Peak On-Line Users (3pm - 1 am)
Mysql Stats/Config
Mysql v3.22.32 with Raid Support
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = join_buffer=150M
set-variable = table_cache=256
set-variable = sort_buffer=10M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=128
#set-variable = temp_table_size=4M
set-variable = thread_concurrency=8 # Try number of CPU's*2
set-variable = thread_stack=128K
log-bin
server-id = 1
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=64M
#set-variable = bdb_max_lock=100000
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates # Remove the comment character if you are not familiar with SQL
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
Threads: 18 Questions: 188841 Slow queries: 4 Opens: 229 Flush tables: 1 Open tables: 223 Queries per second avg: 78.163
(note: just after a hard reboot)
Comment