Osclass Documentation
Download OslcassCodeIssuesSupport Forum
v3.9.0
v3.9.0
  • Osclass
  • Beginners
    • Install
    • Updating Osclass
    • Osclass Cron
  • Configuring Osclass
    • Mail Server
    • Installing Locations
    • Increase PHP memory limit
    • Improving Search
    • Configure Cache
  • Developers
    • Basic Osclass
      • Contribute to Osclass
      • Coding Style
      • Debug PHP Errors
      • Debug SQL Queries
      • How to write a bug report
      • Database model and diagram
    • Plugins and Themes
      • Auto-update themes and plugins
      • Administrator Menus
      • Admin Toolbar
      • Style and scripts enqueue functions
      • Routes
  • Legacy Installations Pre 3.8.0
    • Introduction
    • Remove calls to Osclass
      • Delete featured products from Admin.
      • Stop auto upgrading.
      • Stop checking for updates from Osclass.
      • Disable Upgrade page
    • Remove Market from admin frontend
      • Delete Market from Admin menu.
      • Delete Market from Plugins.
      • Delete Market from Appearance (themes).
      • Delete Connect Market from Admin toolbar.
Powered by GitBook
On this page
  • Improving search
  • Changing the maximum, minimum limit
  • Rebuilding FULL-Text Index

Was this helpful?

Export as PDF
  1. Configuring Osclass

Improving Search

PreviousIncrease PHP memory limitNextConfigure Cache

Last updated 5 years ago

Was this helpful?

Improving search

MySQL's full-text search capability has few user-tunable parameters.

NOTE:Note that full-text search is carefully tuned for the most effectiveness. Modifying the default behavior in most cases can actually decrease effectiveness. Do not alter the MySQL sources unless you know what you are doing.

For Osclass users, item title and item description have a fulltext index, that do search more effective and speed up.

The minimum and maximum lengths of words to be indexed by default is 4 (4 characters), that means, only words more or equal than 4 will be indexed.

Changing the maximum, minimum limit

If you like to change the minimum and maximum lengths of words to be indexed, you need update your mysql config file.

[mysqld]
ft_min_word_len=3
[mysqld]
ft_max_word_len=10

Rebuilding FULL-Text Index

After this, if you modify full-text variables that affect indexing (ft_min_word_len, ft_max_word_len, or ft_stopword_file), you must rebuild your FULL-TEXT indexes after making the changes and restarting the server. To rebuild the indexes in this case, it is sufficient to do a QUICK repair operation:

REPAIR TABLE tbl_name QUICK;

Replace tbl_name with your table name. e.g oc_t_item_description.

Source: Fine-Tuning MySQL Full-Text Search

[1]