Horrible Control?

[Hitakashi]

[/code]We are using a VPS with 1.13 GB's of ram, And SMF has a really had time not over loading the Mysql. What should i do to make it not crash our servers? Should i change the convert the tables to InnoDB? We have about 1,247,670 Posts in 75,858 Topics by 7,591 Members. Should we start converting some tables to InnoDB?

Here's our status page thing: http://warriorcatsrpg.com/status.php

Code Select Expand

[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
safe-show-database
interactive_timeout=10
record_buffer=1M
thread_concurrency=16
collation-server=latin1_general_ci
back_log = 75
skip-innodb
max_connections = 300
key_buffer = 384M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 400
thread_cache_size = 384
wait_timeout = 7200
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 1000
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size =128M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
default-storage-engine = MyISAM

[safe_mysqld]
nice = -5
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M


Thats out My.cnf should i remove some stuff or make some settings higher or what?

[Joshua Dickerson]

Twenty-four things you can do to make SMF go faster (Updated June 16th, 2010)