Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I've got a search_data table taking up 2.5GB of space.

I presume it's something to do with MySQL search queries but I'd like to reclaim some space - can I safely delete it?

Edit By @RolandoMySQLDBA

Please add the following information into this question

SELECT VERSION();
SHOW VARIABLES LIKE 'innodb_file_per_table';
SHOW CREATE TABLE search_data\G
share|improve this question
1  
What is in the table? A field list might help identify the purpose of the table. It seems from a quick Google search that search_data is not a built-in table - this would indicate it is likely from something you've installed on the server. Deleting that table would be entirely at your own risk - without knowing more detail it is difficult to help you. – Max Vernon Oct 29 '12 at 14:48

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.