SMF Support > SMF 2.0.x Support
SMF keeps going up and down?
Ruddy Kitty:
I've been working with Colin and we can't even figure out what is causing my forum to go down all the time. The new host I have can't figure it out either.
As quoted by Colin:
--- Quote ---I am not too sure at this point. It seems like the issue is on their end, but I would consider making a post on the SMF forum to see if anyone else has any ideas. I am thinking the raw size of your database may be part of the bottleneck with their systems.
--- End quote ---
Also from my new web host...
--- Quote ---Oddly but there isn’t anything special caught with a log-slow-queries . The one that does keep re-occuring as the slow one is the following one, through I’m not sure that specific one is creating the problems with mysql connections.
#####################################################################
INSERT IGNORE INTO smf_log_search_results
(id_search, relevance, id_topic, id_msg, num_matches)
SELECT
71,
1000 * (30 * COUNT(*) / (MAX(t.num_replies) + 1) + 25 * CASE WHEN MAX(m.id_msg) < 2480218 THEN 0 ELSE (MAX(m.id_msg) - 2480218) / 1062951 END + 20 * CASE WHEN MAX(t.num_replies) < 200 THEN MAX(t.num_replies) / 200 ELSE 1 END + 15 * CASE WHEN MAX(lst.id_topic) IS NULL THEN 0 ELSE 1 END + 10 * CASE WHEN MIN(m.id_msg) = MAX(t.id_first_msg) THEN 1 ELSE 0 END + 0 * MAX(t.is_sticky)) / 100 AS relevance,
t.id_topic,
MAX(m.id_msg) AS id_msg,
COUNT(*) AS num_matches
FROM smf_topics AS t
INNER JOIN smf_messages AS m ON (m.id_topic = t.id_topic)
LEFT JOIN smf_tmp_log_search_topics AS lst ON (lst.id_topic = t.id_topic)
WHERE m.body LIKE '%aoitsuki%'
AND m.id_board IN (41, 39, 43, 26, 35, 6, 42, 7, 27, 2, 3, 4, 29, 30, 31, 8, 9, 12, 28, 1, 34, 21, 14, 13)
GROUP BY t.id_topic
ORDER BY null
LIMIT 6000;
#####################################################################
--- End quote ---
The site is slow and when it goes down, it says that smf can't connect to the mysql server database because it is busy.
ANY IDEAS? Please and thanks so very much.
ziycon:
First off I would say it's a mySQL issue if it's unable to handle the number of requests that it's receiving.
What host are you with?
When do you have these problems are they at any particular time of the day/night or only on certain days?
Have you ruled out any scheduled backups running on the database?
Is it shared hosting?
Ruddy Kitty:
Yes it is shared hosting, I cannot possibly afford NON-shared hosting.
It's http://www.deltawebhosting.com
No it seems to happen randomly, will be up for about 10 minutes then crash for about an hour.
It doesn't seem like a scheduling issue but I don't know how to check for anything like that.
Arantor:
You need to talk to your members about them donating towards site costs, looks to me as though your site is simply too big for shared hosting, looking at the queries and the numbers in them.
Colin:
--- Quote from: Arantor on June 14, 2012, 09:20:26 AM ---You need to talk to your members about them donating towards site costs, looks to me as though your site is simply too big for shared hosting, looking at the queries and the numbers in them.
--- End quote ---
That is my thought as well.
Navigation
[0] Message Index
[#] Next page
Go to full version