FabioPaz Posted March 4, 2013 Posted March 4, 2013 Hello, I complained about the slowness on my server with my hosting provider and they told me this: "I have checked the server and could see that your MySQL is pretty busy all the time by writing/removing data in ibf_reputation_cache." Just for curiosity, I disabled the reputation system and the forum became fast again. Reputation system is that heavy or this is just a coincidence or someone is abusing the system ? Thank you
NenaDice Posted March 4, 2013 Posted March 4, 2013 Personally I have never encountered this. Can you ask you rhost to supply you with some exact code of what it is that it is causing the server strain?
Guest Ae9803 Posted March 4, 2013 Posted March 4, 2013 I agree I have never had this issue either... Id highly suggest starting a ticket with Ipboard
Grumpy Posted March 5, 2013 Posted March 5, 2013 Which version of IPBoard are you running? In 3.2, my rep table alone had grew to over 2GB on my forum (yes, big forum). lol
FabioPaz Posted March 5, 2013 Author Posted March 5, 2013 3.4.2 Yeah, don't make sense. My rep table have 200mb and I'm using InnoDB.
mikaweb™ Posted March 7, 2013 Posted March 7, 2013 My host said the same thing to me a few months back. I disabled it but I'm currently looking into another hosting solution (dedicated).
FabioPaz Posted March 8, 2013 Author Posted March 8, 2013 I run the board on a pretty powerful dedicated. :( I tried again to enable the reputation system and my server went extremely slow. Even others softwares in the same server are slow now.
Linda A Posted April 4, 2013 Posted April 4, 2013 I have to admit that a couple of months back we had to turn off reputation on our forum. It was leading to table locks that brought the forum down to a crawl. As soon as we turned it off, it became much better. Is reputation something that might particularly benefit from being moved form MyISAM to InnoDB?
nodle Posted April 5, 2013 Posted April 5, 2013 I just tested on mine also, seemed to take the load down quite a bit.
wmarcy Posted April 5, 2013 Posted April 5, 2013 Is reputation something that might particularly benefit from being moved form MyISAM to InnoDB?This is the question I have also.Anyone?
GreenLinks Posted April 6, 2013 Posted April 6, 2013 This is the question I have also. Anyone? If you are having table locks , you should consider converting to InnoDB
Luis Manson Posted April 6, 2013 Posted April 6, 2013 how do you people realize there are table locks?
Grumpy Posted April 7, 2013 Posted April 7, 2013 Well, the simplest way to see if you're having issues with table locking is Wait for site to be slow. Go look at the current list of queries being executed. (http://dev.mysql.com/doc/refman/5.5/en/show-processlist.html ) Have a lot of queries with status: Waiting for table lock (may not be that exact wording). "Lot" is the keyword. Then you have a table locking problem.
Passion Posted April 7, 2013 Posted April 7, 2013 i have a pretty busy board useing the rep system and never had no problems i can suggest a few things one make your your setting is InnoDB. Also sounds more to me like a mysql setting i run a 16G dedi server at OVH where you get no support at all but you get full control with root access. anyways i was just having a slow loading problem with pms invites likes messed with this for days had 3 people looking at it and guess what it was IPtables from a firewall we installed telling you all now its not the likes system it is something else messing with the likes
Recommended Posts
Archived
This topic is now archived and is closed to further replies.