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.
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.