Take the 2-minute tour ×
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It's 100% free, no registration required.

I have core_file_storage table in Magento with very huge size. What is it's functionality? Can I remove and replace functionality? Is it affects to the speed of my database? Thanks.

share|improve this question

3 Answers 3

up vote 3 down vote accepted

Magento can store media files in database.

Check Configuration \ Advanced \ System \ Storage Configuration for Media.

The main reason for storing media in database is the case when you use balancing servers and don't want to bother with shared directories. All the rest is performance degradation.

I suggest switching to filesystem storage. Files will be synchronised automatically by Magneto with click on "Sync" button at the admin screen posted above.

share|improve this answer
    
Nice bit about the 'sync' feature. –  philwinkle Mar 11 at 16:18

This table is backed by: Mage_Core_Model_File_Storage

It stores media files, as BLOBs in the DB, and can lead to issues with performance.

The intent behind this is for distributing the Media files across a larger installation, or even being able to extrapolate the storage system into something besides mysql or files.

The settings for this are in the admin: Configuration->Advanced->System->Storage Configuration for Media. Switching that setting to files, should remove the files from that table, thus shrinking it.

share|improve this answer

It's for storing media files in the database. Files are retrieved from the database with the file get.php in the Magento Root.

To disable this feature navigate in the system admin to:

Configuration > Advanced > System > Storage Configuration
share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.