Magento Database Optimization - Log Cleaning Script - Revision history

Brian: /* Log Cleaning to Speed up your Site */

2016-01-01T18:26:24Z

‎Log Cleaning to Speed up your Site

2016-01-01T18:24:50Z

‎Log Cleaning to Speed up your Site

2014-04-27T18:52:59Z

‎Setting Up a Weekly Cron

2014-04-27T18:48:53Z

‎Install via the Command Line

2014-04-26T16:56:21Z

‎Log Cleaning to Speed up your Site

2014-04-26T14:52:37Z

‎Setting Up a Weekly Cron

2014-04-26T14:48:42Z

‎Bash Script to Clear Logs and Optimize Magento Tables

2014-04-26T13:44:56Z

‎Log Cleaning to Speed up your Site

2014-04-26T13:44:34Z

‎Log Cleaning to Speed up your Site

2014-04-26T13:43:19Z

‎Bash Script to Clear Logs and Optimize Magento Tables

@@ Line 5: / Line 5: @@
 ===Log Cleaning to Speed up your Site===
-<pre style="color: red">DOES NOT WORK WITH MAGENTO 2</pre>
+'''<span style="color: red">DOES NOT WORK WITH MAGENTO 2</span>'''
 The following tables are accessed during normal operation of your Magento store.  Some of the logs files are access with every page view, and write/reading to them can dramatically slow down your site when they get large in size.

← Older revision		Revision as of 18:24, 1 January 2016
Line 4:		Line 4:

	===Log Cleaning to Speed up your Site===		===Log Cleaning to Speed up your Site===
		+
		+	<pre style="color: red">DOES NOT WORK WITH MAGENTO 2</pre>

	The following tables are accessed during normal operation of your Magento store. Some of the logs files are access with every page view, and write/reading to them can dramatically slow down your site when they get large in size.		The following tables are accessed during normal operation of your Magento store. Some of the logs files are access with every page view, and write/reading to them can dramatically slow down your site when they get large in size.

@@ Line 141: / Line 141: @@
 This script can also be ran from a weekly cron
-  crontab -u {your user} -e
+  crontab -e
 Then add the following line for every Sun at 5AM

@@ Line 77: / Line 77: @@
 Now Lets run the script
-  ./magento-cd-db-optimize.script
+  ./magento-ce-db-optimize.script
 <sub>'''-- Have not tested this on Magento 1.4 or older'''</sub>

@@ Line 34: / Line 34: @@
 * enterprise_logging_event_changes
-After cleaning out those logs, I have seen a site gain over 5 seconds to their load times.
+After cleaning out those logs, I have seen a site gain over 5 seconds off their load times.
 ===Optimization/Repairing your Database Tables===

← Older revision		Revision as of 14:52, 26 April 2014
Line 146:		Line 146:

	0 5 * * 0 /bin/bash /path/to/html/magento-db-optimize.script		0 5 * * 0 /bin/bash /path/to/html/magento-db-optimize.script
		+
		+	===Helps with the following===
		+
		+	magento speed, magento mysql optimization, magento is slow, magento slow performance, magento mysql, magento loading slow

@@ Line 46: / Line 46: @@
 Basic walk-through of what the script will do.
-# Put your site into maintenance mode - Important step to prevent database corruption.
+# Put your site into maintenance mode - Important step to prevent database corruption/increase the speed and reduce locking of tables
 # Truncates the above tables
 # Repairs any tables that are in need of repair

@@ Line 29: / Line 29: @@
 * dataflow_batch_import
-Additional Enterprise tables need
+'''Additional Enterprise tables need'''
 * enterprise_logging_event

@@ Line 55: / Line 55: @@
 * Link to Community Version - [http://briansnelson.com/stuff/magento-ce-db-optimize.script Download the script]
 * Link to Enterprise Version - [http://briansnelson.com/stuff/magento-ent-db-optimize.script Download the script]
 '''This script needs to reside in your sites top level directory'''