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 records
 
Corllete Ltd
Member
 
Avatar
Total Posts:  47
Joined:  2007-11-08
Bulgaria
 

Hi all, we have a production site and I just checked my MySQL DB. Is there a way to clear the following tables without breaking the magento functionality :

log_url -> 1,152,989 Records -> 27.5 MB
log_url_info -> 1,152,989 Records -> 133.0 MB
log_visitor -> 225,852 Records -> 52.0 MB
log_visitor_info -> 225,852 Records -> 28.9 MB

How can we stop logging all this information in the magento admin. Our DB is 284 MB big and it is impossible to create backups via magento admin.

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Corllete Ltd
Member
 
Avatar
Total Posts:  47
Joined:  2007-11-08
Bulgaria
 

I don’t think 284 MB of log data is a minor problem .... no one with answer here ?!?

 
Magento Community Magento Community
Magento Community
Magento Community
 
aquiss
Member
 
Total Posts:  54
Joined:  2008-05-03
United Kingdom
 

I don’t know if this helps, but the following might switch the logs off from admin?

System -> Advanced -> Advanced -> Mage_Log -> Disabled

 
Magento Community Magento Community
Magento Community
Magento Community
 
Corllete Ltd
Member
 
Avatar
Total Posts:  47
Joined:  2007-11-08
Bulgaria
 

Doesn’t helps .... anyway if someone can point me on how can i clear all of this data or if there is a cron job for clearing this data.

 
Magento Community Magento Community
Magento Community
Magento Community
 
crxman
Member
 
Total Posts:  57
Joined:  2008-11-14
 

hello same problem here does any body have an idea ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
SebboKleine
Jr. Member
 
Total Posts:  23
Joined:  2008-07-10
 

You can use a database tool (like PHPMyAdmin) to clear these tables:
truncate log_url;
truncate log_visitor;

BUT Nobody except varien nows exactly about side-effects.
So use this at your own risk and do backup your database before.

Also there are log-cleaning options in the backend (System-Configuration-Advanced-Advanced)

 
Magento Community Magento Community
Magento Community
Magento Community
 
crxman
Member
 
Total Posts:  57
Joined:  2008-11-14
 

thanks for this answer but every thing I’ve tried to clean logs with magento as no effet on those tables ...

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