Post by: quadrafire on October 25, 2011, 09:18:59 AM
Post by: high country on October 25, 2011, 09:23:12 AM
Post by: jackelope on October 25, 2011, 09:23:23 AM
Post by: quadrafire on October 25, 2011, 09:27:21 AM
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.:tup: Thanks
Post by: trippledigitss on October 25, 2011, 01:51:21 PM
Post by: Ray on October 25, 2011, 04:57:16 PM
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
Post by: quadrafire on October 25, 2011, 05:55:09 PM
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
Post by: ICEMAN on October 25, 2011, 06:21:03 PM
Post by: trippledigitss on October 25, 2011, 07:12:37 PM
Post by: Special T on October 26, 2011, 10:12:02 AM
Post by: HUNTINCOUPLE on October 26, 2011, 10:17:37 AM
Post by: jackelope on October 26, 2011, 12:11:13 PM
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.
Post by: jackmaster on October 26, 2011, 12:17:12 PM
Post by: Boss .300 winmag on October 26, 2011, 02:08:08 PM
Post by: trippledigitss on October 26, 2011, 03:45:58 PM
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. :dunno: But only like 100, not a 1000!
Post by: trippledigitss on October 26, 2011, 03:49:24 PM
Post by: jackelope on October 26, 2011, 03:56:14 PM
Post by: Boss .300 winmag on October 27, 2011, 07:18:35 PM
Post by: trippledigitss on October 28, 2011, 09:12:48 AM
I like being a scout, sounds more impressive. :IBCOOL:
I dont - I was just finally building up some "street cred" :chuckle: