[Question] Search index and mysql master/slave

[quydo]

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]

For 1, run the following queries:

TRUNCATE TABLE `xf_search`

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.

 

[quydo]

For 1, run the following queries:

TRUNCATE TABLE `xf_search`

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

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

 

[Jeremy]

Yes.