• 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

#1
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!
 

Jeremy

Well-known member
#2
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.
 
#3
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.
Thanks King Kovifor :p

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