Choosing Between Fulltext MySQL and Fulltext Native (Active)

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
Dzien Dobry
Registered User
Posts: 595
Joined: Thu Nov 08, 2001 3:55 pm

Choosing Between Fulltext MySQL and Fulltext Native (Active)

Post by Dzien Dobry » Wed Feb 13, 2008 2:00 am

Having a search option on my forum is a very important feature. When I installed my first phpBB in April of 2002, I don't recall having to decide between Fulltext MySQL and Fulltext Native (Active). With my recent upgrade to phpBB 3.0, I now have a choice.

At first I didn't think that my guess of trying Fulltext Native (Active) was premature. Now, 5 hours later, my system is still rebuilding the search index. Should I have chosen Fulltext MySQL? What are the relative advantages and disadvantages between Fulltext MySQL and Fulltext Native (Active)?
My database type is MySQL.

User avatar
EXreaction
Former Team Member
Posts: 5666
Joined: Sun Aug 21, 2005 9:31 pm
Location: Wisconsin, U.S.
Name: Nathan

Re: Choosing Between Fulltext MySQL and Fulltext Native (Active)

Post by EXreaction » Wed Feb 13, 2008 2:37 am

If your database supports it, you should use Fulltext MySQL, it will cut the size of your database by around 1/3, and you do not need to wait to rebuild the search index.

User avatar
Dzien Dobry
Registered User
Posts: 595
Joined: Thu Nov 08, 2001 3:55 pm

Re: Choosing Between Fulltext MySQL and Fulltext Native (Active)

Post by Dzien Dobry » Wed Feb 13, 2008 3:13 am

I just now posted a ticket with my web host, asking them if my MySQL database supports Fulltext MySQL. I sure hope they answer in the affirmative because my database size in phpBB 2.022 was 41.0 MB. After the conversion, it was 22.8 MB. After 5 hours of rebuilding the search index, the total database size only went up to 23.1 MB. If Fulltext MySQL isn't available to me, what do I do? The Fulltext Native search index rebuilding process doesn't seem to be working for me.

User avatar
EXreaction
Former Team Member
Posts: 5666
Joined: Sun Aug 21, 2005 9:31 pm
Location: Wisconsin, U.S.
Name: Nathan

Re: Choosing Between Fulltext MySQL and Fulltext Native (Active)

Post by EXreaction » Wed Feb 13, 2008 4:22 am

I believe the only requirement for the database is that the posts and topics table are MyISAM.

You can try switching and see if it gives you an error. If your tables are not MyISAM you may be able to change them to MyISAM in phpMyAdmin (view the table, go to Operations, and select MyISAM as the storage engine. I do not know if switching storage engines could cause a problem, so it would be best to get a database backup before you try it).

User avatar
angelside
Registered User
Posts: 105
Joined: Sat Jan 27, 2007 11:32 am
Location: Türkiye
Contact:

Re: Choosing Between Fulltext MySQL and Fulltext Native (Active)

Post by angelside » Tue Apr 14, 2009 7:06 am

What is differences between "Fulltext MySQL" and "Fulltext Native"? Which one is better performance?

I see; "Fulltext MySQL" does not use and "phpbb_search_wordlist" and "phpbb_search_wordmatch", well by using what, how to make a search, where is cache?
phpBB Türkiye | Turkish phpBB3 support and develop
phpBB3 Portal | simple portal for phpBB3 Olympus

gth
Registered User
Posts: 53
Joined: Mon Jan 27, 2003 12:02 pm

Re: Choosing Between Fulltext MySQL and Fulltext Native (Act

Post by gth » Thu Dec 30, 2010 9:07 am

(editted)

Okay, so it says to delete the index you don't want to use - but should the "(active)" text move to the only index remaining? At present it remains on the Fulltext Native index section, even though I deleted it.

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Choosing Between Fulltext MySQL and Fulltext Native (Act

Post by D¡cky » Thu Dec 30, 2010 5:44 pm

The "Active" search index is set under the General tab -> Server Configuration -> Search Backend.
Have you hugged someone today?

User avatar
GoBieN
Registered User
Posts: 529
Joined: Fri Mar 05, 2004 5:22 pm
Location: Belgium
Contact:

Re: Choosing Between Fulltext MySQL and Fulltext Native (Act

Post by GoBieN » Thu Dec 30, 2010 8:10 pm

If i change to mysql fulltext should i delete or empty the wordlist tables?

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Choosing Between Fulltext MySQL and Fulltext Native (Act

Post by D¡cky » Fri Dec 31, 2010 3:52 am

GoBieN wrote:If i change to mysql fulltext should i delete or empty the wordlist tables?
It is not necessary to empty the wordlist tables, but it will save you some database space. If you do decide to empty the wordlist tables, don't do it directly in the database. Use the Delete Index button in Maintenance -> Search Index.
Have you hugged someone today?

dressale
Registered User
Posts: 1
Joined: Fri Dec 31, 2010 3:37 am

Re: Choosing Between Fulltext MySQL and Fulltext Native (Act

Post by dressale » Fri Dec 31, 2010 3:54 am

You can try switching and see if it gives you an error. If your tables are not MyISAM you may be able to change them to MyISAM in phpMyAdmin (view the table, go to Operations, and select MyISAM as the storage engine. I do not know if switching storage engines could cause a problem, so it would be best to get a database backup before you try it).

User avatar
noth
Registered User
Posts: 2433
Joined: Fri Jan 07, 2005 7:10 pm
Location: North Surrey
Contact:

Re: Choosing Between Fulltext MySQL and Fulltext Native (Active)

Post by noth » Tue Oct 28, 2014 5:44 pm

EXreaction wrote:If your database supports it, you should use Fulltext MySQL, it will cut the size of your database by around 1/3, and you do not need to wait to rebuild the search index.
is this still the case with 3.1 please?
UK planning forums got a planning application in the UK?

Locked

Return to “[3.0.x] Support Forum”

Who is online

Users browsing this forum: Google [Bot], hypersaw and 57 guests