RC2 to RC3 Question

DirtRider

  • All truth, in the long run, is only common sense clarified.
  • Posts: 303
RC2 to RC3 Question
« on October 15th, 2010, 07:04 PM »
I have been with the same host since I have been running SMF and have always had great service from them. Ok it is shared hosting and they give me everything I need for my forum and I don't really want to change. Now the thing is SMF has been running great with them for all this time but just after I upgraded from RC2 to RC3 I started having issues. I cannot be 100% certain this is related or just a coincidence. Anyway I will have random database crashes and will need to do a repair in my cPanle. After speaking to my host it would see this is the issue
Quote
[ Fri Sep 3 13:03:01 2010 ] [ TT_dbo2477 ] [ 3250211 ] [ 21 ] [ TT_db247744357 ] [ Query ] [ KILLED ] [ ] [ OPTIMIZE TABLE `db247744357_messages` ]
Seem this query is taking too long at times and they kill it, so then I have a crashed database. Now did something change in the version that would affect this timing
“Any code of your own that you haven’t looked at for six or more months might as well have been written by someone else.”
(Eagleson’s Law)

Today's Logo

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: RC2 to RC3 Question
« Reply #1, on October 15th, 2010, 07:33 PM »
Optimise is expensive and often unnecessary. Several of the bigger boards don't run it at all.

It's not anything different in RC3 in this case, the main issue is that your forum is simply bigger than it was before. Turn off optimisation, it won't get things any faster, and does make it slower - particularly because it prevents anyone else writing to the tables while it's running.
When we unite against a common enemy that attacks our ethos, it nurtures group solidarity. Trolls are sensational, yes, but we keep everyone honest. | Game Memorial

DirtRider

  • All truth, in the long run, is only common sense clarified.
  • Posts: 303
Re: RC2 to RC3 Question
« Reply #2, on October 15th, 2010, 07:42 PM »
That is the problem my board is not that much bigger than before really. I will turn it off that was going to be my next question thanks  :cool:

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: RC2 to RC3 Question
« Reply #3, on October 15th, 2010, 07:49 PM »
Well, imagine that it was on the threshold of being a problem before but it's now reached the point where it is a problem - it would look fine one day and troublesome the next.

Though if you have a host that's killing OPTIMIZE queries mid cycle, and not cognizant of the fact that their customer's data will be damaged, that's fairly poor IMO.

DirtRider

  • All truth, in the long run, is only common sense clarified.
  • Posts: 303
Re: RC2 to RC3 Question
« Reply #4, on October 15th, 2010, 08:06 PM »
Actually they were very good about the whole issue and did a few tweaks and since then it has only happened once. The thing is as I said up until now I have really got good service from them and I can phone them on Skype and this is a great plus for me