Is it just me?

[quadrafire]

The last 2 days I have been having some inconsistent connection problems with the HuntWa site. Sometimes it searches previous posts VERY slowy, and sometimes says lost connection. I haven't noted any issues with other web sites. Hummmm???

[high country]

me 2
 

[jackelope]

No it's not you. There's a thread on here about it already. The server needs to be upgraded again and it is in the works soon.

[quadrafire]

No it's not you. There's a thread on here about it already. The server needs to be upgraded again and it is in the works soon.

Thanks

[trippledigitss]

Yeah I am having the same problem. It seems like its getting worse everyday - I can barely get on or stay on today. Will be really glad when it is fixed!!

[Ray]

The server is getting hammered. It simply cannot keep up with the httpd processes being spawned and the mysql usage often spikes to 90% of CPU. If I was going to rent a new server I would ask if you can get NGINX. It will run better than Apache and this technology will allow you to rent a lower end server and get more out of it. The MySQL database seems tuned well so there is not much else to do there. I would consider removing the "Random Photo" on the right as running the code wich renders that image is consuming more resources than you might want by writing to temp tables (read memory swap is being used). Additionally I would take a closer look at the mysql slow queries log at least once a month. Some tables may need to move to INNODB.

Bad  juju:

Copying to tmp table

70s


SELECT   t.id_topic, t.num_replies, t.locked, t.num_views, t.is_sticky, t.id_poll, t.id_previous_board,   0 AS new_from,   t.id_last_msg, t.approved, t.unapproved_posts, ml.poster_time AS last_poster_time,   ml.id_msg_modified, ml.subject AS last_subject, ml.icon AS last_icon,   ml.poster_name AS last_member_name, ml.id_member AS last_id_member,   IFNULL(meml.real_name, ml.poster_name) AS last_display_name, t.id_first_msg,   mf.poster_time AS first_poster_time, mf.subject AS first_subject, mf.icon AS first_icon,   mf.poster_name AS first_member_name, mf.id_member AS first_id_member,   IFNULL(memf.real_name, mf.poster_name) AS first_display_name, SUBSTRING(ml.body, 1, 385) AS last_body,   SUBSTRING(mf.body, 1, 385) AS first_body, ml.smileys_enabled AS last_smileys, mf.smileys_enabled AS first_smileysFROM smf_topics AS t   INNER JOIN smf_messages AS ml ON (ml.id_msg = t.id_last_msg)   INNER JOIN smf_messages AS mf ON (mf.id_msg = t.id_first_msg)


State

Time

Query



Copying to tmp table

13s


SELECT t.id_topicFROM smf_topics AS t   INNER JOIN smf_messages AS mf ON (mf.id_msg = t.id_first_msg)WHERE t.id_board = 2ORDER BY is_sticky DESC, mf.subjectLIMIT 120, 20

[quadrafire]

The server is getting hammered. It simply cannot keep up with the httpd processes being spawned and the mysql usage often spikes to 90% of CPU. If I was going to rent a new server I would ask if you can get NGINX. It will run better than Apache and this technology will allow you to rent a lower end server and get more out of it. The MySQL database seems tuned well so there is not much else to do there. I would consider removing the "Random Photo" on the right as running the code wich renders that image is consuming more resources than you might want by writing to temp tables (read memory swap is being used). Additionally I would take a closer look at the mysql slow queries log at least once a month. Some tables may need to move to INNODB.

Bad  juju:

Copying to tmp table

70s


SELECT   t.id_topic, t.num_replies, t.locked, t.num_views, t.is_sticky, t.id_poll, t.id_previous_board,   0 AS new_from,   t.id_last_msg, t.approved, t.unapproved_posts, ml.poster_time AS last_poster_time,   ml.id_msg_modified, ml.subject AS last_subject, ml.icon AS last_icon,   ml.poster_name AS last_member_name, ml.id_member AS last_id_member,   IFNULL(meml.real_name, ml.poster_name) AS last_display_name, t.id_first_msg,   mf.poster_time AS first_poster_time, mf.subject AS first_subject, mf.icon AS first_icon,   mf.poster_name AS first_member_name, mf.id_member AS first_id_member,   IFNULL(memf.real_name, mf.poster_name) AS first_display_name, SUBSTRING(ml.body, 1, 385) AS last_body,   SUBSTRING(mf.body, 1, 385) AS first_body, ml.smileys_enabled AS last_smileys, mf.smileys_enabled AS first_smileysFROM smf_topics AS t   INNER JOIN smf_messages AS ml ON (ml.id_msg = t.id_last_msg)   INNER JOIN smf_messages AS mf ON (mf.id_msg = t.id_first_msg)


State

Time

Query



Copying to tmp table

13s


SELECT t.id_topicFROM smf_topics AS t   INNER JOIN smf_messages AS mf ON (mf.id_msg = t.id_first_msg)WHERE t.id_board = 2ORDER BY is_sticky DESC, mf.subjectLIMIT 120, 20

Uhhhh? I understood one sentence of that, but glad that some of you do. I for one have never even looked at the random photo thread. For me if that could go It wouldn't bother me. May save you from an upgrade?? By the way-----I would be willing to contribute a few bucks to help as would many others i'm sure if sponsorship does not cover it all to help keep this site functional

[ICEMAN]

Ray! Long time no see! We need your expert tech!!! Good to hear ya!

[trippledigitss]

Whoa - that hurt my brain even trying to read let alone understand it!  It may as well been typed in Arabic, I would have understood just as much! 

[Special T]

Ray, Is this because we have had such a huge increase in users? Or are we adding too may pics that are constantly being pulled up? or some combo of the 2? I'm glad you are on it thankyou!

[HUNTINCOUPLE]

Thank god for the IT guys. I run low on brain power operating my dumbphone!!!

[jackelope]

Ray, Is this because we have had such a huge increase in users? Or are we adding too may pics that are constantly being pulled up? or some combo of the 2? I'm glad you are on it thankyou!

I'm in the "learning as I go" mode and I think it's safe to say it's a combination of a bunch of things.
A lot of boards, a lot of members, a lot of stuff. It's more of the growing pains thing. I think it's safe to say there's also more maintenance that needs to be done from time to time on here that maybe we're not doing?
We're working on it as we speak.

[jackmaster]

thats some serious computer lingo ya got goin there, you do know your talkn to a bunch of redneck hunters that can barely find there way to this site every day   

[Boss .300 winmag]

Hell I went from a sourdough with over a thousand post to below 500 and I am a scout again??? WT HELL

[trippledigitss]

Hell I went from a sourdough with over a thousand post to below 500 and I am a scout again? ?? WT HELL

I lost a bunch of posts too. I think some were taken when the You Tube thread was deleted and so I'm guessing a few others I posted in were deleted and I lost more.    But only like 100, not a 1000!

[trippledigitss]

Whoa - I didnt realize I had even less than before when I sent that last one. I was around 860, then down to 760 earlier today (where I thought I was when I sent this) now I am at 484 as I type this. I'm back to being a pee-on    again!  Wait...well, I guess I still was even at 860....     

[jackelope]

I split a couple of the big threads like the Word Association Game and the Washington where am I threads. Deleted most of them and left the last few posts and started new threads out of them. Threads with over 1k posts have a negative influence on the performance of the forum. I'm having trouble deleting them completely but as far as you guys can see they're gone. There was 33,000 replies to the Word Association Game thread and I think Ray has done the same splitting of that thread once before.

[Boss .300 winmag]

I like being a scout, sounds more impressive.

[trippledigitss]

I like being a scout, sounds more impressive.

I dont - I was just finally building up some "street cred"