关于MySQL中的Medium Blob字段 [英] About Medium Blob field in MySQL

问题描述

亲爱的朋友们，



我使用的是MySql Server，我确实创建了一个表格，用于保存大量文档。



我保存的文件只有PDF，每份文件不超过16MB。



我的问题是关于托管数据库的服务器中的磁盘，因为我已经注册了80个文件，数据库中备份文件的大小为116 MB。



然后，当我有1000.00文件时，我的备份文件的大小将会增加



相当大，这就是重点我不清楚，因为我想保持一个可管理的备份大小，有一种方法可以在

表格中显示我的中等大小字段的大小？



你会对这个案例以及你的观点进行重新评估。



请告诉我你的意见和技术论点使用Medium blob数据类型

在我的数据库中。



提前致谢。



Leonardo Ayala R.

Dear Friends,

I am using a MySql Server and I did create a table where I am saving a lot of documents.

The documents that I am saving are only PDF and each document dont exceded the 16MB.

My question is about the size of the disk in the server that hosting the database, because I

have registred 80 documents and the size of my backup file in the database is 116 MB.

Then, when I will have 1000.00 documents the size of my backup file will be increasing

considerably, this is the point that I don have clear, because I want keep a size of backup manageable, there is a way that I make a perfomance in the size of my mediumblob field in the
table?

what will be you recomentation about this case and your point of view.

Please give me your advices and your technical arguments about the use of Mediumblob data type
in my database.

Thanks in advance.

Leonardo Ayala R.

推荐答案

Don't save the documents in your database. Just save the path to the documents in your database.

databases are not file systems and should not be treated as such.

http://shaiekh.com/home/where-to-store-uploaded-files-filesystem-vs-database/ [ ^ ]



（感谢Leonardo Ayala）



如何将二进制数据存储和提取到文件流列 [ ^ ]



感谢Mika Wendelius。

http://shaiekh.com/home/where-to-store-uploaded-files-filesystem-vs-database/[^]

(Thanks to Leonardo Ayala)

How to store and fetch binary data into a file stream column[^]

Thanks to Mika Wendelius.

这篇关于关于MySQL中的Medium Blob字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！