1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[Question] Search index and mysql master/slave

Discussion in 'XenForo Questions and Support' started by quydo, Jun 7, 2013.

  1. quydo

    quydo Member

    Hi everybody!

    I have some questions, please help me resolve it.

    1. How can I empty table xf_search and xf_search_ịndex. Assume I did that, how can I create new xf_search and xf_search_index data

    2. My site's database is too big, I want to use mysql master/slave, write in master and read in slave. How can I do that in Xenforo (config file, addon ...)

    Thank you very much!
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    For 1, run the following queries:
    Code:
    TRUNCATE TABLE `xf_search`
    Code:
    TRUNCATE TABLE `xf_search_index`
    Rebuild it through ACP -> Tools -> Rebuild Caches -> Rebuild Search Index

    For 2, XenForo doesn't yet support it in the default. I believe there may be an add-on around here, but I've never used it.
     
    maszd and quydo like this.
  3. quydo

    quydo Member

    Thanks King Kovifor :p

    So I can empty two tables without make database (structure, data) errors? I know mysql empty command :D
     
  4. Jeremy

    Jeremy XenForo Moderator Staff Member

    Yes.
     

Share This Page