Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved MyISAM into InnoDB
#11
Not Solved
Nah, the index type was changed, but the query that is running is still expecting there to be a full text index. From looking at the query it seems to be a similar threads plugin (or something like that).
NeoCHI, if you have such a plugin, try disabling it.
#12
Not Solved
(2013-11-24, 06:44 AM)Cameron:D Wrote: Nah, the index type was changed, but the query that is running is still expecting there to be a full text index. From looking at the query it seems to be a similar threads plugin (or something like that).
NeoCHI, if you have such a plugin, try disabling it.

Undecided but I've tried disabling all plugins already...Confused anything else can be causing this? maybe the similar threads feature in mybb? Huh

Btw, what are these indexes for exactly anyways? Reason why I ask is because when I tested on the other forum, after dropping the index on "subject" I wasn't able to see any noticeable difference on how my forum acted, including search.

Thanks Cameron! Looks like it was mybb's built in similar threads feature that was causing this issue! I've disabled it and now it works fine. =)
#13
Not Solved
Oh of course, it is an inbuilt feature, completely forgot about that.
#14
Not Solved
Btw, what are these indexes for exactly anyways? Reason why I ask is because when I tested on the other forum, after dropping the index on "subject" I wasn't able to see any noticeable difference on how my forum acted, including search.
#15
Not Solved
Depending on the size of the forum it may be considerably slower (seconds and more).
http://dev.mysql.com/doc/refman/5.5/en/o...dexes.html
[Image: banner.png]
#16
Not Solved
Hmm based on http://www.vbum.com/2010/01/mybb-and-inc...rformance/ he removed his full text index on message in his posts table.

Do you guys recommend I do the same, should I even change my posts table to innodb?
#17
Not Solved
I'd guess that on free or shared hosting you're not going to notice a difference in performance between InnoDB and MyISAM.
#18
Not Solved
I'm not on shared my forum is pretty big (over 1 million posts) with usually around 300 active members within the last 15 minutes. I ask because I've been getting alot of max connections issues even after I've switched over my threads, posts and user tables to innodb. I've also noticed some slow down so dunno if that was because I changed my tables to innodb or because I dropped the index on "message" in my posts table.
#19
Not Solved
In that case it may be an issue of InnoDB not being allocated enough memory (It likes to cache as much data as possible in memory). Grab mysqltuner and run it to see what it suggest in regards to your InnoDB buffer pool sizes. I think the recommended value for the InnoDB buffer pool is the size of data in the InnoDB tables + ~10% (to allow for growth).

For reference I've got 600k posts, 60+ users online and around 2 requests/sec. On an average page load MySQL rarely takes over 50msec. All tables are InnoDB, no index on messages.
#20
Not Solved
Why is everyone telling him to remove the fulltext indexes? They are supported perfectly fine in MySQL 5.6+..
RedHat Certified Systems Administrator
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 3 Guest(s)