No announcement yet.

searchcore is showing negative -3M records

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] searchcore is showing negative -3M records

    My server just hit the skids last night (mysql CPU usage went though the roof and stalled page load times to about 30 seconds). I'm running VB 4.0.2 - and it's been stable for about 6 months.

    I've flushed logs, and checked all tables, etc.

    I noticed that the searchcore tables look odd by displaying a negative number. is this the way it is supposed to look? I also have negative searchgroup numbers, but they are much lower in the 300K range. The forum also has 4.6M posts, but that table seems to look ok.

    Table | Records | Size
    searchcore -3,700,755 733.5 MB
    searchcore_text 3,725,690 1.0 GB
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.