Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Mysql Cleaning
 
Alekc
Jr. Member
 
Total Posts:  20
Joined:  2008-05-29
 

Hello, recently i was checking mysql disk space usage of magento and i’ve noticed that some tables are beginning to be very huge.

In particular:
m_dataflow_batch_export ~16,434 41.9 MiB -
m_dataflow_batch_import ~705,389 178.3 MiB -
m_log_url 735,410 17.5 MiB -
m_log_url_info 735,475 87.0 MiB -
m_log_visitor 407,920 93.9 MiB -
m_log_visitor_info 407,909 51.3 MiB -

Total: 417Mb

So i was wondering if it was safe to empty these tables, what do you think?

Thanks in advance…

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brandlive_br
Guru
 
Avatar
Total Posts:  653
Joined:  2008-05-19
Buenos Aires, Argentina
 

About the logs, I’m not sure if you gonna get some problems.
Did you try to optimize your tables?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Alekc
Jr. Member
 
Total Posts:  20
Joined:  2008-05-29
 

for now no, more than logs i was interested in dataflow_batch_import. In theory they are temp tables and their emptying should cause any troubles, but in practice who knows :/

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top