mysql - 什么时候推荐使用 MySQL BLOB？

Question

我正在编写一个将上传和删除许多文件的应用程序，我通常只是将文件移动到服务器中的一个文件夹中，并使用行唯一 id 命名它们。但据我所知，MySQL 还允许我存储二进制数据(文件)，什么时候这是更好的选择？

Please use solid arguments, like When does using BLOB will mean performance improvement?.

P.S:如果重要的话，我正在使用 MyISAM。

谢谢。

---

更新:

Related questions:
- Storing Images in DB - Yea or Nay?
- To Do or Not to Do: Store Images in a Database (thanks to Sebastian)

更新 2

将文件存储在数据库中是不需要我想知道什么时候这是比存储更好的主意吗它们在文件夹中。

Answer 1

阅读:

• MySQL Binary Storage using BLOB VS OS File System: large files, large quantities, large problems
• To Do or Not to Do: Store Images in a Database

其中结论

If you on occasion need to retrieve an image and it has to be available on several different web servers. But I think that's pretty much it.

• If it doesn't have to be available on several servers, it's always better to put them in the file system.
• If it has to be available on several servers and there's actually some kind of load in the system, you'll need some kind of distributed storage.