Magento 2.2.6/var/lib/mysql/文件夹占用43 GB的磁盘空间 [英] Magento 2.2.6 /var/lib/mysql/ folder is taking 43 gb of disk space
问题描述
由于某些原因，我的magento 2网站(Magento版本2.2.6)从服务器占用了太多空间.昨天有1.2 GB可用空间，现在只有240mb可用空间.请对此提供帮助.
Due to some reason my magento 2 website (Magento ver. 2.2.6) taking too much space from the server . Yesterday there is 1.2 gb available now only 240mb available . Please help on this .
请立即查看附件图片
更新:我发现大部分磁盘空间被 /var/lib/mysql/webna 此文件夹(42 gb).这里的webna是我的数据库名称.在该文件夹中，我可以看到很多IBD，FRM和MYI 文件.在webna文件夹中有一个文件名为 mageplaza_smtp_log.ibd，文件大小为43 gb .
UPDATE : I have found that most of the disk space is taken by /var/lib/mysql/webna this folder (42 gb). Here webna is my database name .In that folder i can see lots of IBD , FRM, MYI files. There is on file inside the webna folder called mageplaza_smtp_log.ibd and it's file size is 43 gb.
请参见下图
我可以删除这些大文件吗?
推荐答案
如果删除这些文件，您的Magento网站肯定会停止工作.
If you delete these files, your Magento site will certainly stop working.
我想最大的文件mageplaza_smtp_log正在存储从您的服务器发送的电子邮件的历史记录.您的网站随着时间的推移发送的电子邮件越多，并且每封电子邮件的内容越大，该表空间中存储的邮件就越多.
I would guess that the largest file mageplaza_smtp_log is storing the history of emails sent from your server. The more emails your site sends over time, and the larger the content of each email, the more will be stored in that tablespace.
This may be related to this feature: https://www.mageplaza.com/faqs/is-there-a-way-to-log-and-view-the-emails-sent-to-recipients.html
是否可以记录和查看发送给收件人的电子邮件?
这可以
可通过以下Mageplaza > SMTP > Email Logs访问.从这里
您可以查看从服务器发送给客户的所有已发送电子邮件.
该日志电子邮件可以定期清除.
This can
be accessed by the following Mageplaza > SMTP > Email Logs. From here
you can look back all the sent email from the server to customers.
This log email can be cleaning periodically.
我建议您弄清楚最后一行中的内容，如果不需要，请定期清除日志.我不是Magento用户，但我想可以在他们引用的屏幕上进行一些控制.
I recommend you figure out how to do what the last line says, clean out the log periodically if you don't need it. I am not a Magento user, but I suppose there's some control to do that on the screen they reference.
最好使用Mageplaza屏幕执行此操作，因为如果Mageplaza需要其他内部簿记来更新多个表，则只有他们的代码才能知道如何正确执行此操作.
It would be best to use the Mageplaza screens to do this action, because if there is other internal bookkeeping necessary for Mageplaza to update multiple tables, only their code would know how to do that properly.
如果您需要更具体的Magento帮助，则有一个专门针对Magento问题的姐妹网站Stack Overflow: https://magento.stackexchange.com
If you need more specific Magento help, there's a sister site to Stack Overflow specifically for Magento questions: https://magento.stackexchange.com
但是我敢肯定，仅删除自己的文件将对破坏您的网站非常有效.或者至少具有发送电子邮件和查看过去电子邮件日志的功能.
But I am sure that just deleting the files yourself will be very effective at breaking your site. Or at least the capability to send emails and view logs of past emails.
这篇关于Magento 2.2.6/var/lib/mysql/文件夹占用43 GB的磁盘空间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
