0

I am using web shop which is working on Magento 1.7.02.

MySQL database is just hitting the limit of available size from hosting company (500mb) As usually I clear those tables:

log_customer 
log_quote 
log_summary 
log_summary_type 
log_url 
log_url_info 
log_visitor 
log_visitor_info 
log_visitor_online

But slowly running out of the space. Those below take most of space (about 350mb combined)

mg_report_viewed_product_index
mg_report_event
mg_catalogsearch_result

Is any of those ok to be emptied? Any suggestions which tables can be emptied to trim database size?

Thanks in advance

Marcin

2

You can reduce your database size by TRUNCATING these tables:

dataflow_batch_export
dataflow_batch_import
log_customer
log_quote
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
log_visitor_online
report_viewed_product_index
report_compared_product_index
report_event

For more/details check here : https://stackoverflow.com/questions/3638361/clearing-magento-log-data

  • Hi, thanks for your help. Trimmed the size from 486MB to 137MB. – Optimusprime May 6 '16 at 7:04
  • Glad that helps, please mark answer as accepted so may helps to others :) – Anil Suthar May 6 '16 at 7:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.