Wedge
Public area => Off-topic => The Pub => Other software => Topic started by: DirtRider 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
[ Fri Sep 3 13:03:01 2010 ] [ TT_dbo2477 ] [ 3250211 ] [ 21 ] [ TT_db247744357 ] [ Query ] [ KILLED ] [ ] [ OPTIMIZE TABLE `db247744357_messages` ]
-
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.
-
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:
-
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.
-
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