Table Optimization and Repair Issue!
Collapse
X
-
try to choice small tables first and optimize them first,
then choice single big table like ; posts,searchcore_text and optimize it one by one , -
AdminCP > Maintenance > General Update Tools (if a lower version it's simply "Update Counters") > *Now scroll to find:
Rebuild Search Index
Note: You should not normally need to empty the search index, however if items are showing in search results after they have been permanently deleted then emptying the index and rebuilding the search index will fix this. Search will not work correctly after emptying the index until the index is fully rebuilt. Click Here to empty the search index.
Edit: If you have issues rebuilding then change the value under Number of items to process per batch from 250 to a lower value of 50-100 or so, it will take longer however if your having issues it will more than likely push on through and run using a lower value.
Former vBulletin Support Staff
Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!👍 1Comment
-
Emptying search tables and rebuilding search won't help and running OPTIMIZE will only just increase InnoDB shared table space size.
FYI, you do not need to run OPTIMIZE or REPAIR for InnoDB tables only MyISAM
To double check if your tables are MyISAM or InnoDB, query to run on page 2 if you have ssh telnet access http://vbtechsupport.com/675/2/:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment