Anyone notice this forum running slow?

[Matthew]

I've noticed off and on for the last week or so that this forum is loading real slow...i ran a speed test on my cable modem, and its actually running higher than average...www.msn.com takes about all of 1 second to load, as do other webpages...just didnt know if anyone else was having the same problem

 

[Dimitrios]

Same here.....100BaseT at work and still sluggish....vewwy intahwesting........

 

[wannabe]

yeah....just on and off though, its actually faster at home on my dsl than at the office on the T1....

 

[Matthew]

yea like right now its flying no problem, earlier it was REALLY bad

 

[wannabe]

I post on "longest thread" a lot and the speed at which that thread moves requires a fast forum, it has been horrible, especially trying to keep the conversation flowing, it takes too long to reload, and by the time you read what others have posted, your replies are about 5 replies back, and they dont make any sense....

 

[Coqui258]

I noticed the site going slow a lot sometimes, but like mp3wannabe said, it's just on and off. Sometimes it gets me mad, cause it'll take like 2 minutes to load! I guess just spikes in the server...

 

[spazspike]

It's the forum's server. Depending upon how large the SQL database is for the forum and the machine they have it on, you'll get some slow load times. Especially if the box is used by other sites that run multimedia or other forums.

To give you an indication, I once ran a VBulletin message board that had about 8700 members and the forum database was about a gig. Unless you've got a good processor (2ghz+) and about a gig of RAM during peak hours it's going to load slow.

 

[Sir Nuke]

you guys don't have a clue what slow it....try doing all this with a 26.4 dialup connection! lol now THAT is slow! even when the board is at its peek.

btw....this doesn't belong in the P5 forum....

 

[Matthew]

sir nuke please quit moving posts all over the place...the reason we post in here is because we pretty much know everyone and people respond here...when you move posts to other less frequented forums, often you dont get any responses at all or very little compared to when they are in here...if someone wants to ask fellow p5ers what they think of their rims or whatever, lighten up and just leave it in this forum...its not killing anyone

 

[wannabe]

maybe its the moving of threads that makes this forum sooo sloow (dunno)

 

[Matthew]

lol

 

[Antoine]

This site runs a...

Dedicated Server

Intel Pentium 4 2.4 GHz
1024 MB RAM
60 GB HD
500 GB Data Transfer

should be in help/feedback forum..and moving there...

 

[enry]

Here's some info. If someone has REAL, PROVEN instructions on how to optimize for speed, I am open to suggestions.
Otherwise, spare me the short-sighted comments or half-assed remarks or I will get <b>VERY</b> upset.

The database is over 3 gigs. We have a 2.4 with a gig of ram. CPU load right now is 0.26, 0.59, 0.57.
Apache settings are:

StartServers 50
MinSpareServers 25
MaxSpareServers 50
MaxClients 300

MySQL Settings Below.

/usr/local/mysql/libexec/mysqld Ver 4.0.13 for unknown-freebsd5.0 on i386

[...]

basedir /usr/local/mysql/
bind-address (No default value)
console FALSE
chroot (No default value)
character-sets-dir /usr/local/mysql/share/mysql/charsets/
datadir /usr/local/mysql/var/
default-character-set latin1
enable-locking FALSE
enable-pstack FALSE
innodb_data_home_dir (No default value)
innodb_log_group_home_dir (No default value)
innodb_log_arch_dir (No default value)
innodb_flush_log_at_trx_commit 1
innodb_flush_method (No default value)
innodb_fast_shutdown TRUE
innodb_max_dirty_pages_pct 90
init-file (No default value)
log (No default value)
language /usr/local/mysql/share/mysql/english/
local-infile TRUE
log-bin (No default value)
log-bin-index (No default value)
log-isam myisam.log
log-update (No default value)
log-slow-queries (No default value)
log-slave-updates FALSE
low-priority-updates FALSE
master-host (No default value)
master-user test
master-port 3306
master-connect-retry 60
master-retry-count 86400
master-info-file master.info
master-ssl FALSE
master-ssl-key (No default value)
master-ssl-cert (No default value)
master-ssl-capath (No default value)
master-ssl-cipher (No default value)
myisam-recover OFF
memlock FALSE
disconnect-slave-event-count 0
abort-slave-event-count 0
max-binlog-dump-events 0
sporadic-binlog-dump-fail FALSE
new FALSE
old-protocol 10
old-rpl-compat FALSE
pid-file /usr/local/mysql/var/woot.pid
log-error
port 0
report-host (No default value)
report-user (No default value)
report-password (No default value)
report-port 3306
rpl-recovery-rank 0
relay-log (No default value)
relay-log-index (No default value)
safe-user-create FALSE
server-id 1
show-slave-auth-info FALSE
concurrent-insert TRUE
skip-grant-tables FALSE
skip-slave-start FALSE
relay-log-info-file relay-log.info
slave-load-tmpdir /var/tmp/
socket /var/mysql/mysql.sock
sql-bin-update-same FALSE
sql-mode OFF
temp-pool TRUE
tmpdir /var/tmp/
external-locking FALSE
use-symbolic-links TRUE
--symbolic-links TRUE
log-warnings FALSE
warnings FALSE
back_log 50
binlog_cache_size 32768
connect_timeout 5
delayed_insert_timeout 300
delayed_insert_limit 100
delayed_queue_size 1000
flush_time 0
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
ft_stopword_file (No default value)
innodb_mirrored_log_groups 1
innodb_log_files_in_group 2
innodb_log_file_size 5242880
innodb_log_buffer_size 1048576
innodb_buffer_pool_size 8388608
innodb_additional_mem_pool_size 1048576
innodb_file_io_threads 4
innodb_lock_wait_timeout 50
innodb_thread_concurrency 8
innodb_force_recovery 0
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 268435456
long_query_time 10
lower_case_table_names FALSE
max_allowed_packet 1047552
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 200
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_tmp_tables 32
max_user_connections 0
max_write_lock_count 4294967295
bulk_insert_buffer_size 8388608
myisam_block_size 1024
myisam_max_extra_sort_file_size 268435456
myisam_max_sort_file_size 2147483647
myisam_repair_threads 1
myisam_sort_buffer_size 67108864
net_buffer_length 16384
net_retry_count 1000000
net_read_timeout 30
net_write_timeout 60
open_files_limit 0
query_cache_limit 1048576
query_cache_size 16777216
query_cache_type 1
read_buffer_size 1044480
read_rnd_buffer_size 262144
record_buffer 1044480
relay_log_space_limit 0
slave_compressed_protocol FALSE
slave_net_timeout 3600
slow_launch_time 2
sort_buffer_size 1048568
table_cache 256
thread_concurrency 8
thread_cache_size 8
tmp_table_size 33554432
thread_stack 196608
wait_timeout 28800

Thanks...

 

[Esteban Toledo]

sir nuke please quit moving posts all over the place...the reason we post in here is because we pretty much know everyone and people respond here...when you move posts to other less frequented forums, often you dont get any responses at all or very little compared to when they are in here...if someone wants to ask fellow p5ers what they think of their rims or whatever, lighten up and just leave it in this forum...its not killing anyone

It's much easier to do a search when everything is in it's proper location.

Also, when browsing, try clicking on "view today's active threads" instead of the p5 forum. Because users carelessly post in the wrong forums, you'll probably find more that you can relate to.

 

[savaho]

Maybe it's the hd. Are you guys running a scsi drive? What type of line is the server running on, T1 - T3? Also 1000mbs fiber gigabit nics are helpful.

 

[enry]

sad.

 

[spazspike]

thanks for clearing that up then

 

[enry]

well I checked my mail today (hadn't for a few days) and I got about 400 "too many connections" emails from the forum. so I think that might be the problem.
you would laugh at how many errors I get when the DB server is down, like 20 emails per second. like now, for example, I had to restart the DB server. and let's see how many emails... *drumroll* (waiting for effin email client).. 226 emails.

 

[fkmp5]

I was just going to post how the site has been painfully slow during the day lately.. i don't notice it as much when i'm on the site at night time..

are you guys doing any kind of database backup during the day? that may also slow things down.. if so reschedule it for the middle of the night (granted we have international users, but we should be able to find some time period that is the slowest traffic wise)..

if it's more server power or more uplink bandwidth needed, i'm willing to donate again to help out towards costs and would hope that others would do the same..

 

[enry]

I am quite certain the pipe is not the problem. Let's see how it fares with a higher max_connections on mysql.