Announcement

Collapse
No announcement yet.

weired table name in the vb db + another vb real table

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • weired table name in the vb db + another vb real table

    Hi all,

    I found the following table:
    # ll -lh *sql-9a7_93*
    -rw-rw---- 1 mysql mysql 9.2K Aug 24 2012 #sql-9a7_93edc.frm
    -rw-rw---- 1 mysql mysql 1.2G Aug 24 2012 #sql-9a7_93edc.MYD
    -rw-rw---- 1 mysql mysql 51M Aug 24 2012 #sql-9a7_93edc.MYI


    First, the timestamp if from nearly 2 years ago, whereas all other tables are with 'today()' date.
    Second, this is fairly large table: 1.2GB.

    Can anyone tell me what it is? do I need it?
    Is it a leftover from some optimization attempt?

    Next, I have the following table:

    # ll -lh *searchcore_text*
    -rw-rw---- 1 mysql mysql 8.5K Sep 22 2012 searchcore_text.frm
    -rw-rw---- 1 mysql mysql 647M Nov 7 15:53 searchcore_text.MYD
    -rw-rw---- 1 mysql mysql 887M Nov 7 15:53 searchcore_text.MYI

    This is also a fairly large size table.
    What is it used for?
    Is it for optimized search?
    Can it be emptied? will it have any effect?


    Thanks for any input.

    -Sup.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X