When I live my magento store site the database size was 2.xx MB after one week when i take my database backup its size increase up-to 8.xx MB and browsing speed also reduced please any one tell me that why Database size is increasing automatically while i am not adding any new products in it and how to reduce it size to minimum
A lot of various logs and events are stored in database tables for every visitor and a few other actions causing the database to grow over time even with no action on your part. These tables regularly be cleaned up without causing any harm. The following SQL enables you to empty these tables manually. Magento also has built in functionality to clean the logs which you enable at System >> Configuration >> Advanced >> System >> Log Cleaning.
truncate dataflow_batch_export; truncate dataflow_batch_import; truncate log_customer; truncate log_quote; truncate log_summary; truncate log_summary_type; truncate log_url; truncate log_url_info; truncate log_visitor; truncate log_visitor_info; truncate log_visitor_online; truncate report_viewed_product_index; truncate report_compared_product_index; truncate report_event;