Sitecore 数据库和 App_Data 大小
我们有 5 个相对较小的网站在 Sitecore 之上运行。最早的已在该环境中托管了 3 年。目前，主数据库和 Web 数据库均约为 8 GB - 大小令人惊讶，但它们的大小几乎相同（我预计 Web 数据库会小得多）。同样令人惊讶的是 App_Data 的大小超过 50 GB（MediaCache 为 15 GB，MediaFiles 为 37 GB）。关于减少光盘上文件的方法（即使是暂时的）有什么想法或建议吗？
We have 5 relatively small sites running on top of Sitecore. The oldest has been hosted within the environment for 3 years. Currently both the master and web databases are roughly 8 GB a piece - surprising in size but also that they are nearly identical in size (I would expect the web database to be much smaller). Also surprising is the App_Data is over 50 GB in size (MediaCache is 15 GB and MediaFiles is 37 GB). Any ideas or suggestions on ways to reduce files on disc - even temporarily?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您可以删除媒体缓存文件夹中的所有内容。 Sitecore 将逐步重新创建网站上使用的图像的图像缓存。
如果您使用项目版本控制，则可以运行版本管理器并存档旧版本。然而，由于您的 Master 数据库和 Web 数据库的大小几乎相同，我认为这不会对您有帮助。网络数据库仅保存每个项目的 1 个版本。
最后一件事是爬行媒体库并查找 LinkDatabase 中没有任何引荐来源网址的项目并将其删除。确保先备份所有内容。
http://trac.sitecore.net/VersionManager
You can delete all the contents of the Media Cache folder. Sitecore will be gradually recreate the image cache of images that are being used on the sites.
If you use item versioning then you can run use the Version Manager and archive old versions. However as you Master and Web database are almost the same size I don't think that will help you. The web database only holds 1 version of each item.
The last thing would be to crawl through the media library and find items that don't have any referrers in the LinkDatabase and delete them. Make sure you back everything up first.
http://trac.sitecore.net/VersionManager
如果您将媒体资产存储在数据库中，我假设您是基于大小，我相信您可以删除 App_Data 文件夹，它会根据需要在其中重新添加文件。如果您将媒体资产存储在文件系统上，它们将存储在 App_Data 中，这可以解释其大小。您是否有可能将一些资产存储在数据库中，而将其他资产存储在文件系统中？无论如何，您应该分析 App_Data 中的文件类型，并将其与开箱即用的 Sitecore 实例进行比较，以了解网站内容与生成的缓存文件是什么。
If you are storing media assets in the Database, I assume you are based on the sizes, I believe you can delete the App_Data folder and it will re-add files there as needed. If you're storing media assets on the file system, they're stored in App_Data which would explain the large size. Is it possible you're storing some assets in the DB and others on the file system? In any case, you should analyze what types of files are in the App_Data and compare it to an out-of-the-box Sitecore instance to see what is site content vs. generated cache files.
您也可以尝试缩小数据库
You can try to shrink databases as well